Change default file format for exporting

[slscanlon3]

In Access 2003, I want .rtf to be my default file format when a choose
to export a report. I must be an idiot because I can't find a place to
set that. Currently I have to select that file type EVERY time I go to
export, and that is quite often.

Any help?

 

[Guest]

If you are exporting the same data each time, create a macro or code and use
the OutputTo method. Automating a reoccuring job is was computers do best!

 

[Brendan Reynolds]

To the best of my knowledge, there's no such option. You can easily create a
routine to automate this, though. Here's a quick-and-dirty example using
InputBox. See 'OutputTo' in the help file for more information.

Public Sub ExportToRTF()

Dim ReportName As String
Dim TargetFile As String

ReportName = InputBox("Report to export?")
TargetFile = InputBox("RTF path/file name?")
DoCmd.OutputTo acOutputReport, ReportName, acFormatRTF, TargetFile, True

End Sub

 

[slscanlon3]

Thanks for the input... unfortunately I am talking about 20+ databases
and I can't begin to tell you how many reports... guess I will just
have to get use to selecting it each time. Access 2000 would always
pull the most recently used file type as default... miss that.

 

[Brendan Reynolds]

Those sound like arguments in favour of automating the process to me. But it
is, of course, up to you.

 

[slscanlon3]

Well I would like to, but the only way I know of requires code for each
single report in every database... I doubt my boss would allow me to
spend that much time automating something like a default file type.

 

[Brendan Reynolds]

The code I posted prompts for the name of the report and the output file, so
it would handle all reports in one database - no need to re-write the code
for each report.

 

[slscanlon3]

I suppose that could be useful on the databases where I am the sole
user... thanks! As for those with multiple low level end users... I
don't want to complicate things to much for them. (I know it isn't
that complicated... but I mean it when I say "low level").

 

[Brendan Reynolds]

You could get create a more user-friendly solution that offered a list of
reports to choose from rather than the 'quick-and-dirty' approach of using
InputBox. Whether the time and effort would be justified or not is of course
something that only you can decide.