Nz() function compile error

J

Joseph

I Use nz() function often. Today it gives me a compile error in a simple
query. Could anyone help?
Thanks. Joseph
 
6

'69 Camaro

Hi, Joseph.

Your database may have lost one of its library references. Make sure that
you
have no "MISSING" references. For more information, please see Tom
Wickerath's Gem Tip, "ADO and DAO Library References in Access Databases" on
the following Web page:

http://www.Access.QBuilt.com/html/gem_tips1.html

If that doesn't help, then please post the SQL, as well as the VBA code
snippet that creates and executes the query.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
J

Joseph

'69 Camaro said:
Hi, Joseph.

Your database may have lost one of its library references. Make sure that
you
have no "MISSING" references. For more information, please see Tom
Wickerath's Gem Tip, "ADO and DAO Library References in Access Databases" on
the following Web page:

http://www.Access.QBuilt.com/html/gem_tips1.html

If that doesn't help, then please post the SQL, as well as the VBA code
snippet that creates and executes the query.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
Click to expand...
 
J

Joseph

Thanks a lot for your help. I found that the mdb file itself was corrupted so
I opened a new one and exported all the objects there. I also checked all the
references needed including DAO 3.6. It now works.
Thanks again.
Joseph
 
Top