Hello
Access 2003. I am trying to program a macro to close a report
automatically. When the report has records this is not a problem.
When the report does not have records a MS Office Access message comes
up reading "The report named 'sales' you entered is misspelled or
refers to a report that is not open or doesn't exist." Does anybody
have any recommendations?

Thanks
Tony

The simplest approach is not to Open the Report unless its Record Source
Query produces Records. Use the Report's Query in a DCOUNT domain aggregate
statement, something like the following where the Report is called "Arep",
its RecordSource is "AQry", and "AFld" is any field that will have a value
for each record (like, say, the key field for the records):

If DCOUNT("AFld","AQry") > 0 Then
DoCmd.OpenReport ("Arep")
End If

Larry Linson
Microsoft Office Access MVP

Tony_E" <bluestealth94 (AT) hotmail (DOT) com> wrote

On Jan 21, 3:07*pm, "Access Developer" <accde... (AT) gmail (DOT) com> wrote:
I like how Larry's technique also excludes cases where the query
returns records, but all the values of AFld are all Null.

James A. Fortune
CDMAPoster (AT) FortuneJames (DOT) com