"Linds" <If********@gmail.comwrote in message
news:11**********************@y66g2000hsf.googlegr oups.com...
>I have a report within my access database that I would like to have a
shortcut on my desktop that could bring up that report.
In other words, now I have to double click on the database, then go
into the reports module, then double click on the report.
You can probably guess I am a newbie at access, so any push in the
right direction would be greatly appreciated.
If you always want to open that database to the report, in the database
window, you can click Tools on the menu, then Startup, and set a startup
form, with code in the Open Event to open the report . . . if you aren't
"into" VBA code, create a Form, use the Command button, and copy the code
from the Click event, that was generated by the Wizard.
If you only want to open the database to the Report, create a Shortcut, then
edit the Command Line to execute a macro. You'll find that described in
Help -- in Access 2003, search Help for "Command Line" and look at the topic
"Set command-line options for starting Access".
Larry Linson
Microsoft Access MVP