Date() function problem

  • Thread starter Thread starter Ian Davies
  • Start date Start date
I

Ian Davies

Dear Access expert

I am trying to use an mde application developed in Access2k with Access
2002. I get an Access error box: Function is not available.. Date() etc.
Is Access 2002 back compatible if so how do I work around this date function
problem?

Ian
 
Dear Access expert

I am trying to use an mde application developed in Access2k with Access
2002. I get an Access error box: Function is not available.. Date() etc.
Is Access 2002 back compatible if so how do I work around this date function
problem?

Ian
Click to expand...
This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.

John W. Vinson[MVP]
 
Thanks for the help

Are these missing refs specific to the database or Access as a whole. Can
the missing refs be resolved from any Database or only from an mdb of the
one with the problem.
The reason I ask is that I only want the user to have the mde not the mdb or
am I going to have to take a trip and visit the users pc?

Ian
 
Already answered in another newsgroup to which you posted the same question.

If you feel you need to post to more than one group (HINT: it's seldom
necessary), please have the courtesy to cross-post (send the one message to
all groups at once), rather than multi-post (send individual messages to
each group). In this way, all responses to your post will be available
together, regardless of what group the responder was in, and the rest of us
won't have to read your post multiple times. (It also uses fewer server
resources)

I see you're using Outlook Express. Click the "Newsgroups:" label to the
left of the box containing the name of the current newsgroup. That will open
a dialog that will let you add additional newsgroups to your post.

Note that it's generally consider to be A Bad Thing to cross-post to more
than about 2 or 3 newsgroups. (In fact, at
http://www.microsoft.com/presspass/features/2001/Mar01/Mar27pmvp.asp
Microsoft suggests that "One group will suffice")


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)
 
Thanks for the tip
I dont use newsgroups alot so have not familiarised myself with the
etiquette
I will do this in future

Ian
 
Back
Top