Date() dependencies?

[Guest]

I'm trying to get an Access 97 program to work (as it used to) on a Win2000
computer. The users are capable of doing anything, and I'm suspicious that a
file was deleted somewhere because VB code won't compile anymore if it
contains the Date() function. I was alerted to this when a simple event that
populates a field with the value returned by Date() failed. I've uninstalled
(a dubious process) and reinstalled Access 97 and still get the same error.
The rest of the Access program seems to work as normal, but this one function
fails. Any ideas on where to look? I'd hate to FDISK this computer, but
perhaps that is what is needed.

Thanks,
Emilio
Portland, OR

 

[Dirk Goldgar]

I'm trying to get an Access 97 program to work (as it used to) on a
Win2000 computer. The users are capable of doing anything, and I'm
suspicious that a file was deleted somewhere because VB code won't
compile anymore if it contains the Date() function. I was alerted to
this when a simple event that populates a field with the value
returned by Date() failed. I've uninstalled (a dubious process) and
reinstalled Access 97 and still get the same error. The rest of the
Access program seems to work as normal, but this one function fails.
Any ideas on where to look? I'd hate to FDISK this computer, but
perhaps that is what is needed.

From the VB Editor, check the Tools -> References... dialog for any
references marked as MISSING. Probably some update or other has broken
a reference. The steps outlined here may help identify and correct the
problem:


http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

 

[PC Datasheet]

Emilio,

I am in business to provide customers with a resource for help with Access.
If you still are unable to solve the problem with Date(), I am available to
help you solve the problem. If you want my help, contact me at my email
address below.

 

[Guest]

Dirk, that was the key and I very much appreciate your help and quick response.

-Emilio