Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

Print Multiple Reports On Legal With One Button

  • Please log in to reply




  • Member
  • PipPipPip
  • 626 posts

We keep track of our inventory in an Access Database. I have created reports for each type of inventory. We'll say, PCs, Monitors, Printers, etc. Each type of device has its own report. I'd like to create a way to print all of these reports with one command, or button. For example; we may decide to print all of these reports at the first of each month. Instead of pulling the reports up one by one, it would be nice to just click a button from the switchboard and have them all print back to back.

I was playing with Macros to get the job done, but I am unable to figure out how to get the Macro to default to Legal sized paper. My reports are set up for legal, but when I run my macro, they all print out on letter paper. This, of course, means we are trying to piece together all of the pieces of paper to get any real use from the report. In addition, it just uses too many sheets of paper. Hmm...any way to make it default to Legal?

Any and all information will be greatly appreciated.


  • 0


Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP