View Full Version : Go to page in Report


Miras
07-13-2004, 01:34 AM
Hi, I want to open report in preview mode and jump directly onto page with (for example) number 3. I'm opening it by clicking command button. Is it posible to go to some page by using vba or macro?

idmcd
07-27-2004, 03:32 AM
This solution works, though it isn't very pretty...

Open your report using VB code, then use SENDKEYS to move about the report:

For example:

To go to page 3:
DoCmd.OpenReport "rptmEstimate", acViewPreview
SendKeys "{PgDn}{PgDn}", True

To go to the end of the report:
DoCmd.OpenReport "rptmEstimate", acViewPreview
SendKeys "{End}", True