Access 2010 / PDF
I'm using Access 2010 and I want to send the form (not report) via pdf preferability)
I have a table that stores the email addresses; button on the form which when the user hits is suppose to make an pdf of the form.
Dim rsEmail As DAO.Recordset
Dim strEmail As String
Set rsEmail = CurrentDb.OpenRecordset("tblDEmailList") 'table where email is
strEmail = rsEmail.Fields("dEmailAddress").Value
Do While Not rsEmail.EOF
strEmail = strEmail & " ; " & rsEmail.Fields("dEmailAddress").Value
DoCmd.SendObject , Forms!frmDataSystem, acFormatPDF, strEmail, , , "Data System Request", "See Attached Request", , False
I've tried many variations, with various runtime errors
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Used Stephen Lebans code to save reports as .pdf in 2000 but doesn't work well with 2010.
I know 2010 allows reports to be saved as .pdf files but just having a mental blank on how this is done
I often create PDF files using Access 2003 (through PDF Create VBA Object Model), open the PDF File in Adobe 9 (or later), and provide a hyperlink in the database.
I can do the same thing in Access 2010.
However, if I open the pdf file through the hyperlink in Access 2003 (user admin), I can sign the PDF File electronically. This would require me to save (overwrite) the file in the directory. This works fine in Access 2003.
If I try this in Access 2010 (also user Admin), it doesn't work. The PDF File opens in Adobe 9, and I can sign it. However, if I want to save it it tells me that I don't have the rights to do so. If I opened the file from the Windows system (now the user is me), I can sign the file electronically and overwrite the previous file.
I suspect that the user "Admin" in 2010 is different from that in 2003. How can I make them the same, in particular how can I make them that of
I have an access program whereby I can click on a 'My Folder' tab and see the pertinent files stored therin ie word 2010 and PDF files. I can open/close or just cancel repeatedly if the slected file is a word file, but the second I do the same for a PDF it hangs the access system and I have to close it all by task manager. I think if I wait long enough it will eventually take hold, but time is precious for the impatient!
My sytem is office 2010, adobe or Sumutra PDF readers, running on SBS
DoCmd.OutputTo acOutputReport, "Data", acFormatPDF, "FullPathToFile.pdf", True
Can anyone tell me what might be causing this. The report has data and I can preview it and even export to pdf by using the acrobat tab in the ribbon
Anyway, I'm having a few "issues." The one I'm trying to work on right now deals with the Lebans Report-To-PDF software (which is now unsupported). Again, it works fine in 2003 and 2007 (as it did back in A2K .
All my reports are internally defined as "portrait" using 8.5x11 paper. But when I run this under Access 2010 Runtime (Windows 7), I get a PDF that's a bit odd shaped.
I opened the PDF using the Adobe reader and checked the properties. It shows a width of 11.69 inches, and a length of 8.27 inches (which is landscape). And there's no footer on the page (there should be a footer with the page number and date).
If I print this report using the same software, it comes out fine. This is just an issue with Report-To-PDF.
I was able to get by just using the Create, Add, and Saveas functions, so it's very basic functionality I need. I just don't know which library to use.
Can anyone tell me the VBA code that will let me PDF and email an indiviual report based on a given unique ID. I am happy for the user to add the email address, subject and message body and for them to click send