Solved

Access 2007 Database Coding Issue, Base 32 Compression string on a PDF Barcode

Posted on 2011-02-21
1
511 Views
Last Modified: 2013-12-25
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
Comment
Question by:Kinlene
1 Comment
 
LVL 40

Accepted Solution

by:
als315 earned 500 total points
ID: 34942742
Remove .Text
I am not sure in "On Exit" event. May be better to use after update?
Database1.accdb
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question