Magstripe Cards Reader

D

Duane

I am a relatively inexperienced database developer with limited knowledge in
programming. I have done extensive research in the area of Magstripe Card
Readers, HID Drivers and devices, and it seems that the more I read, the
more confused I get. Not to mention, I get more questions then answers.

I would like to incorporated the use of a Magstripe Card Reader for scanning
employee ID Cards. I am not sure what all is one the ID Cards, as I have
not successfully read one yet. I do know that at least on of the tracks
contains the Employee's ID number (HRMN #), which is what I would like to
extract, and then insert into my database.

I have a form opened on my database for issuing equipment to employees. One
field has the focus all the time. Every second the form refreshes and
whatever is scanned into the field via a barcode scanner is assigned to
textbox. Then the field is cleared. When the equipment assigned is
finalized, an update query is run.

The problem is that the employee ID Cards have the magstripe on them with
their ID# encoded in them. As a work around someone makes barcode labels
and affixes them to everyone's ID card. This has been being done for years.
Long before my coming along. Of course they get worn, removed or whatever.
Plus there is considerable employee turnover, mostly new employees.

I truly don't expect for anyone to explain to me in great detail how to
achieve this, of course I wouldn't say no:). I am just asking if anyone
has any experience with this? If it is something a novice can do? Do I
need to be a VB or C++ Programmer to achieve this? Where I can go to learn
about it more.

Thank you in advance for any insight in this matter.
 
S

strive4peace

Hi Duane,

most important: get a reader that you can program to insert a TAB
character after the scan is done

the reader is simply an alternate input device. As for Access, it cares
not if you swipe a card with a reader or type the entry from the
keyboard -- but following it with TAB is important so that you know when
the reader entry is done.

Then, you can use the AfterUpdate event of the control to parse the
data, look up stuff, and take other actions

Warm Regards,
Crystal
remote programming and training

*
:) have an awesome day :)
*
~~~~~~
Learn Access on YouTube!
http://www.youtube.com/user/LearnAccessByCrystal
~~~~~~
Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace
~~~~~~
 
A

a a r o n . k e m p f

yes, you do need to be a vb programmer in order to do _ANYTHING_ with
databases

sorry, but vb isn't that hard to learn
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top