Link to home
Start Free TrialLog in
Avatar of Kinlene
KinleneFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of als315
als315
Flag of Russian Federation image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial