Action buttom on desktop that opens directly an Access report

[Fred's]

Hi Guys,

I've created a report in access. Now, I will like to know if is
possible to create an (action buttom or a link) on my desktop that
opens directly a report in access?


Any help on this will be very appreciated.

Thanking you in advance,
Fred's

 

[Douglas J. Steele]

You could create a macro that opens the report, then create a shortcut on
your desktop that opens the database and runs that macro.

The shortcut must include the full path to msaccess.exe, and the /x switch
(followed by the name of the macro):

"C:\Program Files\Microsoft Office\Office\MSAccess.exe" "C:\Program
Files\Microsoft Office\Office\Samples\Northwind.mdb" /x OpenMyReport

 

[Fred's]

Hi Doug,

Thank you for the info. Whatever I need for info.

Do I put the full path in the properties of my database shorcut icon?
If yes, In which fields?
In Target, in Start In or in Comments field?

Thank you for your support.
Fred's

 

[ajetrumpet]

Fred,

Objects in Access can be copied to your desktop. They're just like file shortcuts...
Try dragging the report icon in your database window to the desktop.

 

[Douglas J. Steele]

What I indicated would be in the Target field.