Bar Code Read and Writing

[SmagO]

Hello,
I have a requirement to print a large volume of certificates. Each certificate has a unique number. A Hologram gets appended to each certificate, and the Hologram also has a unique number. Once the hologram has been stuck to the certificate, the certificate number hologram number combination needs to be populated into a SQL database.

There are too many certificates to do this manually.

So, we will print a barcode onto each certificate, and we will use Holograms that have barcodes. Then we will use a scanner to insert the certificate number/hologram number combination into SQL.

The front end is unfortunately Access.

Any suggestions about the product that I should use to do this?
Or a suggestion about an alternative approach that I should follow?

Thanks in advance.

[appdalesolution]

there is a program called TU3 that we use with Denso handheld barcode scanners, its a dos based program that acts as an interface between the scanners.

I have worked on an app with Microsoft Access to do this, what we did was called the TU3 program from Access, the program then extracts a text file from the scanners, which u can then open and read into an access table.

Not entirely sure what u want to do, but i could point u in the right direction, feel free to ask me any questions.

[SmagO]

Thanks,
I would pretty much need it to be something that I build into my Access front end.

The use case would be:

1. User clicks on the "Enter Holograms" button
2. User scans the certificate bar code
3. System determines the certificate number and loctaes the certificate
4. User scans the Hllogram bar code
5. System determines the hologram number and populates it against the selected certificate (from step 3)
6. User clicks "next"
7. steps 1 - 6 repeat until the user exits the module.

So I need to be able to create bar codes, and read the bar codes.

Thanks