Laser Scanners and Access 1

[soulfunkuk]

Is there anyway of scanning barcodes into an access database via a form????

 

[evalesthy]

Not hard to do. Search this forum under keywords.

Also, browse the web. Here is one reference.

http://www.teklynx.com/welcome.html

 

[soulfunkuk]

Hi evalesthy,

My real question I suppose is how would I setup the MS Access form.

Apparently the scanner is datmatic scanner.

Thanks

Soul

 

[soulfunkuk]

Sorry I meant datamatic scanner.

Basically the warehouse dont want to manualy enter the barcodes onto the database they want to be able to scan them on to the database.

 

[MichaelRed]

Any / all scanners are essientially auxillary keyboard devices. In general, you only need to provide somewhere for the input to go (e.g. a set focus operation). In more robust apps, the scanner is set up with codes which are recognized by the app to do the set focus thing and then do some preprcoessing of the input. Look at the docs which come with the scanner for detailos of the programming. The ones I am currently involved with allow all scan inputs to include a prefix and / or postfix code. We use the prefix as a "Function Key", recognized by the application to open a scanner input form. The form sets focus to the input field, receives the input and recognizes the end of the scan as the signal to move focus to the next field. The loct focus event of the input field checks the input field and determines wheather the data represents one of the few items we recognize (part number, serial number, or job number). If the scan input matches the requirements of one of the fields, the code passes the value and the field type to form which was active when the scan code was received. If theinput is not recognized, the scanner is sent another code which is used to output a beep code, hte input field is cleared and the input forn is closed).




MichaelRed

 

[soulfunkuk]

Cheers MichaelRed that makes perfect sense!

 

[addy]

We do a lot of barcode scanning into MS Access. We manage and control documentation and each document is uniquely barcode. I have set up fairly simple applicatios which enable you to scan the document in and then an action will be performed based on the input. For example, we send documents out on loan to people, before, we would have to search the database for the document record we were loaning out and then manually update the data to show it was on loan. Now, we simply scan the barcode, and the database automatically updates the correct record to show it being out. Very quick and very accurate.