Mark A Matte
markamatte at hotmail.com
Fri Apr 21 12:58:04 CDT 2006
Thanks Liz, What I also found was that if I created a custom toolbar...and just moved the print option from the File menu...then reset the file menu...and allowed menus in the startup...this worked...but I don't understand why I can't choose this type of 'print' buttom from the customize wizard? Thanks again, Mark A. Matte >From: "Liz Doering" <ldoering at symphonyinfo.com> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: "Access Developers discussion and problem >solving"<accessd at databaseadvisors.com> >Subject: Re: [AccessD] Print Button >Date: Fri, 21 Apr 2006 11:12:55 -0500 > >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 > > > > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com