473,326 Members | 2,337 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

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

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
5 13134
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

"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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Nicola | last post by:
Hi Everyone, I am new to programming and would like to know how to open an access Report from within vb 6. I am trying to write a program to organise cross stitch threads. I have found out how...
27
by: aa | last post by:
Thought this question might be out of this NG's scope, there are always knowledgable people who might hava an answer. A hyperlink to a shortcut to a file returnes an empty screen, and the source...
1
by: intl04 | last post by:
I am getting strange print-related error messages when trying to create (not print!) reports. For example, when I click 'new' to create a report then choose 'design view', I get an error message...
7
by: dog | last post by:
I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I...
5
by: Steven | last post by:
I have some text boxes on a form in MS Access 2000. When I right click in them I don't get any shortcut menu at all. I want the normal cut, copy, and past menu to come up. In the "Startup", I...
1
by: jan | last post by:
Hello, I am new to this list and would appreciate some help with Access 2000 and Access 2003. I need to export our access database table statements by access database to place into our database...
9
by: badboybrown | last post by:
Hello, Is it possible to step through the "Create MDE" process and see what is causing Access to crash? I tried, unsuccessfully, many times to create an MDE from my database. But, randomly, I...
9
by: RMC | last post by:
Hello, I'm looking for a way to parse/format a memo field within a report. The Access 2000 database (application) has an equipment table that holds a memo field. Within the report, the memo...
3
by: creative1 | last post by:
Here is how you create a complex data report that involves parent and child commands and you can update information at runtime. Its pretty straight forward to work with simple queries; however,...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.