I'm using the default value Now() for a Date/Time field in a table. It has
been working fine for over a year. All of a sudden I'm getting the above
message. This happens consistently with any table - old or new- in this
database. The same default value works fine in tables in other databases.

My os is Win XP sp2. Access is 2002 sp3. All databases are using a
default file format of Access 2000.

Can anyone help me?

I've tried compacting and repairing, also copied the database. I've
searched the web & MS but haven't found an answer. I have seen lots of
discussions about 'references' and 'dlls'. I don't understand either of
those, so if my problem is in that area, I would need a VERY SIMPLE
explanation.

Thanks in advance,
Donna

"Donna" <(E-Mail Removed)> wrote in message
news:2810C21C-DA30-4674-8748-(E-Mail Removed)...
> I'm using the default value Now() for a Date/Time field in a table. It
has
> been working fine for over a year. All of a sudden I'm getting the above
> message. This happens consistently with any table - old or new- in this
> database. The same default value works fine in tables in other databases.
>
> My os is Win XP sp2. Access is 2002 sp3. All databases are using a
> default file format of Access 2000.
>
> Can anyone help me?
>
> I've tried compacting and repairing, also copied the database. I've
> searched the web & MS but haven't found an answer. I have seen lots of
> discussions about 'references' and 'dlls'. I don't understand either of
> those, so if my problem is in that area, I would need a VERY SIMPLE
> explanation.
>
> Thanks in advance,
> Donna
>

A broken reference, I would think. Open the VBA window (click on a form,
report or module in the database window, and then choose "code" from the
view menu). On the Tools menu, click "References". In the list that
appears, look for anything marked as "MISSING".

What you do next depends on what is missing. You can "fix" this problem by
simply removing the tick against the missing item(s), but, if it's something
your database needs, you will find that something else doesn't work
properly. You may need to come back here for more help when you know what
is missing.

Brian,

Thanks for telling me how to find missing references. At least that's no
longer a mystery. However, when I open the window 'References - Access9db'
there is nothing that says MISSING. There is a list of References with check
boxes, 4 of which are checked, that's all.

Can you offer another suggestion?

(I haven't ignored your help. I only work part time.)

"Brian" wrote:

>
> "Donna" <(E-Mail Removed)> wrote in message
> news:2810C21C-DA30-4674-8748-(E-Mail Removed)...
> > I'm using the default value Now() for a Date/Time field in a table. It
> has
> > been working fine for over a year. All of a sudden I'm getting the above
> > message. This happens consistently with any table - old or new- in this
> > database. The same default value works fine in tables in other databases.
> >
> > My os is Win XP sp2. Access is 2002 sp3. All databases are using a
> > default file format of Access 2000.
> >
> > Can anyone help me?
> >
> > I've tried compacting and repairing, also copied the database. I've
> > searched the web & MS but haven't found an answer. I have seen lots of
> > discussions about 'references' and 'dlls'. I don't understand either of
> > those, so if my problem is in that area, I would need a VERY SIMPLE
> > explanation.
> >
> > Thanks in advance,
> > Donna
> >
>
> A broken reference, I would think. Open the VBA window (click on a form,
> report or module in the database window, and then choose "code" from the
> view menu). On the Tools menu, click "References". In the list that
> appears, look for anything marked as "MISSING".
>
> What you do next depends on what is missing. You can "fix" this problem by
> simply removing the tick against the missing item(s), but, if it's something
> your database needs, you will find that something else doesn't work
> properly. You may need to come back here for more help when you know what
> is missing.
>
>
>

"Donna" <(E-Mail Removed)> wrote in message
news:EAEEEC55-8830-419E-B86B-(E-Mail Removed)...
> Brian,
>
> Thanks for telling me how to find missing references. At least that's no
> longer a mystery. However, when I open the window 'References -
Access9db'
> there is nothing that says MISSING. There is a list of References with
check
> boxes, 4 of which are checked, that's all.
>
> Can you offer another suggestion?
>
> (I haven't ignored your help. I only work part time.)
>
> "Brian" wrote:
>
> >

Here's a little trick that may help: back in the references window, put a
tick against something that isn't already ticked. It doesn't matter what.
Close the window, then open it again and remove the tick.

That did the trick! Thanks Brian

"Brian" wrote:

> "Donna" <(E-Mail Removed)> wrote in message
> news:EAEEEC55-8830-419E-B86B-(E-Mail Removed)...
> > Brian,
> >
> > Thanks for telling me how to find missing references. At least that's no
> > longer a mystery. However, when I open the window 'References -
> Access9db'
> > there is nothing that says MISSING. There is a list of References with
> check
> > boxes, 4 of which are checked, that's all.
> >
> > Can you offer another suggestion?
> >
> > (I haven't ignored your help. I only work part time.)
> >
> > "Brian" wrote:
> >
> > >
>
> Here's a little trick that may help: back in the references window, put a
> tick against something that isn't already ticked. It doesn't matter what.
> Close the window, then open it again and remove the tick.
>
>
>