code_junkie

How to programmatically make a Query in MS Access default to landscape when printed

Nov 10th, 2011
144
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. Function SetLandscape()
  2. Application.Printer.Orientation = acPRORLandscape
  3. End Function
  4.  
  5. Private sub
  6. Application.Printer.Orientation = acPRORLandscape
  7. DoCmd.OpenQuery "qry1", acViewNormal, acReadOnly
  8. DoCmd.PrintOut acPrintAll
  9. End Sub
  10.  
  11. docmd.Close acQuery, "qry1", acSaveNo
Add Comment
Please, Sign In to add comment