printing 24 pages instead of 1 page on printer

[ariel81]

i have this problem in my report. it print out 1 X 24 pages instead of one page. can't find out where is the problem. how to force it to print 1 page instead?

 

[rainman89]

im assuming u have the record source of the report as a query?
its printing out 24 pages because its querying all the records that u have.
what are u trying to print it based on?(ie someone entering the data? or is it a record search then print?)

 

[GaryPanic]

working on the assumption that your report is based on a qry
run your qry - how many lines (records) do you have

let the forum know this as there are a couple of solutions
g

 

[ariel81]

i am printing a report whose "details" section is written with code builder to search for data in a table.

 

[rainman89]

So it is a query.
What is the search based on?

 

[ariel81]

rather difficult to explain here...but i have zipped up my program (Mod_qp.zip) here so that it can be easier unserstood.

basically upon user click print/ preview on the form "frmFltQpi", then report "FLT Report" will be open.

upon report open, there is are 12 textboxes in the report using the Function
=SendToFltReport( ) to load data from the table to the respective indexed "unbound" textboxes.

the =SendToFltReport( ) function is written in the code modules.

notice if all the 12 mths from jan to dec are filled up, it prints 24 duplicates.
if not all the 12 mths are filled up, it prints lesser duplicates

see year 2007 and 2008 form "frmFltQpi".

thank you.

oh...my zip file size is 511KB size too big to upload here.
can i pm u and send u the file?

 

[rainman89]

email or delete the things in your db that u dont need help with. should shrink the size

 

[boblarson]

...but i have zipped up my program (Mod_qp.zip)

BEFORE Zipping, did you run Compact and Repair?

Tools > Database Tools > Compact and Repair

 

[ariel81]

ok, after deleteing things that are not required to be include in the file and after "Tools > Database Tools > Compact and Repair" from advise by boblarson.

here is the file... (Mod1_qp.zip)

 

[ariel81]

finally, managed to solve...the duplicates are due to the same query in the code builder and the report properties query.

i have deleted the query in the report properties and use only the code builder to write the query.