Topics Search

Access 2010 / PDF

Access 2010 / PDF
Views: 6
I've read thru the files on this topic and it doesn't seem like anyone has addressed this issue:

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.

Sub OpenSendRequestAsAttachment()
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
Sponsored Links:

More topics


How to save a report as a pdf file - 2010

Just updating our database following conversion from 2000 to 2010.

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

Save Form In PDF Format

Unlike previous versions, Access 2010 offers a direct way to publish reports and forms in widely used document publishing format – PDF. Once you’ve done creating your forms in Access 2010, you can export the form into PDF and XPS format

Can't sign PDFs created by Access 2010

I have two database front ends, one in Access 2003 on XP and another on Access 2010 on windows 7.
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

why do PDF's opened via access hang?


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

Can't output report as pdf in Access 2010

I receive The OutputTo Action Was Cancelled, Error 2501 when trying to output a report as a pdf with Access 2010 and Adobe Acrobat X.

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

Save report as pdf

I am considering purchasing Access 2010, but it is essential I be able to save reports as pdf's. Does Access 2010 include that function?

Export to PDF Document Format

Contrasting to Access 2007, in which you need to install add-ins to export database. Access 2010 offers option of exporting database in PDF (Portable Document Format) and XPS (XML paper Specification) formats. Now with Access 2010, you can export datasheet, Forms and Reports to a .pdf or .xps file, it enables you to spread information in an easy-to -distribute form that contains all formatting characteristics.

Testing with Access 2010

I'm currently testing an application under Access 2010 Runtime. The application is developed in Access 2003 and works under Access 2003 and 2007 just fine. As I anticipate that some of my users (there are over 1,000 worldwide) will eventually want to use Access 2010, I decided to run some tests.

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.

Combining TIFs into a single TIF or PDF in Access 2010

Is there a way in Access 2010 to combine tif files into a single tif or pdf file (either output is fine) using VBA? I was using the Microsoft Office Document Imaging Library, but Microsofthas stopped supporting this for 2010 and I'd like to keep moving forward as opposed to installing older software on computers.

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.

Access 2010 PDF and Email a Report Using VBA Code

I'm using Access 2010 and found the Send to Email as PDF command indispensible. However, I have a problem in that I've hidden the main ribbon from my users which means they can't actually click that button.

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