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 / April 2007

Tip: Looking for answers? Try searching our database.

Manipulate report page header fileds through subreport

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Alp Bekisoglu - 28 Apr 2007 19:43 GMT
Hi Experts,

A2K and a main report (just to provide sequential page numbering) that holds
a few subreports.

I have put two hidden fields on each subreport named item_en & item_tr. I
have two fields on the main report page header named tr & en. The main
report used ans a shell for all the subreports is an unbound report. Aim is
to set:
mainreport.tr = item_tr
mainreport.en = item_en
changing with each subreport.

I am trying to get this done with an if then... but just couldn't manage to
refer to the subreport by name and fieldname to alter the content of the
main report's textbox.

I don't think this is impossible but can't seem to put the logic/commands in
VBA.

I would also like to manipulate another textbox's visibility on main report
page header but it seems to be unavailable.

Thanks in advance.

Alp
Marshall Barton - 28 Apr 2007 23:24 GMT
>A2K and a main report (just to provide sequential page numbering) that holds
>a few subreports.
[quoted text clipped - 16 lines]
>I would also like to manipulate another textbox's visibility on main report
>page header but it seems to be unavailable.

You need to do this from within the subreports.

Use an appropriate (report header section?) Format event in
each subreport:
    Parent.tr = Me.item_tr
    Parent.en =  Me.item_en

The visibility problem may be the same kind of issue, but I
can't tell from what you posted.

Signature

Marsh
MVP [MS Access]

Alp Bekisoglu - 29 Apr 2007 00:47 GMT
Hi Marsh,

Thank you for the advice I'll try that. Never thought of manipulating parent
through child. Should have thought of "real world" :-)

I do have page header in the main report but not in the sub's since they do
not show or I couldn't get them to show up.

Thanks again.

Alp

>>A2K and a main report (just to provide sequential page numbering) that
>>holds
[quoted text clipped - 31 lines]
> The visibility problem may be the same kind of issue, but I
> can't tell from what you posted.
 
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.