PDF location

[kitty77]

I have a report with a command button that creates a pdf and sends it to a specific folder.
Is there a way to be able to choose where the pdf goes instead? Maybe a drop down with different locations?

Thanks.

 

[theDBguy]

Have you looked at the FileDialog object?

FileDialog object (Office)

Office VBA reference topic

learn.microsoft.com

 

[kitty77]

Do you know of any example db's out there?

 

[theDBguy]

The last two in this list should have an example of how to use it.

Access Demos

www.accessmvp.com

 

[Pat Hartman]

Here an example that uses Excel. I'm sure you can get by that