View Full Version : Type Mismatch/"Binary" in listbox


nmoudgil
02-26-2009, 12:11 PM
I couldnt' find anything on the net soo here's my problem.

We have a vba access runtime application and this application was installed on a computer that was recently formatted and then was installed with Windows XP SP3 edition. After I install the runtime application the user is unable to insert/update anything to the database. I am sure it's able to reach the database since he's able to run search forms.

The error that comes up every single time user clicks on the "insert" button or "update" button is: "Type Mismatch" error. Which I assume has an error number of 13. This same application is working perfectly fine on all the other machines with windows xp or with windows 2000 and so on. Even on a machine that has SP2 and SP3. Moreover, in one of the searches that brings results back to listbox. One of the columns always says "Binary" even though it should give the user some sort of number like: 22-33-23-65. The reports that we generate also is showing bunch of "Empty Boxes" and weird characters instead of the number I mentioned above. Please help!!!!!

nmoudgil
02-27-2009, 06:45 AM
Any suggestions are welcome. I have checked the regional settings on users computer. But that doesn't seem to be the culprit. Any Help?!?!?