Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / December 2006

Tip: Looking for answers? Try searching our database.

Export Report Automated

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tomrector@svsatscott.com - 18 Dec 2006 12:15 GMT
Thanks to your guys help, I now have a working report that "exports"
correctly, no blank lines.

  However I do not want user to have to select File, Export, select
parameters, or enter file name.

So how do I automate selecting a report,  have that report exported
(as right click on report, export),  as MS-DOS,  assign a
directory/file name, done without the user having to make a choice,
except select "Print Report"from switchboard.

report name is AClass   file name is E:\class\Class.txt

Thanks
Tom Rector
dneagle - 18 Dec 2006 14:54 GMT
>Thanks to your guys help, I now have a working report that "exports"
>correctly, no blank lines.
[quoted text clipped - 11 lines]
>Thanks
>Tom Rector
Export to where? And, if the user does not select the report to export, how
do you decide which report needs exporting?

Signature

David

tomrector@svsatscott.com - 18 Dec 2006 20:42 GMT
David,
  Export the report to a text file on the E drive.
  The user will select the report thru a switchboard menu item, (open
report).

I want the user to select options from a switchboard, the option would
open a report (named AClass).   Then rather than have the user click on
"File",   "Export", "Select file type as text"  enter the file name to
save the export as ("E:\Class\Class.txt) ,  select format MSDOS, and
then OK,  I am asking how to make all that happen with a macro or with
VB code.

Tom

> >Thanks to your guys help, I now have a working report that "exports"
> >correctly, no blank lines.
[quoted text clipped - 19 lines]
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200612/1
 
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.