• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 552
  • Last Modified:

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
0
Kinlene
Asked:
Kinlene
1 Solution
 
als315Commented:
Remove .Text
I am not sure in "On Exit" event. May be better to use after update?
Database1.accdb
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now