[AccessD] Print Button

Mark,

We have a Reports toolbar, which is attached to each report, so shows
when the report is previewed.  From a 'Print Options' button on that
toolbar, we call this function:

		Public Function PrintCurrentReportWithOptions()
		'Opens the print options dialog box for current report.
		'Called by toolbar on all reports.
		On Error GoTo eh
		    DoCmd.RunCommand acCmdPrint
		ex:
		    Exit Function
		eh:
		    If Err.Number = 2501 Then
		        'Ignore if user just cancelled the print job.
		    Else
		        MsgBox Err.Description
		    End If
		    GoTo ex
		End Function


Not extremely high tech, but very serviceable. 


Thanks,

Liz 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
Sent: Friday, April 21, 2006 11:01 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Print Button

Hello All,

I need a button on a custom tool bar that opens the print dialogue
instead of printing to the default printer.  Each time I try to add it
using the customize option the result is a button that prints...no
option to choose printer.

Thanks,

Mark A. Matte


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com