Need help with a form and printing it

DougM

Registered User.
Local time
Today, 04:31
Joined
Apr 18, 2004
Messages
26
Howdy all,

I am doing a database dealing with types of woods and other materials. I have a form that will print out the data for the different woods/materials in small boxes. What I would like to do is have more than one box per page, but have each box be a different wood/material. I have it now so that I get 3 boxes on a page (left hand side) going down and each is a different wood/material. But I can't seem to figure out how to add boxes going across the page that will show different woods/materials. All that happens is a get one row of all the same wood/material. Does anyone know how I can change this?

Thank you,
Doug

P.S. Also is there anyway to create a form that will enable you to select one wood/material and print out just that one?
 
Last edited:
2 quick questions that I hope I can answer as well.

Is it a report you are printing, or the form? If it is a report (hope so, should be), is each type of wood a different record on your form? If so. when in design mode on your report select File -> Page SetUp, then columns. From there you can select the No of columns you want.

As for printing selected records try searching for "criteria". You need to base the report on a query that has the criteria set to the current recod on your form

Dave
 
Thank you!

Dave,

it is a report I am doing the printing from. I followed your directions and it is working even better than I dreamed! Thank you!

I will do a search for that and see what I can come up with.

Thank you,
Doug
 
There are 2 way to select the criteria for your reports. The first is to click the build button in query design and include this in the query. (See pic 1)

The second (and one I use) is to include the criteria in the docmd line

DoCmd.OpenReport "RptService", acViewPreview, , "ClientName = " & Me.PrintList

Me.PrintList is a listbox on a form that simply - for you - would list all the different types of wood.

The reason I prefer the second option is so that the query can be used as a record source for many reports and simply changing the criteria in the docmd line.

HTH

Dave
 

Attachments

  • pic1.JPG
    pic1.JPG
    46.8 KB · Views: 103

Users who are viewing this thread

Back
Top Bottom