RFID / Barcoding

[Bob McClellan]

I received a request to add some functionality to one of
the .ADP / SQL2005 Apps we are using.

The request deviates significantly enough from normal ops
that I hesitate to pose the question here but need to start somewhere.

They want employees to use their badges to check out bar coded items.
Setting up the forms and tables obviously is not a problem.

My question is this... does anyone have any experience they can share
with:
1. using an RFID device to receive input and write it to a table
2. using a barcode reader to write to a table.

I apologize for posting to this NG but did not know of an 'Appropriate' NG
to post to.

Thanks in advance,
Bob.

 

[Tony Toews [MVP]]

My question is this... does anyone have any experience they can share
with:
1. using an RFID device to receive input and write it to a table

You'll need to talk to vendor of the RFID reader to find out what kind
of support they offer for you to use within Access. If they have VB
6.0 support that will usually work quite well within Access.

2. using a barcode reader to write to a table.

Barcode readers generally look like a keyboard connection. Either
USB or between the keyboard and the PC if a PS/2 port. So reading in
the bar code fills in a field on the form. You can test this by using
Notepad. Note that you can usually do some programmatic fiddling so,
for example, a Tab is inserted after a scan so it jumps to the next
field.

Tony

 

[Bob McClellan]

Excellent.
I appreciate the reply and the advice.
Thanks Tony.