On NoData

[toleafs]

Hello
Any help is appreciated. I have a macro that runs and exports a query to excel. In there a way to cancel the event if there is no data in the query so it stops running the export process?

thanks

 

[Trevor G]

What about setting a form to run the query, and add a count feature in the form as an unbound box, and if the record count is 0 then cancel the event

Create a form based on the query, and add a textbox that will count based on a field that will always have something in like an ID field.

Add an if statement to a command button something like this:
docmd.openquery "Query Name"
IF txtcount.value=0 then
exit sub
else
docmd.transferspreadsheet etc
end if

 

[toleafs]

thx...I will try that