Default page setup for queries

  • Thread starter Thread starter George Wilson
  • Start date Start date
G

George Wilson

I have a customer who prints a lot of queries. For them to
print properly she has to change the page setup to
landscape every time she prints. This happens for me too.
Is there a way to set the default page setup to be
landscape when printing from queries?
 
Hi George,

Thank you for using the Microsoft Access Newsgroups.

Your Question:
I have a customer who prints a lot of queries. For them to print properly
she has to change the page setup to landscape every time she prints. This
happens for me too. Is there a way to set the default page setup to be
landscape when printing from queries?


If needing to control the layout of the results I recommend that you use
Reports instead. Within Reports you have more control over the layout.

TIP: use the AutoReport Tabular wizard to create the Report quickly and
redirect your customer to use the Reports instead.


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
 
Not that I'm aware of, but it might be possible in XP.

Is she running these as adhoc queries (is she manually playing around
with parameters, or are they parameterized queries).

If they are parameterized, where all she has to do is enter the
parameters when asked, then you could give her a form with a combo box
or listbox that contains all of her queries. You could then use code
similiar to that shown below to open the print dialog box and allow
her to run select landscape.

DoCmd.SelectObject acQuery, me.cboQueryName, True
DoCmd.RunCommand acCmdPrint

You also might want to check out the PrtDevMode example in the Help
file. This will let you set the orientation. Maybe you could put
that code in some code that fires when she opens the database.


--
HTH

Dale Fye


I have a customer who prints a lot of queries. For them to
print properly she has to change the page setup to
landscape every time she prints. This happens for me too.
Is there a way to set the default page setup to be
landscape when printing from queries?
 
Back
Top