A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Need help w/ reports



 
 
Thread Tools Display Modes
  #1  
Old June 25th, 2004, 05:59 PM
Tom
external usenet poster
 
Posts: n/a
Default Need help w/ reports

I have multiple reports... they can be categorized into "error reports" and
"summary reports".

For all reports I utilize the "NoData Function" below:

Private Sub Report_NoData(Cancel As Integer)
MsgBox "There is no data! Closing report."
Cancel = True
End Sub


For all error reports, I do want to see the "There is no data! Closing
report." message box.

For the summary reports, I expect (or at least hope) to NOT see this message
box.


Here's what I'm trying to achieve:
Create a dependency between the 2 report categories so that either a) I see
"something" (whatever it might be... text box, message box, comment) on the
summary reports that indicates that there are still errors in the error
reports. Therefore, I should not print them until all errors have been
fixed,
or
b) Disable the summary reports until all errors have been fixed.


Is that possible? If yes, how would I do that?



Thanks,
Tom



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Run a batch of reports based on the same query Penny Meholick Setting Up & Running Reports 3 June 10th, 2004 07:29 PM
How do I get two different style reports merge into one to look the same? Alana General Discussion 2 June 7th, 2004 04:32 PM
ACCESS Reports Steve Setting Up & Running Reports 2 June 7th, 2004 02:58 PM
Combine Multiple Reports to send in Email Attachment Steve General Discussion 1 June 5th, 2004 11:06 PM
Multiple Reports James Setting Up & Running Reports 2 May 22nd, 2004 01:09 AM


All times are GMT +1. The time now is 01:00 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.