Barcodes in a Access

E

Ed

I can scan barcode information into one table. But since the barcodes has a
several field dat infos I need to break the barcode information into several
tables. Example: 123456789BARCODE20050503> the first nine numbers would be
employee iD numbers the second (BARCODE) would be the employees name and the
third would be todays date. Each item should have it's own table. Can
anyone help me on this? Thanks
 
K

Ken Eisman

Ed said:
I can scan barcode information into one table. But since the barcodes has a
several field dat infos I need to break the barcode information into
several
tables. Example: 123456789BARCODE20050503> the first nine numbers would
be
employee iD numbers the second (BARCODE) would be the employees name and
the
third would be todays date. Each item should have it's own table. Can
anyone help me on this? Thanks
Click to expand...

First of all, I'm assuming you mean 'fields' whenever you say 'tables.' If
that's not true, then this could still work but you'd have to modify it.
I'm also assuming that, since this is a barcode, all the fields are of a
fixed length.
I'm also assuming you have 4 fields on your form: txtFullCode (can be
unbound all the rest are bound to fields in your table), txtEmployeeID,
txtEmployeeName, txtDate
I'm also pretty new to all this so everything I'm telling you could be wrong
or there could be a better way to do it.
This is all untested 'air code.'

That said...
1. scan the barcode into a field called txtFullCode
2. create this code in the OnExit event of txtFullCode
Me!txtEmployeeID.Value = Left(Me!txtFullCode.Value,9)
Me!txtEmployeeName.Value = Mid(Me!txtFullCode, 10,7)
Me!txtDate.Value = Right(Me!txtFullCode.Value, 8)

That should do it.

HTH
Ken
 
Top