How to get import data into the FORM from Machine Readabe Zone in the Passport

[rajput]

How to import data into the FORM from Machine Readabe Zone in the Passport

Hi,

I have this project where I need to scan the MRP zone on the passport to my form. Let me first explain what is MRP zone. MRP is know as Machine Readable Passport Zone which you usally find on the first page of US Passport right under the Photographs and it looks like this

P<USAERIKSSON<<ANNA<MARIA<<<<<<<<<<<<<<<<<<<
0550667081USA6908061F9406236ZE184226B<<<<<14

1st Line
So P stands for Passport and Contry code is USA and then last name Eriksson and first name Anna and middle name Maria.

2nd line
Passport number and Date of birth and sex and so on.

Now I am in process of ordering a keybord that has a MRP reader on the top( http://www.accesskeyboards.co.uk/ATB420 Reader.htm ) from this company in UK. You can find the specification on the keyboard from the above link.


So as soon as I scan/swipe it, it will give me information in the following format.

FIRST NAME, LAST NAME, DOB, SEX, PASSPORT NUMBER.



SO ONCE I HAVE THE INFORMATION IN COMMA FORMAT, HOW DO I GET THIS DATA INTO MY RESPECTIVE FIELDS INSTANTLY, AS SOON AS I SWIPE THE PASSPORT.

My field name in the table are

LastName
FirstName
BirthDate
PassportNo
MaleFemale



Thanks.

Rajput

 

[RV]

Import a text file into Access, that should give you an answer to your question.

Rv

 

[rajput]

Thanks for the quick reply. However I am new to access. If you someone can explain in detail HOW DO I GET THIS DATA INTO MY RESPECTIVE FIELDS INSTANTLY, AS SOON AS I SWIPE THE PASSPORT.

My field name in the table are

LastName
FirstName
BirthDate
PassportNo
MaleFemale

Thanks

Rajput

 

[neileg]

You're not helping us to help you!

The keyboard is reading this data. I presume that this will appear as a string of characters in the keyboard buffer. So you need to create a form with a text box on it. Make sure the cursor is in the text box when you scan the passport so that the string appears in this box.

Next you will need to chop up this string of characters to reterieve your data. I would use some VBA code to find the position of the first comma and read the characters up to this position which will be the first name which you then assign to your field, FirstName, and so on.

If the data is not presented as a string of characters separated by commas, what does it do?

 

[rajput]

Thanks Neileg,


String of characters that will be reterieved from the keyboard will allready be broken down with commas and decoded. They just have to be sent to the right fields.

For example we recived after swiping the passport --->

DOE, JOHN, 201199, 123456789, F

After we get this, I want the "DOE" to go to my LASTNAME field.

"JOHN" to my "FIRSTNAME" field on the form

"201199" to my "BIRTHDATE" field

"123456789" to my "PASSPORTNO" field

"F" to my "MALEFEMALE" field.

Thanks

Rajput

 

[RV]

Create a table with the appropiate columns.
Use the import facility to import the data and load them into your table.

It's rather straight forward, but you'll have to put a bit of effort into to yourself.

RV

 

[neileg]

Create a table with the appropiate columns.
Use the import facility to import the data and load them into your table.

No, the data won't need to be imported, it will appear as if it is a keyboard input.

String of characters that will be reterieved from the keyboard will allready be broken down with commas and decoded. They just have to be sent to the right fields.

Yes, and I have explained how to do it. You need to learn some VBA or possibly post a question in the VBA forum for some help.