Recent content by Pimped

I've hit a problem already :( When I try to run the following code, I get the error: Runtime error 2051, The OutputTo action was canceled. DoCmd.OutputTo acOutputReport, "Remittance", acFormatPDF, "C:\filename.pdf", True I've tried False at the end. I've also tried set the filename as follows...

Thanks Beetle :)

Hey guys So I've got a split database where the accdb data file resides on a mapped network folder and the accde front end resides on every computer that needs to use the system. There are currently 5 computers on the network that are on at the same time using the system. A scenario is that...

very good point about the email size. Potentially, the email could be 100s of megabytes if the user decides to go on an attachment spree! :o Might be a good idea to allow the user to check which files they want to send along with the email before they click "email invoice". Thanks for the tips :)

You're right. When I say on the fly, I mean that it creates a pdf temporarily to attach to an email and then discard it later. This is the scenario: The user is in a form which is used to build up the elements of an invoice (job form). They can then click "print invoice" or "email invoice". If...

Thanks for the reply mate. At the moment, I am using access to convert the report to PDF and attach it to a new outlook message. I have seen ways where you can use "OLMail" to attach multiple files to a new outlook message. What I want to do is merge the two techniques so that if the user...

Hey guys Scenario: User is looking at a job details. Job has pictures and PDF's as external files saved in the filesystem of the computer. User clicks Email Invoice. System attaches report as a PDF and opens Outlook Email message with email address, subject and body filled and the report PDF as...