When a query result is empty.....

[khanson]

Hi, I have been searching the net for an answer but I am not sure of the right question...so I would like to pose it here. I have a simple query that returns data based on entering a specific criteria. The query is run from a macro and the results get created in a spreadsheet and emailed to certain people. The problem I have is that if the query returns no data, for whatever reason, then I don't wish the spreadsheet to be created or emailed. So, in basic terms, if I enter criteria that is spelt incorrectly or the data doesn't exist, I want the query to error and tell me why. Is this something easy to achieve..??

[pbaldy]

One way would be to add code to your process that uses DCount to test the query. If greater than 0, continue the process, else abort.

[khanson]

OK....not sure where in the query I should be adding code....or even how the code would read...not an Access expert unfortunately...can you give me an example..?

[pbaldy]

It would not be in the query, it would be in the macro or VBA code that was doing your process. I don't use macros, but I think you'd use a Condition. In VBA code this type of thing:

If DCount(...) > 0 Then
  'Do your exporting and emailing
Else
  Msgbox "No records to email"
End If