Results 1 to 9 of 9
  1. #1
    Join Date
    Mar 2008
    Posts
    11

    Unanswered: Regarding reports

    Normally when we run report, it opens in print preview mode. I want the reports to be saved first in some pre-defined location and then opened from that location for preview. how to do this ?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    unless you are using a PDF type printer you cannot specify the location

    you coudl try usign the save snapshot function.. hwoever I've had mixed results with snapshot.

    you cna automate the PDF saving depending on which PDF creation package you are using

    one trick is to name the report on its opening with the suitable path and filename

  3. #3
    Join Date
    Mar 2008
    Posts
    11

    Thanks...but i need some more info

    Thanks a lot ...In an application, there are two buttons for two reports. Clicking on one button, it is opening the report in preview mode. Clicking the second one it is asking for the location to save the report. How this is possible ? is there any settings or particular property ?

  4. #4
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    What is the code behind button number 2?

  5. #5
    Join Date
    Mar 2008
    Posts
    11
    In both cases one macro is referred which basically calls a report.
    In the 1st case, the print preview is opening and when print is clicked with Microsoft Office Document Image Writer, the save option is coming.

    But in the 2nd case, clicking on the button, it is opening the save window, basically skipping the intermediate steps -- 1)opening print preview, 2)clicking print and 3) selecting Microsoft Office Document Image Writer as printer

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Maybe the MODIW is set as the report's specific printer and the macro that calls the report isn't using the preview option.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  7. #7
    Join Date
    Mar 2008
    Posts
    11
    Could you please tell me, how i can avoid the print preview option in report and how to set MODIW as the default printer inside a report ?

  8. #8
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Take a look at the code behind button 2 and the page setup and/or any code in the report that it opens.

  9. #9
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    In the macro, there'd be a View propery for the OpenReport action.

    In the design of the report, the Page tab on Page Setup controls if it uses a specific printer or the default printer. Choose your MODIW as the specific printer for the report.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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