Recent content by William Smith

Rich, I have read every thread (many of them are old) I am using '03. Where exactly do I place this (I don't have the problem with Page Breaks, I am simply trying to prevent subreports from displaying when they have no data): Me.MyPageBreak.Visible = Me.MySubreport_subreport.Report.HasData Do...

I too would love to get the answer to this one. L that does nothing

Thanks Bob...but no luck. The report still looks the same. Rich earlier had mentioned OnDetail and HasData. But I have tried several combinations and am unsure how to correctly incorporate these. I appreciate your help regardless. Any other suggestions?

Guys this is killing me. I have several subreports in the detail section of my main report that are nothing more than a label and a text box pulled from different tables. I am providing an example. When there is no data in any of the subreports, a blank is displayed in its place. How do I get...

Perfect!!! Thanks so much for your help (RAINMAN)... oh and rich, what does look up oldvalue mean anyway?

Anytime a change is attempted. The message would then be displayed requiring an acknowlegement then allowing user to make the change.

Does anyone have code that results in a pop-up warning message should someone try to change a selection in a combo-box? Just a one time simple message like..."Are you sure you want to change this selection"? Thanks

Rich, Still can't find OnDetail. I see On Fomat...is this it? Do I place what you are telling me as an event and then code builder? This sure turned out to be all about nothing.

I take it you refer to the detail header. I see the On Format (for Section Detail) but I have several subreports. I can't understand how to implement this. In the code?

I'm using 2003 and see no OnDetail. Have On Open, Close, Activate, Deactivate, No Data, Page, & Error. Do I implement just as you have written, or do I change the name of "MySubreport"?

Thank You Rich, I can't tell you how much I appreciate your reply...but where do I put this and how. I'm sorry no VB skills. I truly thank you for you help. Bill

On my main report I have several subreports that are being pulled from different tables. If a subreport has no data, I wish that the subreports below them "move up" in order to save printing space. Please see attachement. I know how to save the space with fields (can shrink) but not subreports...

Thank you Bob...

All these views and not even the simplest suggestion?

My database is about satellites. The main form you select your satellite and now all the subforms (that are drawing from some 30 tables) only pull the info for that satellite (I created relationships). The "Summary Report" I am trying to create begins with a "view reports" on the main form (this...