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