Recent content by Elwood

I have an attachment field in my table where PDF files are stored. Is it possible set a button up to email the stored attachment using a macro or maybe some code behind a button? This is code I used to email a report as a PDF. Private Sub cmdEmail_Click() On Error GoTo Err_cmdEmail_Click Dim...

Paul you are a GOD! Works like a charm. Thank you for sharing your time. Kevin

Throwing an error. "The action or method requires a Report Name argument".

Thank you for the reply Paul, I’m embarrassed to say my coding has been trial and error with copy and paste. Not sure how to add a wherecondition. Would that follow the acPreview? Can you give me an example?

I am trying to email one record as a PDF attachment. Below is the code I’m using. The problem is it puts every record into the PDF. At one time I had the same problem while printing I was able to print one record by using the ID field to print one record at a time: DoCmd.OpenReport stDocName...