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.