Hello,
So I just started an IT support position at a company and one of the first big problems I have, I have no idea how to solve it. I have been looking and trying things for days. Here it goes...
They had this program written just for them. You put in a model number and quantity and things, then it accesses an Access database, and it will print out a page with the information on it. They only use this program from 1 computer and it is basically all that it does. Apparently one day they went to go do the same thing they always do, and when they go to print you get a Runtime Error 3421: Data type conversion error. While looking it up it looks like people have had this issue while making changes in their code and what not but I don't even have access to the source code. I don't know programming anyway. They can't remember if they have ever gotten this error code before but when they did get error codes, it would be because they wrote a letter or something instead of a number in one of the boxes. Normally they would just go into the access database and delete the mistake and it would work again. My boss said he did that this time and it is still not working.
The program and the file is on a shared drive coming from the server.
ALSO, when I go into the Access database they are using, I get an error saying that it cannot access the reference to "mail.ocx" version 1.0. When I go into the references it says it is MISSING: TTC mail control or something like that. It says the files location is C:\WINNT\system32. I guess that would be on the server and since it is coming from the shared server it recognizes the C:\ drive on the server. I am not even sure if these are related at all but I thought I would mention it. They don't know if that error was there before or not. I don't know how to fix that error either. I try to uncheck the box and see what happens but I am using Access 2007 and it says that this database was made on an older access so I can't make design changes.
Let me know if you have any more questions I have been banging my head on this for a while. I would love if someone can figure this out!
Thanks,
Rob