By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,544 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

Card Reader Information

P: n/a
Thank you for all your help and assistance, it's greatly appreciated. Is there
a way in Access, any version to capture the mag stripe information and place in
appropriate textboxes? i.e. Lastname, Firstname, MI, Address, City, State, Zip,
Phone, if all this is in the same order on the mag stripe?

Michael
Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
lu*************@aol.com (Lumpierbritches) wrote:
Thank you for all your help and assistance, it's greatly appreciated. Is there
a way in Access, any version to capture the mag stripe information and place in
appropriate textboxes? i.e. Lastname, Firstname, MI, Address, City, State, Zip,
Phone, if all this is in the same order on the mag stripe?


You need to talk to the vendor of the mag stripe card reader to see what software
mechanism they have for you to pull in that data. A DLL, OCX or other which will
allow you to extract the data from the card reader.

Unless the mag stripe card reader sits between the keyboard and the PC. Which is
unlikely but possible.

Note, however, that many OCXs don't work well or at all in Access.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #2

P: n/a
Thank you Tony. The mag stripe reader is just a basic input device that when
it's swiped places whatever is on the card into a textbox or word processing
document. I will read any type of mag stripe card and show the data on that
stripe in any text holder. I have tried it with MS Word, Notepad, Wordpad and
just one textbox on an A2000 application. I want to be able to extract the data
that would be in a delimited format more than likely; i.e. spaces etc on the
mag stripe.

Michael
Nov 12 '05 #3

P: n/a
Michael,

From your description here and from your original post, you need to look at the
following functions in Help or some reference:
InStr
Left
Mid
Right

The info from the mag stripe reader will be a string and you need to use the
above functions to parse out the individual data elements.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com

"Lumpierbritches" <lu*************@aol.com> wrote in message
news:20***************************@mb-m01.aol.com...
Thank you Tony. The mag stripe reader is just a basic input device that when
it's swiped places whatever is on the card into a textbox or word processing
document. I will read any type of mag stripe card and show the data on that
stripe in any text holder. I have tried it with MS Word, Notepad, Wordpad and
just one textbox on an A2000 application. I want to be able to extract the data that would be in a delimited format more than likely; i.e. spaces etc on the
mag stripe.

Michael

Nov 12 '05 #4

P: n/a
On 08 Apr 2004 09:51:47 GMT, lu*************@aol.com (Lumpierbritches)
wrote:

When the device has done its magic, the <textbox>_Change event will
occur. That's where you should write code to pick apart the data. If
you are lucky there is some separator character, perhaps a comma or a
tab. Use a combination of InStr, Left$, Mid$, Right$ to write your
code.

-Tom.
Thank you Tony. The mag stripe reader is just a basic input device that when
it's swiped places whatever is on the card into a textbox or word processing
document. I will read any type of mag stripe card and show the data on that
stripe in any text holder. I have tried it with MS Word, Notepad, Wordpad and
just one textbox on an A2000 application. I want to be able to extract the data
that would be in a delimited format more than likely; i.e. spaces etc on the
mag stripe.

Michael


Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.