By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,972 Members | 844 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,972 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
5 Replies


P: n/a
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

P: n/a

"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

P: n/a
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

P: n/a
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

P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.