This may go along with the other post I started here and it may not. That is where you come in.
The company I just started working for is using a program that uses a Access Database with all of the info in it. This program was written in what I believe is Crystal language according to what I have gathered from doc types. It gives reports in .rpt format and I saw something else that said Crystal and so I looked it up and it was a language. The doc type is also a crystal report doc type apparently.
This program accesses the database and brings up model numbers and info about it. Now, normally we can put in these 3 fields needed and hit add to batch, then print batch and it will print. Something happened where now if we do it, once we hit print I get,
"Runtime error 3421- Data Type Conversion Error"
Apparently before the error this time, they would enter a letter or something instead of a number and it would give an error message. It would still show up in the access report though. Then my boss would go into the database and delete the bad entries and apparently it would work again.
Now we are having an issue where we get this error no matter what. They put in the same 3 fields as numbers and this error pops up. I cannot figure out why it is doing this and the program is basically useless right now. These entries are not showing up in the database either. We deleted all of the old entries that were made into the database and nothing is working.
If you have any ideas I would love to try them. From what I was looking at online it looked like if it was some code written wrong then it would spit this error out when the wrong data type was entered such as a letter where a number should go. I don't know hardly any programming so it is foreign to me.
The other thread I wrote about was that when I go to open Access I get a error saying that a mail.ocx is missing. I believe this started happening near the same time but I am not too sure as I just started working here about a week ago. Could that have something to do with it? I could not find hardly ANYTHING about mail.ocx. Not even what it is for.
Thank you for your time on this long post. I appreciate any help.