Default Location exported files

  • Thread starter Thread starter gg
  • Start date Start date
G

gg

To export reports to other formats, I use command:
DoCmd.OutputTo acOutputReport, reportName, acFormatRTF,
Me.rn & ".rtf" , (for example.)

Sometimes the exported file ends up in the folder
containing the program, other times in "My documents" and
other times somewhere else. How do I force it to always
send to whatever folder contains the Access program file?
I don't want to open a dialog box-it just confuses some
people. I would like to just tell users to click the
button and look for it in whatever folder they stored the
program.

I'm developing with Access 2000 on w2000. some users have
acc2002 and acc2003. User operating systems are
everything from w95 to latest
 
Rather than using Me.m & ".rtf" for the file name, try CurrentProject.Path &
"\" & Me.m & ".rtf"
 
Back
Top