Save report to Snapshot

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to use the OutputTo macro to save my reports in snapshot, which
is working fine.
Each report is for indivisual employees so I want to be able to have it save
reports as "employees name" & "report name" automatically.
How is this done?
 
I figured out how to do this.

Now, I do not want the files to automatically save through the path.
I want to be able to specify which folder I'm going to save it on every time.
When I delete the path in the macro with only the file names, it
automatically saves
to My Documents.
Please Help.
 
Marco,

This is not my experience. I think that if you leave the Output File
argument blank, you will be prompted for the file path/name.
 
Thank you Steve.
I wanted to keep the name, and just specify the path every time.
If I leave out the Output File blank, I will need to type in the name.
 
Marco,

Ah, I see! Well, there are a couple of approaches that could be taken.
One would be to use VBA code, based on the information found at
http://www.mvps.org/access/api/api0001.htm
Another would be to have an unbound textbox on a form, which is open at
the time when you are doing your file output, and have the user type in
the path for the file in here. Then, in the Output File argument in
your macro, you put the equivalent of this...
=[NameOfTextbox] & "\YourFile.snp"
 
Back
Top