Date function quit working

[Beth]

Hi,
I have an Access 2002 application that I have been running on Windows XP SP2
without issue.
I just installed the application (running in Access Runtime) on a Windows
Vista Home Premium machine. Now, anywhere I used the =Date() function, it
fails and just shows #Name?

I also have a subform on one of my forms that has now gone blank. It also
uses the date function.

I had this problem when I converted to Windows XP several years ago and
updating the OWC10.dll to version 6619 fixed both issues.
However, everything I have read says that reference file makes no difference
to the Access functions.

Does anyone have a suggestion on what to try to fix this issue with the date
function?

Thanks,
Beth

 

[Jeff Boyce]

Beth

It sounds like Access may have "misplaced" one of its references.

Open a module in design view, click on Tools | References and see if any are
prefixed with the word "MISSING". If so, note which one(s), uncheck them,
close the window, re-open it, re-check them, and try re-compiling (Debug |
Compile...).

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Beth]

It is working fine on my development machine and none of the references are
marked missing. It is when I put it on the customer's machine that it
stops. That machine doesn't have Acces on it, so I can't do any
troubleshooting on it to see what happened to the reference.

Any other suggestions on how to tackle this?

Lori

 

[Jeff Boyce]

Beth

I don't understand.

You have an Access application.

You have Access on your development machine.

You put a copy of the Access application on another PC, which does not have
Access on it.

The application doesn't work.

What am I missing?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/