Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: AlanWhaley
- Order by date
-
Page Total Summary
Hey Duane - you're a genius! It worked really well. I have added a "Page" prefix to the page numbers, and changed their format to "000", but other than that, the concept is beautiful! I really need to get my head around the VB functions more; the flexibility is really surprising to me... Now...- AlanWhaley
- Post #9
- Forum: Microsoft: Access Reports
-
Page Total Summary
The example can be found in this knowledge base article... http://office.microsoft.com/en-us/access-help/summing-in-reports-HA001122444.aspx Here are my versions... Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) If PrintCount = 1 Then txtPageSum = txtPageSum +...- AlanWhaley
- Post #7
- Forum: Microsoft: Access Reports
-
Page Total Summary
That sounds very interesting... I've searched the net and haven't found anything I could adapt? Could you expand a little further? Thanks- AlanWhaley
- Post #5
- Forum: Microsoft: Access Reports
-
Page Total Summary
Hi Duane, Unfortunately not - the descriptions vary in length quite a bit, so I'm having to use the 'can grow' option on my subheadings and detail sections to get the presentation looking OK... Thanks for the quick reply..!- AlanWhaley
- Post #3
- Forum: Microsoft: Access Reports
-
Page Total Summary
Hi all, Could any one propose a solution to the following problem I have? I have used some VBA to get totals at the bottom of each page of a report, by page (i.e. Total for Page = $###.) I would now like a summary page listing each pages' total, i.e. Page 001 $### Page 002 $### Etc etc...- AlanWhaley
- Thread
- Replies: 8
- Forum: Microsoft: Access Reports
