Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Setup / Configuration / August 2008

Tip: Looking for answers? Try searching our database.

Date function not working

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rose B - 28 Aug 2008 13:22 GMT
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).
Tony Toews [MVP] - 29 Aug 2008 01:52 GMT
>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 - 29 Aug 2008 07:57 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.