How do I check if a query is empty

[avayaman]

I am sure this is simple. I need VB code to check if the results of a query is empty or not. (In other words a report generated off it has no entries)

Paul Beddows

Consulting, Avaya/EAS implementation, Training
Vancouver, Canada
E-mail paul at natcoa.com

 

[dhookom]

Try something like

  If Nz(DCount("*","[Your Query Name Here]"),0) = 0 Then

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

or ... use the following function to check any table or query:

[blue]Public Function NoRecords(objName As String) As Boolean
   [green]'objName: any query or table name[/green]
   NoRecords = (DCount("*", objName) = 0)
End Function[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[PWise]

In other words a report generated off it has no entries[/quote ]

you might want to look @ the nodata event

 

[avayaman]

Thanks everyone, the first set of code did the trick

Paul Beddows

Consulting, Avaya/EAS implementation, Training
Vancouver, Canada
E-mail paul at natcoa.com