Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Print Access report from shortcut? (Any)

    I'd like to create a shortcut on users' desktops that would print a specific report, without any additional access to a database. The database is on a server, the report's query criteria require no user interaction. Any tips?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts

    Re: Print Access report from shortcut? (Any)

    The computer will still need to open the database to get the print but it can all be automated.
    Create a macro that prints the report and then quits access. When this is working, have a look at the online help for 'Startup command-line options'. This will explain how to create a shortcut that opens the database and runs the macro.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  3. #3
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Print Access report from shortcut? (Any)

    Thanks for the pointer, a few hours ago I actually just made a form that on open printed the report, then closed access. I dragged the form onto the desktop, thus creating a shortcut, so sort of a hodgepodge of what you said and what I did...thanks for looking at this though [img]/forums/images/smilies/smile.gif[/img]
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •