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.
Who is Participating?
als315Connect With a Mentor Commented:
Remove .Text
I am not sure in "On Exit" event. May be better to use after update?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.