G
Guest
Suddenly a major form in my application gives me a type mismatch error on the
following line of code:
MsgBox(Format(Now(), "Short Date"))
There are no variables named Now in the code module, no references appear to
say "Missing", the project compiles fine. This is an mdb file, not
excessivly large - about 4.2 MB. I've tried to compact repair to no avail.
I can run that line of code in another form. But when I create a blank form
and copy all the objects and code from the form giving me the error I still
get the type mismatch.
What is going on? I understand references go bad, but in a particular form?
I've been using Access for nearly 10 year, have NEVER seen anything like
this. It's almost enough to make me lobby my bosses for a switch to .NET
(did I say that????).
HELPPPPPPP!!!
following line of code:
MsgBox(Format(Now(), "Short Date"))
There are no variables named Now in the code module, no references appear to
say "Missing", the project compiles fine. This is an mdb file, not
excessivly large - about 4.2 MB. I've tried to compact repair to no avail.
I can run that line of code in another form. But when I create a blank form
and copy all the objects and code from the form giving me the error I still
get the type mismatch.
What is going on? I understand references go bad, but in a particular form?
I've been using Access for nearly 10 year, have NEVER seen anything like
this. It's almost enough to make me lobby my bosses for a switch to .NET
(did I say that????).
HELPPPPPPP!!!