Search results

So I simplified the code, but I'm still getting errors. This one says there's a missing operator and it's pointing to the line with my filter variables.

Will this give me individual pdf's? The problem I think I'm facing is not the export of the report as a whole (I was able to do that), but in getting the report to divide itself by location and save each locations information as separate pdf's.

Hi All. I need some help with my report and their subsequent subreports. Currently I am generating a report with 3 separate sub reports and all the reports are based on a series of parameters specified on a form (ie. Start Date, End Date, ID, etc...). Each sub report is based off it's own query...

I did some looking around on the DLookup() and the Recordset. I think the DLookup might be the best solution. Because this DB is going to be viewed by multiple people, I don't want them to be able to see the file path for the documents. What would the syntax/coding be for a DLookup() be if once...

propSurvey contains the file path to where the particular document is located. It does not appear anywhere on the form, it only exists in the record on the table. I can place that field on the form as a simple bound textbox control

I should make it less confusing. propSurvey is the button, but the field the hyperlink is in is also labled propSurvey. I will rename the button to be SurveyDoc. Is this relevant to how the question appears? Now the code would appear: Private SurveyDoc_Click() Application.FollowHyperlink...

I saw that coding on another post but I couldn't make it work. My understanding of this may be flawed. I'm not trying to pull from a textbox on a form. The path of the file is located in a table with text formatting. I'm trying to use a button to pull linked document directly from the table via...

pbaldy, I tried your suggestion and I'm still getting ,"Object doesn't support this property or method" message.

So here's my issue... I have a database of properties. Each of these properties has several pdf documents that are associated with each property. In one table I have all the properties and information. In the second table I have all the hyperlinks to the documents. What I would like to do is...