macro out put to

[rahmad]

Hi All,
How to out put report by using macro.Last time I used out put to but it seem
it will transfer all the record,I want to transfer the selected report or
the report which is displaying.please help,urgent

 

[Steve Schapel]

Rahmad,

What format do you want to output it to? The most direct way to output
a report is to print it. To do this via a macro, you use the OpenReport
action.

Either way, if you want the report to only include certain records, then
you normally will make a Query that will return the records you want,
and then use that query as the Record Source for the report.

 

[rahmad]

Steve here is the situation,
The company provide a computer for my dept,
but there is no printer network connected to that computer,
and the administrator also not provide Ms Outlook
so that the report can't be sent by email.They just provide
a shared folder to the computer and badly,sometimes they as me
for the report.So,what is the good way to provide a report for a certain
record
than output it to a folder and print it from another computer.

 

[Douglas J. Steele]

Save the report as a Snapshot, and make sure that everyone who needs it has
the free Snapshot viewer.

Alternatively, look at what Stephen Lebans has at
http://www.lebans.com/reporttopdf.htm for how you can create PDF files from
your reports.