I'm managing a database at work that has many users. When the users first open the database it opens to a switchboard, then they have some options of where they can go and what they can do. One of the options is viewing some reports. I want to have a button available to export the data to a spreadsheet but when opening the report this way it only opens in print preview making the button inaccessible. Is there anyway around that so the button is available?
Make button accessible to users
- Thread starter HVACMAN24
- Start date
If you're using Access 2007 there's a new view called Report View which can handle button-click events (and others) performed on the report. In the Print Preview mode there's no interactivity.
You can prompt the user on the ON CLOSE event of the report. Prior to that you would have saved the recordsource of the report in a variable which you would use if the user selects YES on the Message Box prompt.
You can prompt the user on the ON CLOSE event of the report. Prior to that you would have saved the recordsource of the report in a variable which you would use if the user selects YES on the Message Box prompt.
vbaInet has provided an excellent option if you have and use 2007. However, if you do not use 2007 you might want to condider creating a new menu form where you can inclued an option group with three options: Preview, Print and Export. With this in place you can then use a Case statment to cause the results as selected in the group option by the user to be determined and executed.
Thanks guys. Yea, I had the property of the actual report set to open in Report View but when using the switchboard to open it, it still open in Preview mode. I found that the switchboard had code in it to open the report in preview mode, I changed that to Report View and it works fine now. It sucks not being the original creator of the database, makes it harder when you have to know how the program works plus how another guy programed it. =) Thank again.
hehe!
