I have an ID Innovation card reader that I am trying to connect to my
Access database. The first problem is that when I swipe the card
through the reader, it reads the id but it adds digits to the social
security number, thus the database doesn't recognize the id since it
wasn't put in the database with the additional digits.
Here is what it puts on the screen in the database::
;XXXXXXXXX=0229? The x's stand for the social security number - it
adds the semi colon at the beginning and the =0229? at the end. Why is
it doing this and how can I get it to just enter the social security
number or personal id?
Also, when we swipe the card, the folks would like a welcome screen to
pop up that says Welcome blah, blah Joe. I would need to have a query
set up to first seach for the id and then can I use a macro to push
the welcome message to the individual? I don't have any experience
writing vb.
The manual that came with the card reader doesn't help, the files that
I downloaded have information on them but I don't know what I don't
know here. Any help will be appreciated.
Cherry