Results 1 to 4 of 4
  1. #1
    zp18zp18 is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2011
    Posts
    2

    Distributing Reports

    I have written several report formats for the users to run but do not want them to have to load access. I would like to put a folder on the desktop with the several report icons in the folder. When they need to run a particular report, they open the folder, click on the icon and walk to the printer.

    What is the best way to insulate (or isolate) the users from the Access interface?



    TIA
    GWB

  2. #2
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    One way to do this is to use macros. Create a separate macro for each report hat prints the report and then exits Access.

    Now you can create a shortcut for each report. Each shortcut include a command line switch to run the desired macro for that report.

    Example:

    "C:\Program Files\Microsoft Office\Office12\msaccess.exe" "C:\myProgram\northwind.mdb" /X RunReport1
    Last edited by HiTechCoach; 01-09-2011 at 01:14 PM.

  3. #3
    zp18zp18 is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2011
    Posts
    2
    OK, So I have a data base C:\tricycle.mdb and there are four reports defined tricycle1, tricycle2, etc.

    The way to print these guys from the command line would be to write 4 macros (RunTri1, RunTri2. . .) all containing one docmd line:

    DoCmd.OpenReport "Tricycle1", acViewNormal,,

    Then call them from the command line:

    "C:\Program Files\Microsoft Office\Office12\msaccess.exe" "C:\Tricycle.mdb" /X RunTri1

    Is that it?

    If so, I'll give it a try. Actually I never thought of calling these from the command line, I thought there was a Crystal Reports way of compiling the report into an executable and then just calling the executable. Shows what I get for thinking <gr>

    Thanks, GWB

  4. #4
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    Yes, that was the idea. I think you are getting.

    Give it a try and let us know how it goes.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access Reports drop sub-reports
    By Kevin Ellis in forum Reports
    Replies: 0
    Last Post: 11-19-2010, 03:28 PM
  2. Distributing Access 2007 Application
    By AndreQ1 in forum Access
    Replies: 2
    Last Post: 09-08-2010, 09:27 AM
  3. Evenly distributing fields
    By pledbetter in forum Forms
    Replies: 7
    Last Post: 01-08-2010, 02:38 PM
  4. Help with reports
    By geetha001 in forum Access
    Replies: 0
    Last Post: 01-21-2009, 08:45 AM
  5. Need Help on reports
    By MeehPhill in forum Reports
    Replies: 3
    Last Post: 07-31-2006, 11:51 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums