Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print Button on PopUp Preview 1

Status
Not open for further replies.

edbloom

Technical User
Apr 20, 2006
9
US
How do I get a Print Button to appear in the Top Handle bar of the report popup window when a report is opened using the standard Switchboard commands?

I was demonstrating progress made and had the report come up using the Switchboard command. Now I have been told that the new design spec REQUIRE a print button to appear as well on that window (because all other bars and window are turned off the the normal user).

Any help with this will be most appreciated.
 
Don't know of any way to run an event off of a report view.

The following may work for you.

I created a from called frmPrintThis with a single command button "Print rptAcc". Set the Form's border to 'none', No dividing lines, scroll bars, record selectors, etc. Made the form as small as possible and sized the command button to the same size. It looks like a print button.

On Report's Open and Close Events:
Code:
Private Sub Report_Close()
DoCmd.Close acForm, "frmPrintThisRpt"
End Sub
_____________________________________
Private Sub Report_Open(Cancel As Integer)
DoCmd.Restore
Me.Move 0, 1000
DoCmd.OpenForm "frmPrintThisRpt"
Form_frmPrintThisRpt.Move Report_rptAcc.WindowLeft + Report_rptAcc.Width - Form_frmPrintThisRpt.Width, 0
End Sub

Report opens in NOT Maximized view at left side of screen. It is pushed down 1000 twips to let the form rest just above the report at the right edge.


 
Thank you. it works to some degree. I had to change the 1000 to 350 to ge them to line up. I think it will meet the need.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top