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

Tip: Looking for answers? Try searching our database.

Sections Help

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Developer - 30 Dec 2007 10:21 GMT
Hello All
I Need To Initialize A For Each Loop For The Setions Of The Report Put The
Keyword Sections Isnot Available To Use It Such
For Each Section In Report.Sections
   Statements ....
next
So How Can I Get The Displayed Sections In The Report
Note The Loop Used To Know The Visible Sections For A Report

With My Best Regards To All
Rabea Khalil
Baz - 30 Dec 2007 10:46 GMT
This has never worked, there is no such thing as a Sections collection for a
report.

A report has a Section property, which is an array and must be indexed by
number.  For example, Report.Section(0) returns the detail section.

If you really need to enumerate the sections in a report, you will need a
loop with an integer counter which you can use to index the Section
property, and you will need an error trap to terminate the loop because, as
far as I know, there is no way of determining the upper bound of the Section
array.

Please don't post with all your initial letters capitalised, it's very hard
to read and quite annoying.

> Hello All
> I Need To Initialize A For Each Loop For The Setions Of The Report Put The
[quoted text clipped - 7 lines]
> With My Best Regards To All
> Rabea Khalil
 
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.