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?
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.