format function problems

[tinoco]

hi!
I developed an access application using the access 2000 and windows 2000 professional.
I used in the queries the format function to work with dates.
Now i'm trying to install this application in a computer that have the windows XP and the format function in queries is not recognise by access anymore.
I have already checked all library's and all are added.
there is anyone that knows how to solve this problem?
thanks

 

[lupins46]

What is the error message?

 

[dhookom]

tinoco,
What do you mean by "checked all library's"? This is a very common symptom of broken references.

Have you attempted to compile all the code?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[tinoco]

the error message is:
Undefined function 'format' in expression!

I have the same libraries added in my application at windows professional as in XP.

i hope this helps
thanks

 

[dhookom]

Check Doug Steele's page on references

http://www.accessmvp.com/djsteele/AccessReferenceErrors.html.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]