Go to the Last page of a Report when it opens.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a report that has a module behind it that creates a seperate
table of contents report for me which works very nicely . . . however the
code requres the user to go to the last page of the report so that it reads
all the records into the table of contents.
Is it possible to automate the 'go to last page' action with an 'On
Activate' or 'On Open' event???
 
This connot be done. I've struggled with this myself, and the only solution
I could come up with is to print the report to PDF first. Than the table of
contents gets updated and you can work with it...
 
I've created a report that has a module behind it that creates a seperate
table of contents report for me which works very nicely . . . however the
code requres the user to go to the last page of the report so that it reads
all the records into the table of contents.
Is it possible to automate the 'go to last page' action with an 'On
Activate' or 'On Open' event???
Click to expand...

Where did you get that code that requires you to 'go to the last page'
on opening a report? That's not necessary.

What version of Access are you using?
Here is a method for Access 2000.
See Microsoft KnowledgeBase article:
210269 'ACC2000: How to Create a Table of Contents or Index for a
Report'

For Access 97 and older:
131588 'ACC: How to Create a Table of Contents or Index for a Report'
 
KB 210269 works great, but it requires manually paging to the last report
page to fire the print event if you use print preview.

Does anybody know an elegant way to page throught a report to get the count
without having to use a third party vehicle like a PDF?

Thanks.
 
Back
Top