How do I create a shortcut to a report within an access database

[Linds]

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.

[Tom van Stiphout]

On 19 Mar 2007 17:28:20 -0700, "Linds" <If********@gmail.comwrote:

Use the /x command line argument to run a macro of your choice.
Program that macro to run your report.

-Tom.

>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.

[Larry Linson]

"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

[CDMAPoster]

On Mar 19, 8:28 pm, "Linds" <[e-mail]:

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 Access is in full screen mode then Restore Down Access using the
button with two overlapping windows next to the X. In the database
window, click the Reports tab then drag the report to your desktop.
This will create a shortcut directly to your report.

James A. Fortune
CD********@FortuneJames.com

[fredg]

On 19 Mar 2007 17:28:20 -0700, Linds wrote:

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.

On the main database folder, right-click on the report you wish to
open.
Select Create Shortcut.
A shortcut to this report will be placed on the desktop.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[Linds]

On Mar 19, 10:31 pm, [e-mail] wrote:

On Mar 19, 8:28 pm, "Linds" <[e-mail]:

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 Access is in full screen mode then Restore Down Access using the
button with two overlapping windows next to the X. In the database
window, click the Reports tab then drag the report to your desktop.
This will create a shortcut directly to your report.

James A. Fortune
[e-mail]

Thanks for the easy answer:) This was the type of shortcut I was
looking for.