VBA Code to Convert Report to PDF

[GeneralShamu]

Here is the code I am trying to run:
Forms![FormName]![LstBSource] = "SourceName"
Forms![FormName]![LstBVariable] = "VariableName"
DoCmd.OpenReport "ReportName", acViewDesign
Reports![ReportName].Caption = "VariableName"
DoCmd.OpenReport "ReportName", acViewNormal

For some reason though, it does not work, the pdf that is created is blank where charts/data would be pulled in. (The page is not completely blank, there is a title and column headings.)

I have several SourceName/Variable Name combinations (100+) so I have these 5 lines of code repeated as many times in one big VBA code file in Access.

What am I doing wrong to convert this to a PDF?

 

[jackd]

Here is the code I am trying to run:
Forms![FormName]![LstBSource] = "SourceName"
Forms![FormName]![LstBVariable] = "VariableName"
DoCmd.OpenReport "ReportName", acViewDesign
Reports![ReportName].Caption = "VariableName"
DoCmd.OpenReport "ReportName", acViewNormal

For some reason though, it does not work, the pdf that is created is blank where charts/data would be pulled in. (The page is not completely blank, there is a title and column headings.)

I have several SourceName/Variable Name combinations (100+) so I have these 5 lines of code repeated as many times in one big VBA code file in Access.

What am I doing wrong to convert this to a PDF?

I'm not sure what software versions you are using, but here is a l ink to a site with responses to a similar question.

http://www.tek-tips.com/viewthread.cfm?qid=1510461&page=8


Here is another link to a popular site that claims to have a routine to convert Access Reports and Snapshots to pdf.

http://www.lebans.com/reporttopdf.htm

 

[Will_B]

I haven't tried this myself, but this thread (see below) says the following will do the trick in Access 2007:

DoCmd.OutputTo acOutputReport, "rptoffer", acFormatPDF, myFileName

On this link, start from the bottom of the page to skip the early VBA error dialog.
http://www.utteraccess.com/forums/printthread.php?Cat=&Board=85&main=1386182&type=thread

 

[seenfresh]

Greetings,

I couldn't help notice this thread is related to a task I am trying to accomplish...

I need to convert "multiple" ms access reports into "one" pdf file using vba. This thread details how to convert one ms access report into a pdf file at a time, but I am curious how to get multiple reports to convert together. This option is available using the Adobe Professional version 8, or 9.

Does anyone have any ideas or related articles that detail this objective?

Any suggestions would be amazing...

Cheers