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.

Mar 20 '07 #1

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.

Mar 20 '07 #2

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

Mar 20 '07 #3

CDMAPoster

On Mar 19, 8:28 pm, "Linds" <Ifollow...@gmail.comwrote:

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

Mar 20 '07 #4

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

Mar 20 '07 #5

Linds

On Mar 19, 10:31 pm, CDMAPos...@FortuneJames.com wrote:

On Mar 19, 8:28 pm, "Linds" <Ifollow...@gmail.comwrote:

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
CDMAPos...@FortuneJames.com

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

Mar 20 '07 #6