Can I Setup Access to Automatically Print a Label with a Specific Record on Scanning a Barcode?

[CCOutlet]

So I would like to setup Access to automatically print the value from the stock number record in my inventory database when I scan the serial number for a particular piece of inventory. Our inventory already contains the serial numbers, so I need Access to search the database, find the correct serial, and then automatically print the corresponding stock number on a Dymo LabelManager USB. The barcode scanner I have is a Symbol LS2208 and the version of Access is 2007.



How would I go about doing this? From what I've found via Google it appears that it will take a bit of programming, but I'm not sure exactly how to go about doing that since I haven't been able to find anyone with a similar situation.

If necessary I can upgrade to a newer version of Access or switch out the label maker or barcode scanner as needed.

Thanks in advance!

[aytee111]

First, set it up manually - create the query and the report and get it working. Then in the appropriate event, at the time of the scan, print the report (either thru VBA or a macro).

[ranman256]

youd scan then load, then print.
the form would be a continous form of all records. Textbox barcode in header.

'after the scan, barcode is in textbox

vID = Dlookup("[ID]","table","[barcode]='" & txtBarcode & "'")
if isNull(vID) then
   msgbox "Record not found"
else
  me.filter = "[id]=" & vid
  me.filterON = true
  
  docmd.openreport "rLabel"
endif