DoCmd OutputTo

D

data123

How do I correct the path name so it will reflect the field valu

DoCmd.OutputTo acOutputReport, "TEST1", "Snapshot Format",
"C:\=[FORMS]![PropertyAbbreviations].[PROPERTYNAME].snp", Fals
 
D

Duane Hookom

DoCmd.OutputTo acOutputReport, "TEST1", "Snapshot Format", _
"C:\" & [FORMS]![PropertyAbbreviations].[PROPERTYNAME] & ".snp", False
 

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

Similar Threads

Suppress display when outputting to a Snapshot file 1
Why I'm getting runtime error 2501 1
DoCmd.OutputTo Crashes Access 2007 0
nodata on reports 3
OutputTo PDF error 2501 The OutputTo action was cancelled 1
Error on OutputTo 1
Snapshot Files 2
How to make Subdirectory using OutputTo for Snapshot files from recordset 2

Top