Only 2 users getting an error message

[Guest]

We have a database that is used by up to 15 users. This morning, while
trying to enter information into a form, the user got an error message:

Unknown function 'Date' in validation expression or default value on
'tblCSOS.Today'

When I open the same form on my computer, it lets me continue.

I tried making a copy of the database onto her desktop, running compact and
repair, opening the database form and trying to edit, but we get the same
error message. Again, when I open the same form on other computers...no
problem.

The same thing happened with another user last week. Any ideas what I can
do? Is it the computer? We also ran a "detect and repair" on MSOffice, but
it still happens.

Rhonda

 

[Douglas J. Steele]

Any time an application works on some, but not all, workstations, or an
application that formerly worked suddenly stops working, the first thing to
suspect is a problem with the References collection.

On the machine(s) where the problem is occuring, open any code module, then
select Tools | References from the menu bar. Examine all of the selected
references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)

 

[JoelH]

have you checked there aren't any missing references on the computer
with the error - go into the vba editor and check on tools-references
for anything listed as missing.
also check there are no links to tables that aren't valid.

 

[John Vinson]

We have a database that is used by up to 15 users. This morning, while
trying to enter information into a form, the user got an error message:

Unknown function 'Date' in validation expression or default value on
'tblCSOS.Today'

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.

This will need to be done on each affected computer.

John W. Vinson[MVP]

 

[Guest]

Thank you. It worked beautifully.

Rhonda

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.

This will need to be done on each affected computer.

John W. Vinson[MVP]