Solved

Access Coding Question, Barcode Base 32 Compression

Posted on 2011-02-21
4
640 Views
Last Modified: 2013-12-25
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
Comment
Question by:Kinlene
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 40

Accepted Solution

by:
als315 earned 500 total points
ID: 34949540
Check this example (paste string and press add button)
Database1.accdb
0
 

Author Comment

by:Kinlene
ID: 34949906
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
 
LVL 40

Expert Comment

by:als315
ID: 34950148
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
 

Author Closing Comment

by:Kinlene
ID: 34951388
Thanks
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
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…

734 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