Sent report to an external folder

[chooriang]

Dear All,
Is it possible to export a selected record 'from a form' to 'an external
folder' in 'report format' so when we print it out,it has the same
appearance.

 

[Alex Dybenko]

Hi,
you can save it in snapshot format, like:
DoCmd.OutputTo acOutputReport, "Alphabetical List of Products", _
acFormatSNP, "C:\My Documents\", True

also you can save it in MOD format (print to its driver), but this requeiry
human interaction

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[chooriang]

Sorry,
What do you mean by"Alphabetical List of Products",
Thank's for the update

 

[pietlinden]

Sorry,
What do you mean by"Alphabetical List of Products",
Thank's for the update

that's the name of the Report! (See Northwind).

 

[chooriang]

Guys,
Why its generated "Run time error"
Microsoft Acces can't save it to the file you have selected"
Help Again

 

[Alex Dybenko]

Hi,
this is a name of report, just replace it with your own
here some articles, which can help you also:
http://support.microsoft.com/search...D=1033&spid=&qryWt=&mode=r&cus=False&x=9&y=16

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com