-
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.
-
Why not Savethe Form as a Report and use that "filtered" to the Current record on the form?
-
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.
-
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
-
Forum Rules