Access 2003 expressions and functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that was created in Access 2000 and I am now using in 2003.
If I try to use a function such as Format or write an expression in a query
such as =right to use the right portion of a data field I get error messages.
I can created a new database for test purposes and these functions and
expressions work fine. Where do I look for my problem? I can't seem to find
the answer in Microsofts support pages.
 
Sounds like a problem with references.

Press Ctrl+G to open the Immediate Window.
Choose References on the Tools menu.
Any checked libraries marked "MISSING"?

More info about the libraries you need for your version of Access:
http://allenbrowne.com/ser-38.html
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problems with Access 2003 query 4
Access 2010 error 2950 3
functions in converted database 5
undefined function 'xxx' in expression - user function 2
Access #Error & Excel Pivot 0
Upgrade from Access 2003 to 2007 1
Query error: Undefined function 'Concatenate' in expression 3
Error 3085 Format function Not defined in Sql expression Access 20 0

Back
Top