Recent content by rajput

Would like help on creating an access database for my company which will record items delivered to our customers. I am attaching a report in pdf format that we want to print out. http://204.202.252.199/4/setup-report.pdf The MAKE Field(Product’s Company name) field will have items like...

Thanks Neil, it worked beautifully. Thank you. I would also like to thank Pat, Peter, Keith for there help. Rajput

Thanks Pat for the above explanation, but how would I convert the date I am getting from the Unbound text box(txtInput) in my form. The unbound box is not only getting the date it is also getting the other data like in example listed below: _______________ DOE.JOHN.221183.PT45454545.M.UK1...

Thank you Pat, However I am a novice in this field. Can you tell me where to put/insert this code? Thanks Rav

Thanks Keith, my bad I totaly forgot about the txt part. I did not have the txt in my database. This part is working fine now. Date part also worked fine with inputing the slashes. I have to check if the keyboard program can input the slashesh. But if not then how can I convert a string to...

Dear Neileg, as you suggested in your sample database, I copied it to my database with exact field names but it is giving me Microsoft Visual Basic error window saying "Compile Error: Variable not defined" and it is highligting the "Private Sub txtInput_AfterUpdate()" with yellow and...

Thanks Andrew, That worked perfect. Rajput

Hi, Just wondering how can I make a form that shows only 5 months old records. I know it has to be through a query but don't know how to proceed. Thanks Rajput

I am so sorry Pat, will not happen again. And thank you very much Neileg for that sample. I think it will work, however I am keeping my fingers cross as I am still awating the shipment of the keyboard. Will bother you guys again, if i have further questions. Thank you Rajput

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

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

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

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

Sorry I am posting again since I am still stuck, but now I am posting it with an example. This might help what I want to accomplish. ALSO People have suggested me to make two tables and have one-to-many relationship, however the data is allready inputed, and it will be difficult to arrange all...

I think it is called MRP (Machine Readable Passbook/Passport) however it could be OCR.