Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

General questions

Status
Not open for further replies.

sabavno

Programmer
Jul 25, 2002
381
CA
Hi

I want to produce a very basic report. What I also want is the command buttons "PRINT", "E-MAIL", "SAVE AS EXCEL FILE", "CLOSE"

Is anyting of the above achiveble?
Please advise on the best approaches?

Thanks
 
Yes you can do this. You can write code to put under each of the 4 buttons on a form. Or, you can create a custom toolbar that is tied to the report and presents and icon for each of the 4 actions.
1. Print - See OpenReport Method in help files.
2. E-mail - See SendObject in help files
3. Excel - See TransferSpreadsheet (also look under Excel in help)
4. Close - See Close Method in help files
5. Also, look under Toolbars for help in creating a custom toolbar or menubar.

Hope this gets you started.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top