Possible to add "Print" menu from Print Preview?

[iamdamien]

Hi,
Just wanted to know if there is a way to enable a small menu for the user to print once a report is in print preview mode. I have the report appear in print preview mode pop up in a form. Other than right clicking and pressing print that way, is there a way to add a print button to the pop up form?
thanks.
D.

 

[DentTec]

Just hit Ctrl+P

 

[iamdamien]

Right; I was hoping to add some buttons to the form that appears so the user can just press that. Is it not really possible?

 

[DentTec]

Then add a command button to your form, choose Report Operations, Print Report, then choose your report.

 

[iamdamien]

No, I want a print option once within the print preview pop up. Not a separate form for printing. That way the user can view and decide whether they want to print the report or not.

 

[Jeanette Cunningham]

The standard way is to add a button with code on its click event.
DoCmd.OpenReport "ReportName", acViewPreview

If you want to print a specific record, use:
DoCmd.OpenReport "RptMyReport", acViewPreview, , "MyID=" & KeyFieldName

If the field MyID is a text field, use:
DoCmd.OpenReport "RptMyReport", acViewPreview, , "MyID=""" & KeyFieldName & """"


Replace my object names with your own.

 

[iamdamien]

Thanks for the help; but I know the way I want to do it seems like it is not possible in Access. I thought there would be an inbuilt option bar on the print preview pop up, obviously not. Ctrl+P or right clicking and printing will have to suffice.

 

[Jeanette Cunningham]

You did ask "Right; I was hoping to add some buttons to the form that appears so the user can just press that. Is it not really possible? "

 

[Jeanette Cunningham]

You can build your own custom menus.
You could build a custom menu for that form and include a print preview button.

Are you using A2010 and embedding a report in a form?