Doug Murphy
dw-murphy at cox.net
Fri Jan 8 14:27:29 CST 2010
The way I do this is to create a print button in a menu, or ribon for 2007. The print button opens the print dialog box. I also have a button for sending the report to pdf. That button calls the Leban's print to pdf code. All works well and looks professional. The menu property of the report is set to this menu custom menu bar. Doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark Sent: Friday, January 08, 2010 10:46 AM To: Access Developers discussion and problem solving Subject: [AccessD] Send report to printer...after viewing I just wrote a program that creates vouchers for court witnesses...they take these vouchers to the county treasurer and get a check. As per the suggestion of a list member...Reuben Cummings, I think it was...I built the whole of the report via code. This worked out fantastically, and I am very happy w/it. After typing in the witness and case data, the user can hit the "Create Voucher" button, and you get a print preview of the voucher, and are able to verify the information on it. However...I would like there to be a way to send this to the printer, if it looks correct. Currently one must click the office button and choose to print, but I'd like a quicker option, if possible. When you then close the preview, the form opens back up. Here are my thoughts so far: (A) Keep it the way it is... Hey, it works right? But, I like functionality, and if I were the user, I'd like a button. This is an extra task that this department is inheriting, from the courts, so this will already be an interruption for them and I'd like to make it as simple as possible. (B) Put a button on a form... Can you do this? It looks like you can, but are they really buttons? (C) Implement a "Hot Key"... If this is possible, it still really isn't very intuitive...if the user and myself both die in tragic accidents simultaneously...hey, anything is possible...will anyone know how to do this? (D) Kick up another form, along w/the report, which would have the buttons on it (E) Skip the whole idea of a preview and just send the darn thing to the printer from the original button... this would be the easiest, and if there is an error...oh, well! Ideas? What do y'all do? And, this actually...depending on how I end up going...may bring up another issue. I'll make that another post though... -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com