Report Open as PDF - like the internet

[School Boy Error]

After the user has run the query form I have instructed the macro to open the report when the user enters the information and clicks ok - this is all working fine. What I would like to do is when the user clicks ok it comes up with a box like if I were downloading a pdf - e.g. open or save the pdf. It's a database that is going to be accessed over the LAN so I have no idea where people would like to save their pdfs, if they want to save them at all.

Sorry if this has been covered, I haven't been able to find anything via Google to do what I want and only been using Access since Sunday!

Thanks

[rpeare]

What is your question? How do you determine where they want their PDF exported? If so you can have an text box on your form that generates the report that asks for the path they want to put the PDF (there are some fancy things you can do like open a dialog box to let them navigate there, but if you're a novice it might be difficult to get it working). If you're talking about HOW to do it There's a function in access 2007 and higher to handle outputting to a pdf (syntax below)

DoCmd.OutputTo acOutputReport,"ReportName",acFormatPDF,"D:\Access\Reportname.pdf"

[School Boy Error]

Thanks. Am I able to edit that statement so that it just opens ups as a pdf? I guess it would be saved in a temporary location. This way the user could save it, if they wanted or just look at the records and close it after they have the information they need. I was thinking like when I go to click on a pdf on a webpage it comes up with open, save etc. I click open, look at it and then can either close if I don't want it or I hit save as if I want to keep it. I was hoping to achieve something to similar to this.

[rpeare]

Typically what I would do is have an option group that had options of 'preview report', 'send to printer', 'export to pdf', 'export to data to text file', 'export data to excel' etc as options and base what you do with your report or the data driving it on what the user selects. In essence it's the same thing but to do what you're asking for would require a lot more code likely involving a some custom toolbars etc to simulate what you see on a website.