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.
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.