PDF creation in VBA

[BobRich99]

I have a front end ACCESS database at a clients location. One of the forms creates a PDF in VBA of a document using this code:



DoCmd.OutputTo acOutputReport, "TicketCopy", acFormatPDF, FileName, False, , , acExportQualityPrint


I have used this code many times and it works fine on my development environment here in Access 2007. One of the PC's at the client is running 2007 and this works fine on that PC. On another machine running Access 2010 it gets a run time error 2501 and bombs ( the error is trapped, but the pdf isn't created in the target folder)

I cant find anything on how 2010 handles PDF creation differently then 2007

[Rawb]

I have no problems creating PDFs in Access 2010 using the same method you show here. You can try removing everything after FileName and see if that helps (since those are all the default values anyway), but if that doesn't work, you may want to try reinstalling Access.

Also, even though Access 2007 and 2010 are fairly close to each other, I don't recommend using different versions like that. Since you know Access 2007 works, I'd suggest you remove 2010 and install 2007 on the problem machine.

[ssanfu]

You also might check the references on the A2010 computer. See if there is a reference that says "Missing".