Kinlene
asked on
Access 2007 Database Coding Issue, Base 32 Compression string on a PDF Barcode
I am an intermediate user of Microsoft Access 2007 and have recently started working on a old project application that I never finished. Basically this application takes a barcode string decompresses the Social Security Number and Electronic Identifier which is compressed using a Base 32 string (On the Barcode) and places the decompressed data in to the respective field in the associated table. I am not proficient in VBA coding but have been working with my co-worker who is and he can't understand the differences between the VBA in Access and the Microsoft Visual basic .net. that he is familiar with. I'm sure I have attacked the problem in the wrong way. The Module works well in VBA but I can't get it to work in Access or at least without coming up with errors on execution. After closing the form and reopening it, it appears to work, however, I don't know why I get the errors. I have programmed the "Call" for the module in the Exit of the "txtinput" field. The field will eventually be used with multiple barcodes and I have provided four example strings in a separate attachment. The basic purpose of the database is to store attendee sign-in information using a barcode scanner and existing employee identification card in lieu of a sign-in sheet. I would appreciate any assistance you could provide.
Database1.accdb
Example-Strings-1-.txt
Database1.accdb
Example-Strings-1-.txt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.