If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to open report 'elegantly' if nothing to show.
DoCmd.OpenReport "ABC"
When query behind it has nothing in it the report just flashes (or at least its window does). Can something be put in the OPEN/LOAD event that can cause an elegant OpenReport. -- Regards Tom |
#2
|
|||
|
|||
How to open report 'elegantly' if nothing to show.
Cancel the NoData event of the report.
-- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "ThomasAJ" wrote in message news DoCmd.OpenReport "ABC" When query behind it has nothing in it the report just flashes (or at least its window does). Can something be put in the OPEN/LOAD event that can cause an elegant OpenReport. -- Regards Tom |
#3
|
|||
|
|||
How to open report 'elegantly' if nothing to show.
"Allen Browne" wrote in
: Cancel the NoData event of the report. ....and add an error handler to the bit of code where DoCmd.OpenReport was called (you'll want to ignore error 2051). -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |
Thread Tools | |
Display Modes | |
|
|