?
Solved

Access 2003 Report Page Numbering restart at each grouping level

Posted on 2007-09-29
11
Medium Priority
?
1,410 Views
Last Modified: 2013-11-28
I have an Access 2003 report. WHen I run it I want the page numbering to restart after each certain group.
It is working fine example Page 1 page 2 page 3 then will restart with a new group head Page 1 Page 2 etc.

But the problem is when the group footer is split between two pages - the secod part of the footer on the new page starts over at Page 1?

I have a macro that sets the Value to 1 and then I put that macro in the footer. I have a page break at the end of the group footer.
0
Comment
Question by:Pdeters
  • 6
  • 5
11 Comments
 
LVL 14

Expert Comment

by:ragoran
ID: 19985192
Have you try putting the macro in the group header ?
0
 

Author Comment

by:Pdeters
ID: 19985233
yes, but still does the same thing. The instructions stated that if it is in page header to set the FORCENEW PAGE property of the first level grop to before section but then i end up with a blank page as the first page and stil have the same problem
0
 

Author Comment

by:Pdeters
ID: 19990310
I ended up putting me.Page=1 in the group header and got rid of the macro. THis worked.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 14

Expert Comment

by:ragoran
ID: 19990769
Good.

To tell you the truth, I never use macros (to difficult to debug complex logic).  So I typically do the same as you did, using VBA to set the me.page value in the group header print event.

Good luck on your project.
0
 

Author Comment

by:Pdeters
ID: 19992651
Was working great until i wnat to repeat the group header on each page - now they all state Page 1
Any ideas?
0
 
LVL 14

Expert Comment

by:ragoran
ID: 19999281
Check the FormatCount (or PrintCount) argument, change the page only if it is = to 1.
0
 

Author Comment

by:Pdeters
ID: 20000958
Where would this be?
I have the Me.Page=1 in the onFormat event of the group header
0
 
LVL 14

Expert Comment

by:ragoran
ID: 20003110
So at this place:

if FormatCount = 1 then
   me.page = 1
end if


Formatcount will be 1 only the first time it is formated for a specific value of the grouping expression.

If this does not work (I can't test it right now), I am pretty sure it will be ok if you miove the code inside the OnPrint event of the group header (then replace FormatCount with PrintCount)
0
 

Author Comment

by:Pdeters
ID: 20010166
Stlll prints and shows on the screen as Page 1 on all pages
0
 
LVL 14

Accepted Solution

by:
ragoran earned 2000 total points
ID: 20018768
Sorry for the delay, very busy day at the office.

Try this little trick

Insert a new group, above the one you want to restart the page number but base on the same group expression.  Have a group header but set its height to nothing and it should not repeat on all page.  

Then move the code me.page=1 (you should have it at only one place) in the OnPrint event of this new group header.

0
 

Author Comment

by:Pdeters
ID: 20030387
Worked Great- Thank you so much!!!!
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question