Snapshot File Location

[racer25]

Hi Guys,

I am very new at this and from copy pasting various bits of code I have a button I click on that creates snapshots to a location, and another button that attach's them to emails reaady for sending.

My problem is that each time I click the create file button I would like to change the folder they are stored in.

My code for snapshot creator is

Private Sub Command2_Click()
DoCmd.OutputTo acOutputReport, "Dublin Wholesale - Summary Report", acFormatSNP, "C:\Snap.snp"
DoCmd.OutputTo acOutputReport, "Dublin Wholesale - Detailed Report", acFormatSNP, "C:\Snap2.snp"

End Sub

The file part of the folder location that changes is January2006 to February2006 etc. etc.

Could somone please assist me with this simple (I hope) problem.

Thanks in advance.

Rob

 

[racer25]

Figured it out - thanks to anyone who read this.