M
moon11
Hello,
In Access 2003 I have a vba module that runs on the On Open event for a
report that uses 2 different Sendkeys commands, one to fit the report to the
window
(SendKeys "%vzf" - i.e. view-zoom-fit) and one to advance the report pages
to a specific page based on a counter (SendKeys "{RIGHT}" - within a counter
loop). Since the Sendkeys command does not work properly in Vista, I am
looking for the proper VBA code to carry out these actions - fitting the
report to the window and advancing the report a certain number of pages.
Any help you can provide is greatly appreciated.
Thanks.
In Access 2003 I have a vba module that runs on the On Open event for a
report that uses 2 different Sendkeys commands, one to fit the report to the
window
(SendKeys "%vzf" - i.e. view-zoom-fit) and one to advance the report pages
to a specific page based on a counter (SendKeys "{RIGHT}" - within a counter
loop). Since the Sendkeys command does not work properly in Vista, I am
looking for the proper VBA code to carry out these actions - fitting the
report to the window and advancing the report a certain number of pages.
Any help you can provide is greatly appreciated.
Thanks.