Results 1 to 3 of 3

Thread: Printing Report

  1. #1
    Join Date
    May 2004
    Posts
    65

    Unanswered: Printing Report

    I have a report generated from a command button on a form.

    I have the report set to popup to make sure it stays on top.
    (If not users tend to select print from the File menu and end up printing the Form)

    Because the underlying form is also popup and modal when the user selects file-print it prints the form.

    I tried setting the report modal to true. But then you cant print from the File menu.

    I am resolved by trying to have a message box popup when the report is closed to ask to print. If the user selects yes then I want the print dialog box to popup - not just automatically print.

    Issue resolved:
    on the close procedure code:
    DoCmd.RunCommand acCmdPrint
    Last edited by gavinfm; 09-20-04 at 09:31.

  2. #2
    Join Date
    Sep 2004
    Posts
    5

    Question Similar Problem i am facing

    Hi all,

    I am facing a problem in MS Access, I have a query that manupulate data and return some result e.g " Select name,age,city form employee" now i want to print every single result in seperate page. how can i do this using MS Access (VBA).

    Take care

    Regards.

    Osa

  3. #3
    Join Date
    May 2004
    Posts
    65

    Use the grouping tool

    The report design has a grouping button
    add the group on your record key on name

    Create a group header and force new page before section.

Posting Permissions

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