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?
|
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 |