Question Barcode scanner and inventory management, how to scan & search for entry?

[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.

 

[ezfriend]

I forgot how the scanning system work, but here is something that I did a while back.
We use to read those card reader. When you slide a card, the reader will display the card number on the text box. on the Change event for the textbox, check for the length of the card number (my case 12 characters). If it is 12 characters long then call a process

private function CheckExistingCard(byval sCardNumber as string) as Boolean
   dim rs as recordset
   dim sSQL as string

   ssql = ""
   ssql = ssql & "SELECT COUNT(*) FROM tblCardNumber WHERE CardNumber = '" & sCardNumber & "' "

   set rs = currentdb.OpenRecordSet(ssql)

   if rs(0)>0 then
        CheckExistingCard = true
   else
        CheckExistingCard = true
   end if
   rs.close
   set rs =nothing


end function

 

[neileg]

There a few threads in here on barcodes so a search may be useful. Most barcode scanners simply feed the code into the keyboard buffer, so it's just the same as typing it in as far as Access is concerned. Once you have the code in a control on a form you can compare it with your table of codes.