Output Files 1

[dek394]

I am trying to output a report that I have automatically to a folder in a snapshot form. I am trying to get this file to save as the date, but with my current code it saves as "=date().snp" instead of "5/8/2003.snp" Here is my code:

DoCmd.OutputTo acOutputReport, "NAS Inventory/Capital by Product Family", "Snapshot Format", "C:\Documents and Settings\kingd4\My Documents\=Date().snp"

Does anyone have any ideas on how to fix this problem?
Thanks
Dennis

 

[psemianonymous]

You're close.

DoCmd.OutputTo acOutputReport, "NAS Inventory/Capital by Product Family", "Snapshot Format", "C:\Documents and Settings\kingd4\My Documents\" & Format(Date(),"mm-dd-yyyy") & ".snp"

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm

 

[dek394]

Nice, that worked great. I think the date format that I was using was giving me errors because of the "/"'s in the name. Anyways, thanks again.

Dennis