Hi Richard, I have found your courses excellent and have nearly finished my database. I have one annoying problem which is when printing a report. I have a piano tuning database in which I have customers with lots of pianos. I have created a report to show which pianos have been tuned. This shows the pianos okay in a nice print preview page, then when I print it does not print one page, but as many records that are shown on the page. So 12 pianos the 12 pages all showing 12 records. I am sure there is a quick fix or something silly I have done. Please can you help? Also how can I put a print button on a report when in pop up mode, without it showing up on the printed paper?
Reply from Richard Rost:
You just need to filter the data in your report to show just the records you want. Use a query, as I show in class. Without seeing your database, it's difficult for me to tell you where the problem is.
Button on a report? We don't put buttons on reports, only on forms. :)
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 5.