Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Blank Reports to not open

  
   Windows Help (Home) -> Microsoft Access RSS
Next:  SQL - query moving column to a row  
Author Message
Emma

External


Since: Nov 25, 2008
Posts: 14



(Msg. 1) Posted: Fri Dec 05, 2008 6:44 am
Post subject: Blank Reports to not open
Archived from groups: microsoft>public>access (more info?)
Hi I have 3 reports which open from a macro. I would like the reports to be
displayed if there is information, however if the report is blank I don't
want to open it. Is there a setting which stops blank reports from openning?

 >> Stay informed about: Blank Reports to not open 
Back to top
Login to vote
BruceM

External


Since: Dec 5, 2008
Posts: 31



(Msg. 2) Posted: Fri Dec 05, 2008 10:14 am
Post subject: Re: Blank Reports to not open
Archived from groups: per prev. post (more info?)
See VBA Help for information about the report's NoData event. Essentially
it is something like this:

Private Sub Report_NoData(Cancel As Integer)

MsgBox "No data"
Cancel = True

End Sub


"Emma" wrote in message

> Hi I have 3 reports which open from a macro. I would like the reports to
> be
> displayed if there is information, however if the report is blank I don't
> want to open it. Is there a setting which stops blank reports from
> openning?

 >> Stay informed about: Blank Reports to not open 
Back to top
Login to vote
Emma

External


Since: Nov 25, 2008
Posts: 14



(Msg. 3) Posted: Mon Dec 08, 2008 8:41 am
Post subject: Re: Blank Reports to not open
Archived from groups: per prev. post (more info?)
Hi Bruce that worked great really liked the pop up msg! Thanks

"BruceM" wrote:

> See VBA Help for information about the report's NoData event. Essentially
> it is something like this:
>
> Private Sub Report_NoData(Cancel As Integer)
>
> MsgBox "No data"
> Cancel = True
>
> End Sub
>
>
> "Emma" wrote in message
>
> > Hi I have 3 reports which open from a macro. I would like the reports to
> > be
> > displayed if there is information, however if the report is blank I don't
> > want to open it. Is there a setting which stops blank reports from
> > openning?
>
>
 >> Stay informed about: Blank Reports to not open 
Back to top
Login to vote
BruceM

External


Since: Dec 5, 2008
Posts: 31



(Msg. 4) Posted: Mon Dec 08, 2008 12:58 pm
Post subject: Re: Blank Reports to not open
Archived from groups: per prev. post (more info?)
Glad to help. Check Help about message boxes to see how to add titles and
other features.

"Emma" wrote in message

> Hi Bruce that worked great really liked the pop up msg! Thanks
>
> "BruceM" wrote:
>
>> See VBA Help for information about the report's NoData event.
>> Essentially
>> it is something like this:
>>
>> Private Sub Report_NoData(Cancel As Integer)
>>
>> MsgBox "No data"
>> Cancel = True
>>
>> End Sub
>>
>>
>> "Emma" wrote in message
>>
>> > Hi I have 3 reports which open from a macro. I would like the reports
>> > to
>> > be
>> > displayed if there is information, however if the report is blank I
>> > don't
>> > want to open it. Is there a setting which stops blank reports from
>> > openning?
>>
>>
 >> Stay informed about: Blank Reports to not open 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Saving Reports Outside Of Access - Can someone tell me if it is possible by code to Save a Report As a Data Access Page through VBA? And if so, could you give me an example of the code? I would like the user to select the report from a switchboard, have it open in Preview mode and on...

Want to change colors of text items in reports - In a database I have a field with a drop down box that has 3 possible text answers. When one of these answers is selected, I would like to have a different color for each answer in the report. Example: Priority code with a selection of 1, 2, 3. In the...

Ensuring uniform control width on forms and reports - This utility ensures you have uniform control width on forms and reports. This example shows the Unit Number as found in many forms and reports through out the Granite Fleet Manager. Other examples might be part numbers, serial numbers, license plat...

Problem creating a form for blank records - I can't even find a suitable title for describing my problem. I have a bunch of Players. each player plays in a number of Games. So assuming I want a table of PlayerScores, the foreign keys of PlayerScores needs to be the primary keys of Players and..

how do I add a blank record row in to the middle of an exi.. - how do I add a blank record row in to the middle of an existing table
   Windows Help (Home) -> Microsoft Access All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]