How to run a report with the click of a button. - [RESOLVED]

[JimMuglia]

Greetings,

I have a report in place, now I just need to run it at the click of a button on an Access form. The button is called "cmdStep3", the report is called "rpt_FSR_Details", and the form and report are both in the database called "FinancialRecords".

Here is what I have, somebody please help me fill in the event, so that the reprot can be run on the click:

Private Sub cmdStep3_Click()
'run rpt_FSR_Details
End Sub

Thank you,
Jim

[salvelinus]

Private Sub cmdStep3_Click()
   Docmd.OpenReport "rpt_FSR_Details"
End Sub

[JimMuglia]

Thank you Salvelinus, I was able to figure that one out after checking out Northwind. One thing I want to figure out now is this:

Once a report is generated, is there an easy way to shoot the Print Preview report to, say, Excel? I went to "Analyze with Excel" and it looks like hell, nothing like the report itself.

What I'm sayng is that, sure, I can print out the hard copy fine for someone; but what if they want me to email it to them? How would I do that? When I go to save the report, you can only save it into a database. That does me no good; I need a soft copy of the report that I can email to someone. Any ideas?

Before you say it, I already know that there is a Send To...Mail Recipient item in the File menu. However, my email is accessed from the yahoo web page, so that doesn't apply to my situation.

Thank you,
Jim

[RobDog888]

What if you analyzed it with Word? I think it would look better.
Unless you had Acrobat (Full version) you would
have a convert to pdf which would make it loook good and anyone can DL Reader for free to view it.

[dglienna]

CutePDF Writer is a print emulator that will create a .PDF of whatever is sent to the it.
I use it to save trees when developing reports.

[JimMuglia]

What if you analyzed it with Word? I think it would look better.
Unless you had Acrobat (Full version) you would
have a convert to pdf which would make it loook good and anyone can DL Reader for free to view it.

Its looking pretty sharp in PDF. Thanks for resolving my issue, RobDog888.

Guess I'll put my next series of questions, in another post.

Thanks again,
Jim