Choosing the location of an outputted rtf file

[Sam Summers]

Hi

I am halfway there with this one.

I am outputting a Report as an RTF file but need to give the users the choice of choosing the location as it will always be on a network and the location and paths will change for each new client.

This is the code i am currently using but this doesnt bring up the explorer window.

Dim tmpFile As String

tmpFile = "OldAccessLocationDates" & Format(Date + Time, "ddmmyy_hhnn") & ".RTF"
stDocName = "ViewOldAccessDatesRpt"
DoCmd.OutputTo acOutputReport, stDocName, acFormatRTF, tmpFile, False

Any ideas

Thank you in advance

 

[llkhoutx]

Search this site for the "common dialog". It allows your user to select/specify a folder and file like the wWndows Explorer.