Default Location exported files

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
 
D

Douglas J. Steele

Rather than using Me.m & ".rtf" for the file name, try CurrentProject.Path &
"\" & Me.m & ".rtf"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top