Functions in Access 2000 not in Access 2003

  • Thread starter Thread starter mcl
  • Start date Start date
M

mcl

At work we just upgraded from Windows 2000 & office 2000 to Xp.
I found that queries that worked with 2000 not give an undefined function.
What a pile of garbage.
Format is one. I have numbers in a database where I don't want leading 0's
dropped.
So I used format([parameter],"000000").
Worked before, now it doesn't.
 
At work we just upgraded from Windows 2000 & office 2000 to Xp.
I found that queries that worked with 2000 not give an undefined function.
What a pile of garbage.
Format is one. I have numbers in a database where I don't want leading 0's
dropped.
So I used format([parameter],"000000").
Worked before, now it doesn't.
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]
 
That actually seemed to help. At least the "format" function works again.
I'm still having one other problem but I'll save it for another thread.
One other thing. In the past, when using Access 2000, I've run into
functions found in the access help that don't seem to work and have
complained about it here. While doing what was suggested below I added the
excel library. Should that help that problem?

John Vinson said:
At work we just upgraded from Windows 2000 & office 2000 to Xp.
I found that queries that worked with 2000 not give an undefined function.
What a pile of garbage.
Format is one. I have numbers in a database where I don't want leading 0's
dropped.
So I used format([parameter],"000000").
Worked before, now it doesn't.
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...
 
Back
Top