Search results

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...

Is it possible to have the same subreport appear multiple times in a single report, but have each instance report data from different dropdowns on my form? I have a form with several dropdowns (addressdropdown1, addressdropdown2, addressdropdown3, etc.) through which the user can select a name...

Thanks, David. I'm new to access so please bear with me...the checkboxes are embedded in the report, but when I go the Properties of the Detail section in which they appear, I don't know where to add the code. Do I go to the Event tab>>On Format?

Hi all- I have a form that contains a number of check boxes. As things are currently setup, when the user enters data into the form, the corresponding report shows ALL the check boxes, whether they were checked or not. I'd like the report to show ONLY the boxes that were checked. Would this...

Two of the seven. I also have another, separate form that also links to the same table and was giving me the same Write Conflict error. I was able to eliminate all the errors by going into sql and deleting the field that I had added yesterday but of course now I'm back to square one. Thanks...

Ok, so I went in and there were 7 subforms. Four were already setup with Select Queries and the other three were linked directly to tables. For the three that were linked to the tables, I invoked the Query builder and setup a Select Query. Because each subform was sourcing data from only one...