Bar Coding

[howard]

I would like to know that if one sets up a field for a bar code in access and one has a bar code scanner, how one can integrate the 2 systems, so that when you want to generate a bar code for a particular product from the bar code scanner, it will automatically put the bar code into the correct field in Acccess

Your assistance in this regard will be most appreciated

Howard

 

[Andrew Fergus]

Hi

Create a form that has the details you want to see, and when the cursor is on the field that contains the barcode value pull the trigger on the scanner - the PC should take care of the rest for you. I recommend you experiment with scanning barcodes while running various applications to see exactly what happens.

Andrew

 

[howard]

Hi Andrew

Thanks for the advise

Regards


Howard

 

[ExcelIsEvil]

Any txt box on a form should be able to capture the 'scanned' barcode from the gun.
Make sure that your barcode scanner is configured correctly for your form. Some will automatically vbCRLF after the scan. This is done for the ease of entering multiple scans on a form.

Example:
Height
Width
Length
Each is a txtBox on form capturing the scanned code from bill of lading. The vbCRLF allows for three clicks by human, or auto for machine processing on belt.

 

[howard]

Hi ExcelIsEvil

Thanks for the advise

Much Appreciated

Regards

Howard