Reference a library problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

default105 - 18 Jan 2005 23:29 GMT

Using Microsoft Access 2k3
Database is Access 2k format
Have tryed converting it to 2k3 but still same problem
I downloaded the Members database file 01018584.mdb from microsoft. I liked
the features of the database and started to expand on it to fit my criteria.
I created a new form and want to add a autofill of the current system date so
I used this code.
Private Sub SideBody_GotFocus()
Me![BreakDate] = Date
End Sub

When I click on the combo box I get the following
Run-time error '2465'
Microsoft can't find the field 'Date' refferred to in your expression

I don't understand why because the form-Member Payments, uses this code also
and it works fine. So I highlighted and clicked on Definition and received
this message.
Cannot jump to 'Date' because it is in the library 'C:\Documents and
Settings\Default\My Documents\01018584.mdb" which is not currently referenced

The library VBA is already referenced. The other form Member Payments, if
you do the same it opens the object browser to VBA,DateTime,Date. I can not
seem to find a way to fix this. The Time Function and Now Function work fine
but I wish to used the Date Function and why it is not working when it is
already referenced it beyond me. Any help would be useful. Thanx

Reply to this Message

Douglas J. Steele - 19 Jan 2005 01:31 GMT

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)

If you're using Microsoft's web interface to post, I believe that you can
type the names of the various groups into the Newsgroup box. Separate each
newsgroup name with a semicolon.

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")

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Using Microsoft Access 2k3
> Database is Access 2k format
[quoted text clipped - 30 lines]
> but I wish to used the Date Function and why it is not working when it is
> already referenced it beyond me. Any help would be useful. Thanx

Reply to this Message