Next Page in Print Preview via Form Buttons

[bg18461]

Is it possible to use vba cmd buttons on a form to mimic the first,prev,next,last buttons that will change the print preview page of a report. I will only have 1 report open at a time. any ideas?

 

[Poppa Smurf]

Is it possible to use vba cmd buttons on a form to mimic the first,prev,next,last buttons that will change the print preview page of a report. I will only have 1 report open at a time. any ideas?

Why waste time trying to mimic a form. Have you tried the HOME, END, PAGE UP and PAGE DOWN keys? You will find that they perform the required functions.

Also the Navigation Buttons at the bottom of the screen will do the required functions.

 

[bg18461]

Well I have a form (frmControls) that opens up after the user presses a button on a different form(frmSelectCustomer) to launch the report. frmControls seems to have the focus and i cant press any other buttons in access without closing the form. The frmControls has buttons to print to pdf, or printer, while the "acpreview" mode of the report is shown behind the form, that is why i was trying to get put the buttons on the form, because i could not press anything in access. if you can help me to get the form to share focus with access then that would work to.

frmcontrols and frmselectcustomer are pop-up and non-modal

 

[Poppa Smurf]

Is there any reason why the Controls are not on the frmSelectCustomer?

For a selected report e.g Selected Staff member, I have a form with a drop down box to select the staff member. The form also has buttons to Email, Preview, Print and Close the form.

This allows the user to Email or Print the report for the select staff member without Viewing the report. Using the Print Preview the user can also send as an email or print.

 

[bg18461]

Its a little too big and I want the user to see the print preview of the report. The frmConrtols is a small form just with those buttons on it so it can be visible and still show the report.