(Msg. 1) Posted: Thu Aug 28, 2008 5:22 am
Post subject: Date function not working Archived from groups: microsoft>public>access>setupconfig (more info?)
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).
(Msg. 2) Posted: Thu Aug 28, 2008 6:52 pm
Post subject: Re: Date function not working [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Rose B <RoseB DeleteThis @discussions.microsoft.com> wrote:
>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
Ctrl+G will take you into the Debug/Immediate window. Then click on
Tools on the menu bar and References.
Tony
--
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/
(Msg. 3) Posted: Thu Aug 28, 2008 11:57 pm
Post subject: Re: Date function not working [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
"Tony Toews [MVP]" wrote:
> Rose B <RoseB.RemoveThis@discussions.microsoft.com> wrote:
>
> >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
> --
> 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/ >
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other