473,322 Members | 1,690 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Restrict the number of records that print on a report

itm
I have a mail out to send to a group of owners with multiple accounts.
I want to limit the number of accounts that print on the first page to
20. I want remaining accounts to print on a second page. Is there a
way to accomplish this?

Thanks so much for your help!

Oct 26 '06 #1
7 3434
On 26 Oct 2006 11:47:55 -0700, it*@itmservices.com wrote:
I have a mail out to send to a group of owners with multiple accounts.
I want to limit the number of accounts that print on the first page to
20. I want remaining accounts to print on a second page. Is there a
way to accomplish this?

Thanks so much for your help!
Add an unbound control to the detail section.
Set it's Control source to
=1
Set it's Running Sum property to Over All
Name this control "RecCount"
You can make it not visible.

Add a page break control to the report detail section.

Code the Detail Format event:
PageBreakName.Visible = (Me.Page = 1 and Me![RecCount] = 20)
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Oct 26 '06 #2
itm
Thank you for providing excellent directions! I followed them however,
in my report, they did not produce the expected results. Is there
something else I need to do or check for? Your help is deeply
appreciated!

fredg wrote:
On 26 Oct 2006 11:47:55 -0700, it*@itmservices.com wrote:
I have a mail out to send to a group of owners with multiple accounts.
I want to limit the number of accounts that print on the first page to
20. I want remaining accounts to print on a second page. Is there a
way to accomplish this?

Thanks so much for your help!

Add an unbound control to the detail section.
Set it's Control source to
=1
Set it's Running Sum property to Over All
Name this control "RecCount"
You can make it not visible.

Add a page break control to the report detail section.

Code the Detail Format event:
PageBreakName.Visible = (Me.Page = 1 and Me![RecCount] = 20)
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Oct 27 '06 #3
On 27 Oct 2006 07:51:22 -0700, it*@itmservices.com wrote:
Thank you for providing excellent directions! I followed them however,
in my report, they did not produce the expected results. Is there
something else I need to do or check for? Your help is deeply
appreciated!

fredg wrote:
>On 26 Oct 2006 11:47:55 -0700, it*@itmservices.com wrote:
>>I have a mail out to send to a group of owners with multiple accounts.
I want to limit the number of accounts that print on the first page to
20. I want remaining accounts to print on a second page. Is there a
way to accomplish this?

Thanks so much for your help!

Add an unbound control to the detail section.
Set it's Control source to
=1
Set it's Running Sum property to Over All
Name this control "RecCount"
You can make it not visible.

Add a page break control to the report detail section.

Code the Detail Format event:
PageBreakName.Visible = (Me.Page = 1 and Me![RecCount] = 20)
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
You're there with the database and I'm here far away.
What results did you get?
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Oct 27 '06 #4
itm
Sorry. There was no change at all in the way the report ran. The
first page that would have more than 20 records in on page 35. It's
extra records print on the next page.

I sure appreciate you working with me to resolve this!
fredg wrote:
On 27 Oct 2006 07:51:22 -0700, it*@itmservices.com wrote:
Thank you for providing excellent directions! I followed them however,
in my report, they did not produce the expected results. Is there
something else I need to do or check for? Your help is deeply
appreciated!

fredg wrote:
On 26 Oct 2006 11:47:55 -0700, it*@itmservices.com wrote:

I have a mail out to send to a group of owners with multiple accounts.
I want to limit the number of accounts that print on the first page to
20. I want remaining accounts to print on a second page. Is there a
way to accomplish this?

Thanks so much for your help!

Add an unbound control to the detail section.
Set it's Control source to
=1
Set it's Running Sum property to Over All
Name this control "RecCount"
You can make it not visible.

Add a page break control to the report detail section.

Code the Detail Format event:
PageBreakName.Visible = (Me.Page = 1 and Me![RecCount] = 20)
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

You're there with the database and I'm here far away.
What results did you get?
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Oct 27 '06 #5
On 27 Oct 2006 14:35:52 -0700, it*@itmservices.com wrote:
Sorry. There was no change at all in the way the report ran. The
first page that would have more than 20 records in on page 35. It's
extra records print on the next page.

I sure appreciate you working with me to resolve this!
fredg wrote:
>On 27 Oct 2006 07:51:22 -0700, it*@itmservices.com wrote:
>>Thank you for providing excellent directions! I followed them however,
in my report, they did not produce the expected results. Is there
something else I need to do or check for? Your help is deeply
appreciated!

