Nodata event 2

[romnew]

When a report has no data the no data event can be used to give a message that there is no data to report on. When I use this, however, a runtime error 2501 comes up saying "The openreport action was cancelled"
How do I get rid of this dialog coming up.
Your assistance is greatly appreciated

 

[thornmastr]

Define an error routine in the code from which your report is opened. Trap this partcular error, and when it is encountered, respond with resume next. That will cause this error to be ignored.

 

[Garridon]

This FAQ will help:

http://www.tek-tips.com/faqs.cfm?spid=703&sfid=1594&CFID=64760385&CFTOKEN=43482558

Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com

 

[thornmastr]

Snort.......You said file not Excel. OK, you want Excel you got Excel.

Dim exlApp as excel.Appliation

Set exlApp = CreateObject(Excel.application)
exlApp.fileopen( Myfile.xls)

grumble grumble...man says file, he gets file. Man says Excel, he gets Excel. No one is ever happy...Snicker, snort. Have a great day.