Re: Date function not working

You are accessing this site in a read-only mode. For full access to all member benefits, including message posting, please login or register. Registration is completely free, simple, and takes only a few seconds.

The message you are replying to and its parents are listed in the reverse order with the most recent posts first. This might not be the whole discussion thread. To read all the messages in this thread please click here.

Re: Date function not working

Rose B	29 Aug 2008 06:57
Thanks Tony, it will take me a while to work through this as I won't be back to the user's office for a week now, but I will respond after that. Thanks again. Rose > >I have a user who has just had Access re-installed and now a fromt end (MDE) > >application produces an error whenever the Dtae function is used (function [quoted text clipped - 26 lines] > > Tony

Tony Toews [MVP]

29 Aug 2008 00:52

>I have a user who has just had Access re-installed and now a fromt end (MDE)
>application produces an error whenever the Dtae function is used (function
>not available).

What are your references?

Do you have any references besides the basic three? Are you sure you
need them? Write down the path and name of the extra ones (or put the
following code in a module and execute the code), delete from the
references list and Compile and Save All. Keep any necessary
references and ensure they are distributed to the target system.

Sub ViewReferenceDetails()

Dim ref As Reference

For Each ref In Access.References
Debug.Print ref.Name & " - " & ref.Major & "." & ref.Minor & "
- " & ref.FullPath
Next ref

End Sub

For a very detailed page on reference problems see
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

Ctrl+G will take you into the Debug/Immediate window. Then click on
Tools on the menu bar and References.

Tony

Signature

Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Rose B

28 Aug 2008 12:22

I have a user who has just had Access re-installed and now a fromt end (MDE)
application produces an error whenever the Dtae function is used (function
not available). We have tried to refresh the References using method
described by item "access error - help" in the discussion but this does not
work. We have also tried re-installing MS Office (2003) but the error still
persists. Any suggestions? (The MDE works fine on other workstations with
Office 2003 installed).

Quick links: