Type Mismatch Error

[k Carver]

I've been battling an error message in a program for months. The problem is that I sporadically get a type mismatch error in a program that emails me every message a user gets. The program is as follows. I scrape data using a screen scrape program. In VB I take the data and insert it into an Ingres database. The problem is that the user will work with some data and insert it fine. Then the next set of data they work with then errors out and the data in the email message is the previous data not the current data that they were working with. The error just says type mismatch. I can't seem to get rid of it. My latest attempt was to reset all the variables after each insert to "", or "01/01/1901, etc.. This has not worked though. Any help is greatly apprecicated.

K Carver

[John G Duffy]

Type Mismatch says a caller is supplying data with a different type of data the called routine is expecting.
Example:
DIM myLong as Long
Call SubRoutineA (myLong)
'
Private Sub SubroutineA(abc as String)
end Sub
'
this will produce your error

John G