mitch_johnson
Registered User.
- Local time
- Yesterday, 22:58
- Joined
- Mar 18, 2009
- Messages
- 40
Hello i am quite new to access i have been using it for a couple of months now and am getting the hang of it i dont know any VB code but i know all about how to put code in and how to use the properties window (i am using access 2007) what i want to do is as follows:
1. i have a magnetic card reader (KEYBOARD emulation input device) when i scan a card it displays data all in one place so on a card is the card number, the expiry date and start date so i would scan in like follows: 456798987898009009080911 with red being the card number, green the start date and blue the expiry what i want to do is be able to click a button and seperate the three pieces of data into seperate fields EG: card number (RED) into a field names card number ETC.... this is all in a form in access incase you were wondering please help i have looked everywere on the internet with no luck. thanks
1. i have a magnetic card reader (KEYBOARD emulation input device) when i scan a card it displays data all in one place so on a card is the card number, the expiry date and start date so i would scan in like follows: 456798987898009009080911 with red being the card number, green the start date and blue the expiry what i want to do is be able to click a button and seperate the three pieces of data into seperate fields EG: card number (RED) into a field names card number ETC.... this is all in a form in access incase you were wondering please help i have looked everywere on the internet with no luck. thanks