Recent content by chrisvt

I export several reports to pdf that are shared with co-workers. A few reports include hyperlinks to various websites. Is it possible to create hyperlinks to documents saved on our network that the end user could open by clicking the link in the pdf file? Instead of linking to...

Perfect! Thanks, bob! I knew it was something simple.

I'm creating a report that uses a query for its Record Source. The name of the query is ProjectStatus and it contains three fields: ProjectName, Classification, and Ranking. There are approximately 60 records in the query and each record has a Ranking of either Open, Closed or Pending. I have...

You're very welcome. Glad I could help.

TravelingCat - my apologies. I thought you were looking to see how I solved this for 2010. For 2003, I used the following code. The StewID in the filter is the unique identifier for each project. filepath (I renamed this OutputPath in the 2010 version) and OutputPDFname are as I...

Hi TravelingCat - The key portions of the code that I posted are: OutputPath = "\Archive\MonitoringReports\2010 Monitoring Report.pdf" OutputFile = Folder + OutputPath and DoCmd.OutputTo acReport, stDocName, acFormatPDF, OutputFile, True The table that is used to generate the report has a...

Thanks, Bob. Just to close my own thread, I was never able to get this to work in Access 2010 with the Lebans code so I re-coded everything using the built-in convert to PDF functionality. Everything is performing as it should and the reports are exporting in Portrait orientation. For what...

I never solved my issue but that was because I had to move on to some more urgent projects. I'll report back if I come up with a solution.

It is. Additionally, the report preview shows things correctly in portrait orientation and the built-in convert to pdf functionality exports in portrait orientation.

Thanks, vbaInet, I'll start looking into it. I was hoping to avoid that only because I need to export the reports to specific folders on our network (with the path coming from a field in one of my tables) and had the labens code setup to do that. it works perfect except for the landscape issue.

I've been successfully using the Lebans convert to pdf code in our Access 2003 databases. A few days ago we migrated to Access 2010 and while the code still works, every pdf that it creates is in landscape format, which is a problem because the report that I am converting needs to be in...

Perfect!! Thank you very much.

hhmm, it still seems to be defaulting to the desktop. Any idea what I am missing? Do I need to Dim something at the top? Private Sub printreport_Click() Dim blret As Boolean Dim stdocname As String Dim Filter As String Filter = "AutoID = forms!frmstwLSR!AutoID"...

Thanks, Bob. Where would that code go in relation to my previous code? After the first blRet line?

Hello- I'm using the Lebans code to convert my report to pdf. http://www.lebans.com/reporttopdf.htm It is working great, except that I was wondering if there was a way to change the default location where the pdf is saved. It is currently defaulting to save to my desktop and I'd prefer to...