Consulting

Results 1 to 4 of 4

Thread: Printing A Form

  1. #1
    Knowledge Base Approver VBAX Master Oorang's Avatar
    Joined
    Jan 2007
    Posts
    1,135
    Location

    Printing A Form

    I have a form that I am printing using the [vba]Access.DoCmd.RunCommand acCmdPrint[/vba] syntax. I choose that particular method because I want the form to print (apx) as it looks on screen. The problem is that it defaults to printing "all records", and you can't even belive how many people forget to change it to "Select Record". I considered switching to the [vba]DoCmd.PrintOut[/vba] syntax, but then the user cannot select the printer unless I construct a form. Is their a way to get
    RunCommand syntax to default to "selection" (preferred) or am I stuck using the form/Printout combination?

    Edit:
    I'm still messing around with this and was using the ShowPrinter common dialog with hopes of using it in conjuction with the printout method, but when I select the printer and tell it to store the on the printer (by changing the output method), the common dialog doesn't seem to make the change.
    Cordially,
    Aaron



    Keep Our Board Clean!
    • Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
    • Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.

  2. #2
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    Why not Savethe Form as a Report and use that "filtered" to the Current record on the form?

  3. #3
    Knowledge Base Approver VBAX Master Oorang's Avatar
    Joined
    Jan 2007
    Posts
    1,135
    Location
    I'm not sure how that would solve the problem?
    Cordially,
    Aaron



    Keep Our Board Clean!
    • Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
    • Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.

  4. #4
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    if you use the acpreview method, then the user can either just print or choose a printer first.

Posting Permissions

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