We help IT Professionals succeed at work.
Get Started

Access 2007 - queries & printing - form vs reports

greenprg asked
Last Modified: 2013-11-28
In order to select and sort records for viewing on a form, I create a query then open my form using the query.  Then from the form which happens to be landscape, I have a button for printing and the only way I've gotten it to work is to define the query a second time and open a report with the query and sending it to the printer.  It seems so redundant.  I'm thinking there must be a better way.  So here are my questions.

1) Is there a way to sort the records if I open the form using the filters?  It seems like a filtered form does not have an option for sorting the records.
2) Using an embedded macro for printing on the form always prints in portrait.  From what I've read, I don't think there is a way to change the orientation of the form to use landscape.  Has this changed?
3) Can I optimize my code by only using a report instead of a form?  Since my form and report are almost identical, I was wondering if I could get rid of my form and just use the report..... but then I couldn't figure out a way to make it do the same thing, preview the report then print if the user presses a print button.  If I put a print button on the report, is there a way to call the same report without having to re-define the query again?  

I'm guessing I'm making this more complicated than I need to.  Please help.
Watch Question
Owner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010
This problem has been solved!
Unlock 3 Answers and 6 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE