Is it possible to save a report to file in Access97?
I can do this already in access 2002

Thank you in advance

What you want is the

"DoCmd.OutputTo"

command. Lookup the argumnets under the Access "Help" menmu.

I am using:-

DoCmd.OutputTo acReport, stDocName, acFormatRTF, , False

which works in Access 2002 but when i convert the database to Access 97 it no longer works?

Your code

DoCmd.OutputTo acReport, stDocName, acFormatRTF, , False

should be changed to

DoCmd.OutputTo acOutputReport , stDocName, acFormatRTF, , False

It clearly states that in the Access Help when you search on "outputto' (without the quotes).

With the 3rd argumnet blank, you user will be prompted for a (folder and) file name. I programmatically specify a default folder and file use the common dialog to let the user select the folder and file.

Thanks very much,

I'll try that

IIkhoutx, can you explain how you programmatically integrate the OutputTo command with the command dialog so the user can choose where to save the file?

Thanks,
Bill Echert
Your code



should be changed to

DoCmd.OutputTo acOutputReport , stDocName, acFormatRTF, , False

It clearly states that in the Access Help when you search on "outputto' (without the quotes).

With the 3rd argumnet blank, you user will be prompted for a (folder and) file name. I programmatically specify a default folder and file use the common dialog to let the user select the folder and file.