Save report to Snapshot MarcoR 21.09.2006 22:14:01 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?

RE: Save report to Snapshot MarcoR 22.09.2006 15:37:02 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. "MarcoR" wrote: [Quoted Text] > 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? > >

Re: Save report to Snapshot Steve Schapel <schapel[ at ]mvps.org.ns> 25.09.2006 07:16:45 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. -- Steve Schapel, Microsoft Access MVP MarcoR wrote: [Quoted Text] > 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.

Re: Save report to Snapshot MarcoR 28.09.2006 19:01:03 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. "Steve Schapel" wrote: [Quoted Text] > 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. > > -- > Steve Schapel, Microsoft Access MVP > > MarcoR wrote: > > 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. >

Re: Save report to Snapshot Steve Schapel <schapel[ at ]mvps.org.ns> 28.09.2006 19:33:59 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" -- Steve Schapel, Microsoft Access MVP MarcoR wrote: [Quoted Text] > 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. >