MS Access条形码检票 [英] MS Access barcode ticket checking

问题描述

大家好，我有一个简单的程序，我想在访问中设置一个数据库进行票证扫描（票房风格），我需要一些帮助。

Hi All, I have a somewhat simple procedure that i want to setup a database for ticket scanning (box office style) in access which i need some help with.

简单的细分是;

我有序列编号的票据，我希望能够使用条形码扫描器扫描，然后检查数字是否存在，然后检查是否存在它已被扫描过。如果未扫描，则将该数字标记为已选中，显示与数据表关联的名称
并等待下一次扫描。  如果扫描已经显示警告消息（以避免票证欺诈）。

I have serial numbered tickets which i want to be able to scan with a barcode scanner, which then checks the number to see if it exists, then checks to see if it has already been scanned. If not scanned it marks that number as checked, displays the name associated from a table of data and waits for the next scan.  If scanned already shows a warning message(to avoid ticket fraud).

我知道这应该太难了，尽管自从访问和我的记忆以来已经有几年了让我失望。

I know this should be too hard, though it has been a few years since working with access and my memory is failing me.

我的表格设置很简单：票证＃（自动和普通键），姓名，电话，售票（真/假），票证输入（真/假），票证扫描（条形码输入）。

My table setup is simple: ticket # (auto and prim key) , name, phone, ticket sold(true/false), ticket entered(true/false), ticket scan(for barcode entry).

我只需要设置以下程序;票据扫描，如果存在售票，如果售出售票票，

I just need to setup the following procedure; ticket scanned, if exist check ticket sold, if sold check ticket entered,

- 如果未输入显示"已确认"可能还有名字和与票证相关联的号码。

-if not entered display "confirmed" and possibly the name & number associated with ticket.

- 如果已经输入显示"已经扫描过警告票"<

-if already entered display "warning ticket already scanned"

我希望我的描述是直截了当的，任何帮助都会非常感激，一旦我完成并且运作良好，我可能最终会公开给别人。

I hope my description is straight forward, any help would be extremely appreciated and i may end up making this publicly available for others once i finished and is working well.

提前致谢：）

Troy

推荐答案

<特洛伊，

欢迎。

这篇关于MS Access条形码检票的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！