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!
7  3476 
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.V isible = (Me.Page = 1 and Me![RecCount] = 20)
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
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.V isible = (Me.Page = 1 and Me![RecCount] = 20)
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
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
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.V isible = (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
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:
PageBreakNam e.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
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
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:
>>>PageBreakNam e.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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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
that report - sorted first on (ascending)
then on (ascending). Of course,
there are more supporting fields in the table. The
above 3 are the significant fields for this discussion.
|
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 a spreadsheet might show, the
column names will actually be dynamic, based on data from a SQL Server 2000
database. The row data will also come from the same database. So in this
case, I will have a main report and a subreport. I've already tried...
|
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 first button
confirms that the goods are now in our building awaiting initial
processing. This button then fires off an email to our warehouse staff
alerting them to the fact. I want to restrict these buttons to single
use, so that once the email...
|
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 sheets of paper
coming out of the printer. The report is a form letter. Each row in
the source query results in a single page letter being printed.
Suppose I could include a field in the query . The
value in this field would be from 1-to-4. So if...
|
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
| | |
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 report" button
located on my form to print all of the list box values (that have been
updated via selection from combo boxes) from the form to the report.
I've tried using a macro with the code:
Macro Name: cmdGenerateReport : On Click
Action:...
|
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 command button is clicked for good or bad parts. When the container is filled with good parts, the operator manualy clicks a command button to print a report (container label). I have been asked to automate the container label report so it prints when...
|
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 statistical
purposes.
I've been using
Here's the situation:
I have two main tables:
|
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) listed
on the report. How do I do that?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
