 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / December 2006Sent report to an external folder
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. 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  SignatureBest regards, ___________ Alex Dybenko (MVP) http://alexdyb.blogspot.com http://www.PointLtd.com > 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. Sorry, What do you mean by"Alphabetical List of Products", Thank's for the update > Hi, > you can save it in snapshot format, like: [quoted text clipped - 15 lines] > > folder' in 'report format' so when we print it out,it has the same > > appearance. > Sorry, > What do you mean by"Alphabetical List of Products", > Thank's for the update that's the name of the Report! (See Northwind). > > Hi, > > you can save it in snapshot format, like: [quoted text clipped - 16 lines] > > > folder' in 'report format' so when we print it out,it has the same > > > appearance. Guys, Why its generated "Run time error" Microsoft Acces can't save it to the file you have selected" Help Again > > Sorry, > > What do you mean by"Alphabetical List of Products", [quoted text clipped - 22 lines] > > > > folder' in 'report format' so when we print it out,it has the same > > > > appearance. 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/default.aspx?query=access+snapshot+report&ca talog=LCID%3D1033&spid=&qryWt=&mode=r&cus=False&x=9&y=16 SignatureBest regards, ___________ Alex Dybenko (MVP) http://alexdyb.blogspot.com http://www.PointLtd.com > Sorry, > What do you mean by"Alphabetical List of Products", [quoted text clipped - 21 lines] >> > folder' in 'report format' so when we print it out,it has the same >> > appearance. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.