Barcode scanner and inventory management, how to scan & search for ent

[MinL]

Hello,
I am new to MS Access. I would like to know is it possible to do the following?

I have an inventory list of many items with bar code numbers in Excel file. I imported that into Access. So.. is it possible to do this: As soon as I scan a bar code on an equipment, it will look through the database to see whether it exist or not? If it does not exist it will tell you. (And it will be even better if it will have an option that lets you mark that the item is there).

Is there any tutorial on this sort of inventory management? I tried to search but I didn't get any result that meets what I want. Please advice, thanks in advance.

P.S. Once again, I am new to MS Access. I would love to have some guides on what I am supposed to be looking into if I want to learn more about this sort of database management. Though this case is urgent, so I would love possible solutions. Thank you again.

 

[TheAceMan1]

How are ya MinL . . .

Move your post over to: forum694

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[SkipVought]

MinL,

Just think of a barcode scanner and an alternative to keyboard entry. It's just easier, quicker and more accurate, to scan a value than to key in a value from the keyboard. So whatever you can do from the keyboard, you cn do with a scanner.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[lespaul]

and just think of a barcode as a font....if you decode the barcode you'll just get a bunch of numbers/letters.

Leslie

Have you met Hardy Heron?

 

[MinL]

I realized that what I think will work out well for this problem is using macro, except I don't know how to write the macro exactly for my need Anyways, I made a new post with detail problems in here:

http://www.tek-tips.com/submitpost.cfm?pid=181

Please help, thank you very much.

 

[MinL]

Ops, wrong link. It is this one:

http://www.tek-tips.com/viewthread.cfm?qid=1524855&page=1