469,579 Members | 1,240 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,579 developers. It's quick & easy.

Card Reader interfacing an Access Database

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
Nov 12 '05 #1
3 9270
Ello, Sherry.
1. data format (;XXXXXXXXX=0229) you receive from the card reader is how they
programmed the card reader. You, as a interface programmer, need to extract the
right data from the data you received.
2. Since you mentioned VB, you can use 'mscom' controll to receive the same
data. Then, use 'mid(string,start,end)' function to extract the data you want.
3. Use this new string to interact with access database
4. Pop up screen is also simple to generate. Look in the key word 'show' in
help. show is to show the form to the screen.

Let me know if you need more information.

Phillip Kim
"Cherry" <cd******@purdue.edu> wrote in message
news:ba**************************@posting.google.c om...
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

Nov 12 '05 #2
C D
Phillip,

You say that I need to extract the data using string function to pull
out just the numbers that I need.
Where do I put this string? on got focus on the bound control?
The message that I want to pop up once they are logged on I believe will
need something like an if then set up but I don't know how to do that. I
don't know what the mscom control is that you refer to. I have done
years of basic stuff with Access but this is beyond my skill sets.
Thanks for your help. At least now I know it isn't doing anything wrong.
CL

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #3
Hello, Sherry.
1. Do you want to VB as front end application and Access as back end database?
2. If this is the case, you need to learn the basics of VB. About a week will do
the job.
3. Try to look in 'creating a form', 'show form', 'hide form', 'text box',
'label', 'command', 'mscomm','string funcition (Left, Right, Mid, Trim)',
'activeX data control'...
4. Since Access does not have serial communication control, you need to use VB
(mscomm control) instead.
5. By the way, how did you receive data from card reader?
6. Assign string to global variable so that you can use it to retrive data from
access table.
7. Create a form with one label and a command button.
8. When card reader send you a data, use mscomm and string function to extract
data, then use this data (social security) to retrive information from access
table and display to the form.
I hope this helps little.

Phillip Kim

"C D" <cd@yahoo.com> wrote in message
news:3f*********************@news.frii.net...
Phillip,

You say that I need to extract the data using string function to pull
out just the numbers that I need.
Where do I put this string? on got focus on the bound control?
The message that I want to pop up once they are logged on I believe will
need something like an if then set up but I don't know how to do that. I
don't know what the mscom control is that you refer to. I have done
years of basic stuff with Access but this is beyond my skill sets.
Thanks for your help. At least now I know it isn't doing anything wrong.
CL

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Billy Jacobs | last post: by
4 posts views Thread by Lumpierbritches | last post: by
4 posts views Thread by Jerry Camel | last post: by
12 posts views Thread by Jerry Camel | last post: by
reply views Thread by Simon Verona | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.