By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,694 Members | 1,622 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,694 IT Pros & Developers. It's quick & easy.

Bar Code and Scanner

P: 110
Hello All,

Revamping an old database from scratch - how exhilarating!

I have a system that prints work order forms. Once the work order has been complete, someone scans the work order to a local hard drive. Then we link to the file by using the file name. (I wrote some VBA to search folders for the file name which is also the work order number).

In any event, this requires someone to rename every file that we scan so that the database can find it. I was wondering if anyone has seen/heard/used a bar code program that could print out on the work orders and could rename the file when scanned.

As always, thanks in advance for any insight.

Feb 7 '14 #1
Share this Question
Share on Google+
4 Replies

Expert Mod 5K+
P: 5,397
That would be something to ask the Barcode vendor about me thinks.


If the BCR acts as a keyboard wedge, then, one could have the following:
select current file
scan BC
Terminate as Keyboard [Enter]
VBA code to validate things and perhaps renames file on afterupdate trigger, and/or maybe place a message box in the before update with Yes/[NO] to confirm with [no] default.
Office Visual Basic Language Reference>Functions
will have referene to NAME(), DIR() etc... that can handle things such as renameing the file and ensureing that you have the file available etc..
Feb 7 '14 #2

P: 110
Thanks, ZMBD.

I didn't think there was an easy way to get around this but thanks for your advice - I'll try reaching out to a scanner OEM.

Best regards.

Feb 8 '14 #3

Expert Mod 5K+
P: 5,397
Not always easy; however, usually doable.
Let us know what we can do to help. (^_^)
Feb 8 '14 #4

P: 110
Thanks again, ZMBD. I've got emails out to two OCR companies - I'll update here if I any worthy news or a good product.

Feb 9 '14 #5

Post your reply

Sign in to post your reply or Sign up for a free account.