Upgrade from Access 2003 to 2007

C

Cecil

I recently upgraded to access 2007 and noticed that some functions nolonger
work. I'm not sure if functions are nolonger supported or i had them wrong
from start. For example in using 2003, i have a query that had a date field.
I used "Quarter: ([Last Day Of Quarter]),"q"). It worked just fine before
upgrade. In 2007 i receive "Undefined function "Format" in expression". Any
comments are most helpful.
 
A

Allen Browne

Suggestions:

1. Did you leave the word Format out of your expression?
Did you intend this:
Quarter: Format([Last Day Of Quarter],"q")

2. Many VBA functions won't work in Access 2007 unless you add your database
folder as a trusted location under:
Office Button | Access Options | Trust Center | Trusted Locations

3. If the above doesn't solve it, you may have a problem with library
references:
http://allenbrowne.com/ser-38.html

For other tips on adapting to the new version, see:
http://allenbrowne.com/Access2007.html
 

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

Upgrade from Access 2003 to 2007 1
Convert Access 2007 to 2003 errors 1
2000-2003 to Access 2007 Switchboard 1
Access 2007/Access Runtime 2003 2
Upgrade to 2007 7
Access 2003 --- Access 2007 Runtime Conflict 8
Access 2003 db's & problems exporting query to Excel 1
MDE problem in Access 2007 12

Top