Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / January 2006

Tip: Looking for answers? Try searching our database.

Sub Report visibility

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Alain - 31 Jan 2006 18:53 GMT
Hi guys,

I have a small problem, I need to have some subreport when running/printing
but it is always visible.
I am using similar code on my forms and it is working just fine, I have
replace the form part with the report but obviuosly something is wrong !
Can anyone tell me what I am doing wrong:

the subfrmPropCosts and subfrmPropSales are the proper name of the reports

'affichage du Sales subform et repositionnement de quelques controles
If Surplus Then
  Me.Label408.FontBold = True
  Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.subfrmPropSales.Visible
= True
  Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.Label347.Top =
5850
  Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.CostsNotes.Top =
6075
  Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.CostsNotes.Height
= 1500
  Reports![rpt-frmOwnedProperties].subfrmPropCosts.Height = 9000
  Reports![rpt-frmOwnedProperties].subfrmPropTaxes.Top = 13176
Else
  Me.Label408.FontBold = False
  Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.subfrmPropSales.Visible
= False
  Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.Label347.Top =
3240
  Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.CostsNotes.Top =
3600
  Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.CostsNotes.Height
= 1500
  Reports![rpt-frmOwnedProperties].subfrmPropCosts.Height = 5800
  Reports![rpt-frmOwnedProperties].subfrmPropTaxes.Top = 10750
End If

Thanks

Alain

Alain - 31 Jan 2006 21:05 GMT
I found my solution, I was using the Report Open event instead of the Detail
OnFormat event

Sorry for the inconvenience
Alain

> Hi guys,
>
[quoted text clipped - 40 lines]
>
> Alain
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.