This is probably going to be a simple problem you all you experts out there
but....I'm stumped.
I'm using a card reader to scan cards for membership entry into a health
club. I am bringing up a form that has the first field that allows the card
to be scanned.
My problem is two fold.
1). The card scans perfectly into the field BUT all the "grabage characters
at the begining and the "?" at the end are also included. How can I get the
"field" to eliminate the preceeding characters and the last "?" and display
ONLY the numbers. There must (I hope) be a way to ignore the first 4
characters and the last character. (All the cards a identical) so I should
be safe eliminating the same chars on each read.
Below is an example of a card scan.
;:<>4054969364?
Ocen this is done, I hope to be able to automatically have Access lookup the
name attached to this number (That should be easy enough.). But one problem
at a time.
Thanks
=Dave R.=
[Non-text portions of this message have been removed]
SPONSORED LINKS
| Microsoft access database | Database development software | Database management software |
| Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
