Re: Compile error. in table-level validation expression. (Error 33

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Donna (Donna_at_discussions.microsoft.com)
Date: 03/21/05 

Date: Mon, 21 Mar 2005 08:57:06 -0800

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" <Donna@discussions.microsoft.com> wrote in message
> news:2810C21C-DA30-4674-8748-B55FFCF973A5@microsoft.com...
> > 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.
>
>
>

Relevant Pages

  • Re: The expression you entered has a function name that DB cant f
    ... "Ken Snell " wrote: ... recent database has a form with no buttons at all. ... If any of the database's references are messed up on a PC -- you can ... Debug Window, using Ctrl-G, provided you haven't selected the "keep ...
    (microsoft.public.access.macros)
  • Re: Convert a2000 back to a97
    ... Your computer is missing some of the DLL's or TLB's that come with Access ... The proper way to fix the References is to open the application in Access ... has the database connection hard-coded to use data access methods specific ... Those simple loads and conversions you mentioned -- could ...
    (microsoft.public.access.conversion)
  • Re: Event Procedure to Preview Report closes Access
    ... Compact the database to get rid of this junk: ... Uncheck any references you do not need. ... Still in the code window, choose Compile from the Debug menu. ...
    (microsoft.public.access.reports)
  • Re: filter sort error - crash!
    ... Compact the database to get rid of this junk: ... Open a code window. ... Uncheck any references you do not need. ... Still in the code window, choose Compile from the Debug menu. ...
    (microsoft.public.access.forms)
  • Re: Date Format
    ... >Not me isGarment Tracking Details a ... missing or damaged; to repost my boilerplate on the subject: ... This appears to be the very common References bug. ... database, or with an individual machine - it's *this* database on ...
    (microsoft.public.access.gettingstarted)