fredg wrote:
On 26 Oct 2006 11:47:55 -0700, it*@itmservices.com wrote:

I have a mail out to send to a group of owners with multiple accounts.
I want to limit the number of accounts that print on the first page to
20. I want remaining accounts to print on a second page. Is there a
way to accomplish this?
>
Thanks so much for your help!

Add an unbound control to the detail section.
Set it's Control source to
=1
Set it's Running Sum property to Over All
Name this control "RecCount"
You can make it not visible.

Add a page break control to the report detail section.

Code the Detail Format event:
PageBreakName.Visible = (Me.Page = 1 and Me![RecCount] = 20)
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

You're there with the database and I'm here far away.
What results did you get?
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Well, now I'm completely confused.
Your original post stated "I want to limit the number of accounts that
print on the first page to 20"
Now you state that the first page that has 'more' than 20 records is
page 35. Of course the code I gave you won't work, you're not on Page
1!
If it's always page 35 that has the more than 20 records, change the
code to reflect that. If there is some other criteria, then re-think
your question so that someone who is not there will understand it.
Re-write your question and re-post it.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Oct 27 '06 #6
itm
I'm sorry for the confusion. I did not mean that it is always any one
page that has more than 20 records.

It is one page letter. The bottom of the letter will list the accounts
for 1 owner. Some owners have more than 1 account. When I preview my
report with all owners, depending on the particular group of owners
selected, owners with more than 20 accounts could occur on page 1, then
not again until page 29. So it is not always on page 35 or always on
any particular page. It just happens that in the particular owner set
that I am working with right now, my first owner with more than 20
accounts is on the 35th page of the report in report preview. When I
initially referred to limiting the number of records on the first page
to 20, that was because the second page will have the remainder of the
accounts for that particular owner. (But I have to run the 2nd page
separately unless there is a way to include the second page in the
report to print if there are more than 20 records on the first page.)

Did I explain that any better?

Again, I apologize for the confusion and appreciate your patience!
Thanks for your help!

fredg wrote:
On 27 Oct 2006 14:35:52 -0700, it*@itmservices.com wrote:
Sorry. There was no change at all in the way the report ran. The
first page that would have more than 20 records in on page 35. It's
extra records print on the next page.

I sure appreciate you working with me to resolve this!
fredg wrote:
On 27 Oct 2006 07:51:22 -0700, it*@itmservices.com wrote:

Thank you for providing excellent directions! I followed them however,
in my report, they did not produce the expected results. Is there
something else I need to do or check for? Your help is deeply
appreciated!

fredg wrote:
On 26 Oct 2006 11:47:55 -0700, it*@itmservices.com wrote:

I have a mail out to send to a group of owners with multiple accounts.
I want to limit the number of accounts that print on the first page to
20. I want remaining accounts to print on a second page. Is there a
way to accomplish this?

Thanks so much for your help!

Add an unbound control to the detail section.
Set it's Control source to
=1
Set it's Running Sum property to Over All
Name this control "RecCount"
You can make it not visible.

Add a page break control to the report detail section.

Code the Detail Format event:
PageBreakName.Visible = (Me.Page = 1 and Me![RecCount] = 20)
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

You're there with the database and I'm here far away.
What results did you get?
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Well, now I'm completely confused.
Your original post stated "I want to limit the number of accounts that
print on the first page to 20"
Now you state that the first page that has 'more' than 20 records is
page 35. Of course the code I gave you won't work, you're not on Page
1!
If it's always page 35 that has the more than 20 records, change the
code to reflect that. If there is some other criteria, then re-think
your question so that someone who is not there will understand it.
Re-write your question and re-post it.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Oct 30 '06 #7
itm
Also, I just realized, the code you wrote is preventing more than 20
records from printing on the first page. I was misled because the rest
of the accounts are still printing on the top of the next record which
I didn't think would happen with the code. Please forgive me again!
Now, I either need a 2nd page in my report (which I am not sure is
possible) or I need the additional accounts (over 20) not to print on
the next record.

You are so appreciated, Fred!
it*@itmservices.com wrote:
I'm sorry for the confusion. I did not mean that it is always any one
page that has more than 20 records.

