Using a Scanner to input data

[Mick W]

Does anybody know of a system that could scan tick boxes from a pre printed form and interface with a database to input data.

 

[FoFa]

There are many of them out there, it just depends on your needs. Some come with dedicated software (job specific), some will emulate keyboard entry, and can be used with almost anything, but you have to be careful with development and cursor movement. Of course the market changes on a frequent basis and when I researched this for my company a couple years ago, is most likely is not the same as it is today. We are using bar codes so the application is different, but later I have to research the same thing you are doing as our benefits dept. want to scan benefits forms and they also have check boxes. Good Luck

 

[mr moe]

Fofa,
I"m investigating this project, what is the best thing for ms access and is it possible.

 

[FoFa]

With Access and it's VBA limitations, you either need something that can interface directly (like Keyboard Imulation) or a ActiveX/COM/COM+ object you can interface with. Since I only have experience with the Keyboard Impulator type I can only speak on that, and it works pretty good, as long as you start the program (keyboard impulation program) and you can control the tabbing and input. If I had to do it today I think I would look for a COM+ object interface that would give me the control I want from the program easier.