Save to file in access97

Sam Summers

Registered User.
Local time
Today, 15:06
Joined
Sep 17, 2001
Messages
939
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.
 
OutputTo and common dialog

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
llkhoutx said:
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.
 

Users who are viewing this thread

Back
Top Bottom