It is one page letter. The bottom of the letter will list the accounts
for 1 owner. Some owners have more than 1 account. When I preview my
report with all owners, depending on the particular group of owners
selected, owners with more than 20 accounts could occur on page 1, then
not again until page 29. So it is not always on page 35 or always on
any particular page. It just happens that in the particular owner set
that I am working with right now, my first owner with more than 20
accounts is on the 35th page of the report in report preview. When I
initially referred to limiting the number of records on the first page
to 20, that was because the second page will have the remainder of the
accounts for that particular owner. (But I have to run the 2nd page
separately unless there is a way to include the second page in the
report to print if there are more than 20 records on the first page.)

Did I explain that any better?

Again, I apologize for the confusion and appreciate your patience!
Thanks for your help!

fredg wrote:
On 27 Oct 2006 14:35:52 -0700, it*@itmservices.com wrote:
Sorry. There was no change at all in the way the report ran. The
first page that would have more than 20 records in on page 35. It's
extra records print on the next page.
>
I sure appreciate you working with me to resolve this!
fredg wrote:
>On 27 Oct 2006 07:51:22 -0700, it*@itmservices.com wrote:
>>
>>Thank you for providing excellent directions! I followed them however,
>>in my report, they did not produce the expected results. Is there
>>something else I need to do or check for? Your help is deeply
>>appreciated!
>>>
>>fredg wrote:
>>>On 26 Oct 2006 11:47:55 -0700, it*@itmservices.com wrote:
>>>>
>>>>I have a mail out to send to a group of owners with multiple accounts.
>>>>I want to limit the number of accounts that print on the first page to
>>>>20. I want remaining accounts to print on a second page. Is there a
>>>>way to accomplish this?
>>>>>
>>>>Thanks so much for your help!
>>>>
>>>Add an unbound control to the detail section.
>>>Set it's Control source to
>>>=1
>>>Set it's Running Sum property to Over All
>>>Name this control "RecCount"
>>>You can make it not visible.
>>>>
>>>Add a page break control to the report detail section.
>>>>
>>>Code the Detail Format event:
>>>PageBreakName.Visible = (Me.Page = 1 and Me![RecCount] = 20)
>>>--
>>>Fred
>>>Please respond only to this newsgroup.
>>>I do not reply to personal e-mail
>>
>You're there with the database and I'm here far away.
>What results did you get?
>--
>Fred
>Please respond only to this newsgroup.
>I do not reply to personal e-mail
Well, now I'm completely confused.
Your original post stated "I want to limit the number of accounts that
print on the first page to 20"
Now you state that the first page that has 'more' than 20 records is
page 35. Of course the code I gave you won't work, you're not on Page
1!
If it's always page 35 that has the more than 20 records, change the
code to reflect that. If there is some other criteria, then re-think
your question so that someone who is not there will understand it.
Re-write your question and re-post it.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Oct 30 '06 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: MLH | last post by:
I have a challenge... In a table I call tblStuff4Letters with 3 fields: , and . I have a report called rptOutboundCorrespondence that feeds off this table. Sorting & grouping is turned on in...
3
by: CSDunn | last post by:
Hello, I have a situation with MS Access 2000 in which I need to display report data in spreadsheet orientation (much like a datasheet view for a form). If you think of the report in terms of what...
4
by: Neil Coleclough | last post by:
I am constructing a database to process product returns for my Company. I have a number of toggle buttons to identify the stage to which each return has been processed. For example, clicking the...
9
by: MLH | last post by:
I have a source query (qryITSLetterList) feeding rows containing name, addr, city, state, zip and VehicleID to a report (rptITSnotices). The query may contain 1-to-5 records resulting in 1-to-5...
2
by: ricktech101 | last post by:
Hi, I have a table with a field that shows the number of pieces that a parcel contains. It looks like this: ParcelID, Pieces, Description Data example: 1001, 5, Jackets 1002, 10, shoes etc
6
by: Dave | last post by:
On my form I have combo boxes. These combo boxes, after updating them, populate respective listboxes that are located below the combo boxes on the same form. I am trying to use a "generate...
9
by: larryimic | last post by:
I have created a Access production database that records good parts and bad parts to a table thru querys using macros and command buttons on a form. A report (part label) is printed each time a...
2
by: srusskinyon | last post by:
I need some help getting unique records from our database! I work for a small non-profit homeless shelter. We keep track of guest information as well as what services we have offered for...
3
by: kmnotes04 | last post by:
Could anyone tell me how to restrict the date range for items that appear on a report? Old items from previous years appear on the report. I was asked to have only this year's items (and beyond)...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.