Solved

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

Posted on 2011-02-21
1
502 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 39

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

831 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