access error - help

M

mxayala

i keep getting this error: Function isn't available in expressions in query
expression '(Format([Date],"DDDDD"))'

my database was working fine and now half of my dates do not display and my
charts are not working due to this problem.

i use microsoft access 97

please help.
 
J

John Vinson

i keep getting this error: Function isn't available in expressions in query
expression '(Format([Date],"DDDDD"))'

my database was working fine and now half of my dates do not display and my
charts are not working due to this problem.

i use microsoft access 97

please help.
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]
 
M

Monish

John -

What would you suggest if the issue is with a station running a FE *.mde?

Apparently they installed an Acrobat upgrade just prior to experiencing the
problem. I tried accessing the *.mdb from their machine and refreshing links
and it was fine, but then I was getting the error message at my machine, so I
did the same thing at my machine and now they are back to having the problem
again...

I hope this makes sense...I recall seeing something on these boards about
this issue with *.mde apps, but cannnot find them now.

Appreciate any assistance.

M

John Vinson said:
i keep getting this error: Function isn't available in expressions in query
expression '(Format([Date],"DDDDD"))'

my database was working fine and now half of my dates do not display and my
charts are not working due to this problem.

i use microsoft access 97

please help.
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]
Click to expand...
 
Top