RE: [AccessDevelopers] acSendReport Problem

[Carl Beck]

Set the reports to the “Microsoft Office Document Image Writer” printer. This should be installed on all machines with Access 2000 or above.     Carl Beck All About Photos  www.allaboutphotos.net     From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Tom Oakes Sent: Thursday, January 26, 2006 2:48 PM To: AccessDevelopers@yahoogroups.com Subject: RE: [AccessDevelopers] acSendReport Problem   I don't think there's any way around this, without installing a printer.  Access obviously uses the print setup options to format the report (even if you're not actually printing it).  You can install a generic text printer on the PC's and that should solve your problem.  You could also create logon scripts for everyone that maps a specific printer.    Tom Oakes Personal PC Consultants, Inc. [EMAIL PROTECTED] 503.230.0911 (O) 402.578.2648 (C) 512.727.9497 (F)     From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of pjscott1951 Sent: Thursday, January 26, 2006 5:44 AM To: AccessDevelopers@yahoogroups.com Subject: [AccessDevelopers] acSendReport Problem I have a command button that sends a maintenance work order report via Outlook. I use the following code to send the report as an attachment: "DoCmd.SendObject acSendReport, "rptMaintWO", acFormatRTF, "E-mail Address",, , "Maintenance Work Order", , False". This works fine if the user has a printer or is networked to a printer. The problem is some people log-on to computers that need a networked printer setup (and the majority of are using don't have the skills to do this). In this case when they click the button to send the work order they get a popup "You must install a printer before you can print". It's error 2296. I found if you take out "acSendReport" of the code an e-mail will send but the report will not be send the report attachment. Does anyone know why this is happening and is there anyway to code around this error? Thanks for the help, Paul Please zip all files prior to uploading to Files section. YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.