MessageBox when there IS data returned by a Query

[dgrimes]

I need to have a MessageBox display when there is ANY data returned by a specific query. I want my database to open with a macro that checks a specific query, and if there is any data returned at all, show a MessageBox stating that fact. I cannot seem to find any information on this. There is plenty of information on how to complete this when there is NO data. I know this is probably simple code but I just cannot get it to accept.



Please help!

Thank you.

[JoeM]

You can use the DCOUNT function to count the number of records returned by the query, i.e.

If DCOUNT("*","QueryName") > 0 Then
    MsgBox "There is data in your query!"
End If

For more on DCOUNT, see: http://www.techonthenet.com/access/f...ain/dcount.php

[orange]

There is plenty of information on how to complete this when there is NO data. I know this is probably simple code but I just cannot get it to accept.

If you can find a technique for when there is NO data, you could try putting a "Not" in the set up to do the opposite.

[dgrimes]

************************

[dgrimes]

You can use the DCOUNT function to count the number of records returned by the query, i.e.

If DCOUNT("*","QueryName") > 0 Then
    MsgBox "There is data in your query!"
End If

For more on DCOUNT, see: http://www.techonthenet.com/access/f...ain/dcount.php

This worked perfectly! I knew it was something simple. Thank you!