Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 672
  • Last Modified:

Access Coding Question, Barcode Base 32 Compression

I am an intermediate MS Access 2007 user.  I have dusted off an old project that I was working on and have run into some trouble with the "Mid" function.  In the attached database I have an input box (txtinput) located in "frmPersonnalinformation" that decompresses a base 32 compression string into Social Security Number (SSN), and Electronic Identifier (EDI) using the "BtoB module" and it also formats several dates using the "DtoD module".  The same string also has the first name, last name, and middle initial that is uncompressed.  When I run the code (Mid) to parse out the text, nothing appears, and It should, based on the fact that I can get it to work in the query "qrypersonnalinformation".   This database's basic function, allows employees to use their current ID card to sign in for accountability utilizing an existing PDF417 barcode.  Their is more data in the string of text, however, I am working on just one part at a time. Any assistance you could provide will be greatly appreciated.  Any other recommendations you could see to streamline my process would also be greatly appreciated.
Database1.accdb
Example-Strings-1-.txt
0
Kinlene
Asked:
Kinlene
  • 2
  • 2
1 Solution
 
als315Commented:
Check this example (paste string and press add button)
Database1.accdb
0
 
KinleneAuthor Commented:
Great!  You did more than you had to.  My partner and I have a few questions.  Obviously , "me" declares that the form is the location of the data got it.  Why was it working for the other complexed processes and not the simple ones?.  Also, you declared the variable Dim Db as Database and Dim rs As Recordset.  What did this do that made access look at the data differently?  I hope you understand, I really want to understand what it did.  "Give a man a fish, feed him for a day."  "Teach a man to fish, feed him for a lifetime."  Thanks!
0
 
als315Commented:
In your example variables was not declared. Me.SSN means SSN field in current form. SSN means variable, which can be used later, but it was not used.
Sorry for Dim, it was beginning of other idea (write records directly to table and use your variables, but if you have form, it is not nessary). Delete these declarations.
0
 
KinleneAuthor Commented:
Thanks
0
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.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

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