how to determine if a report exists
Posted on 2007-04-10
I have a custom reporting application -- that has functionality in it that backs up and restores custom reports. I keep a table that lists the report names. While testing - the restore process works fine as long as the reports exist in the backup file. But when I test the negative condition (report does not exist in the backup file) -- it doesn't know what to do....
How can I determine if a report exists? I use the following code to check if a query (or table) exists -- but it doesn't seem to recognize reportdef....
Set dbs = CurrentDb
For Each qdf In dbs.QueryDefs
If qdf.Name = "Temp_Query" Then
Thanks for the help,