page break

  • Thread starter Thread starter JIM.H.
  • Start date Start date
J

JIM.H.

how can you put page break based on a value of the group
in the report? I do not want to put page break for each
value in the group, only for some certain values.
 
how can you put page break based on a value of the group
in the report? I do not want to put page break for each
value in the group, only for some certain values.
Click to expand...

Answered in Queries newsgroup.
 
Thanks Fred,
Is says can not find macro: myPageBreak.Visible =
[myFiled] = "Test"
What that might be?
Also can I put a page break on the filed wich is not a
grouped field?
Thanks,
Jim.
 
Thanks Fred,
Is says can not find macro: myPageBreak.Visible =
[myFiled] = "Test"
What that might be?
Also can I put a page break on the filed wich is not a
grouped field?
Thanks,
Jim.
-----Original Message-----
Click to expand...
Click to expand...

This was my reply from the Queries newsgroup:

Add a page break control to the top of the Group Header.
Code the Group Header Format event:
PageBreakName.Visible = [LastName] = "Jones"

Of course you'll use the correct name of the page break and the
correct group Field and criteria.

The Message you are getting leads me to believe you wrote the above
code on the Event line, not in the event code window.

Start again.
On the GroupHeader Format event line, write:
[Event Procedure]
Then click on the button with the 3 dots that will appear on that
line.
When the event code window opens there will be 2 already existing
lines of code.
BETWEEN those 2 lines, write:
myPageBreak.Visible = [myFiled] = "Test"

Exit the code window.
Run the report.

I'm assuming the actual name of the Page Break is 'myPageBreak', the
actual name of the field in Group Header is 'myFiled' (is that exactly
how you spelled it?) and that the criteria is 'Test'.

You can place a page break in any section of your report.
 
Thanks Fred,
It is very helpful. myFiled is my group name and I also
need to put a page break if the field name: myName="Test"
in the group. can you help me again?
Thanks,
Jim.
-----Original Message-----
Thanks Fred,
Is says can not find macro: myPageBreak.Visible =
[myFiled] = "Test"
What that might be?
Also can I put a page break on the filed wich is not a
grouped field?
Thanks,
Jim.
-----Original Message-----
On Thu, 8 Apr 2004 19:30:14 -0700, JIM.H. wrote:

how can you put page break based on a value of the group
in the report? I do not want to put page break for each
value in the group, only for some certain values.
Click to expand...
Click to expand...

This was my reply from the Queries newsgroup:

Add a page break control to the top of the Group Header.
Code the Group Header Format event:
PageBreakName.Visible = [LastName] = "Jones"

Of course you'll use the correct name of the page break and the
correct group Field and criteria.

The Message you are getting leads me to believe you wrote the above
code on the Event line, not in the event code window.

Start again.
On the GroupHeader Format event line, write:
[Event Procedure]
Then click on the button with the 3 dots that will appear on that
line.
When the event code window opens there will be 2 already existing
lines of code.
BETWEEN those 2 lines, write:
myPageBreak.Visible = [myFiled] = "Test"

Exit the code window.
Run the report.

I'm assuming the actual name of the Page Break is 'myPageBreak', the
actual name of the field in Group Header is 'myFiled' (is that exactly
how you spelled it?) and that the criteria is 'Test'.

You can place a page break in any section of your report.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Ok. It seems I can do that in detail section too. I am
taking back my previous question. However for next values
I need to remove page break, how should I do that?
Thanks,
Jim.
-----Original Message-----
Thanks Fred,
Is says can not find macro: myPageBreak.Visible =
[myFiled] = "Test"
What that might be?
Also can I put a page break on the filed wich is not a
grouped field?
Thanks,
Jim.
-----Original Message-----
On Thu, 8 Apr 2004 19:30:14 -0700, JIM.H. wrote:

how can you put page break based on a value of the group
in the report? I do not want to put page break for each
value in the group, only for some certain values.
Click to expand...
Click to expand...

This was my reply from the Queries newsgroup:

Add a page break control to the top of the Group Header.
Code the Group Header Format event:
PageBreakName.Visible = [LastName] = "Jones"

Of course you'll use the correct name of the page break and the
correct group Field and criteria.

The Message you are getting leads me to believe you wrote the above
code on the Event line, not in the event code window.

Start again.
On the GroupHeader Format event line, write:
[Event Procedure]
Then click on the button with the 3 dots that will appear on that
line.
When the event code window opens there will be 2 already existing
lines of code.
BETWEEN those 2 lines, write:
myPageBreak.Visible = [myFiled] = "Test"

Exit the code window.
Run the report.

I'm assuming the actual name of the Page Break is 'myPageBreak', the
actual name of the field in Group Header is 'myFiled' (is that exactly
how you spelled it?) and that the criteria is 'Test'.

You can place a page break in any section of your report.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Ok. It seems I can do that in detail section too. I am
taking back my previous question. However for next values
I need to remove page break, how should I do that?
Thanks,
Jim.
-----Original Message-----
Thanks Fred,
Is says can not find macro: myPageBreak.Visible =
[myFiled] = "Test"
What that might be?
Also can I put a page break on the filed wich is not a
grouped field?
Thanks,
Jim.
-----Original Message-----
On Thu, 8 Apr 2004 19:30:14 -0700, JIM.H. wrote:

how can you put page break based on a value of the
group
in the report? I do not want to put page break for each
value in the group, only for some certain values.
Click to expand...

This was my reply from the Queries newsgroup:

Add a page break control to the top of the Group Header.
Code the Group Header Format event:
PageBreakName.Visible = [LastName] = "Jones"

Of course you'll use the correct name of the page break and the
correct group Field and criteria.

The Message you are getting leads me to believe you wrote the above
code on the Event line, not in the event code window.

Start again.
On the GroupHeader Format event line, write:
[Event Procedure]
Then click on the button with the 3 dots that will appear on that
line.
When the event code window opens there will be 2 already existing
lines of code.
BETWEEN those 2 lines, write:
myPageBreak.Visible = [myFiled] = "Test"

Exit the code window.
Run the report.

I'm assuming the actual name of the Page Break is 'myPageBreak', the
actual name of the field in Group Header is 'myFiled' (is that exactly
how you spelled it?) and that the criteria is 'Test'.

You can place a page break in any section of your report.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
Click to expand...

There is nothing to remove.
The page break can sit there but won't have any effect unless the
criteria is met.
 
Ok. I think my question was wrong. On my report myId is a
group, and myName is detail field name. Now a new myId is
printed on a new page. In this myId group if myName="Test"
I need to start new page but it does not mean I print each
of these to a new page. Also if myName<>"Test" then I need
to start another page too.
Thanks,
Jim.
-----Original Message-----
Ok. It seems I can do that in detail section too. I am
taking back my previous question. However for next values
I need to remove page break, how should I do that?
Thanks,
Jim.
-----Original Message-----
On Fri, 9 Apr 2004 07:20:04 -0700, JIM.H. wrote:

Thanks Fred,
Is says can not find macro: myPageBreak.Visible =
[myFiled] = "Test"
What that might be?
Also can I put a page break on the filed wich is not a
grouped field?
Thanks,
Jim.
-----Original Message-----
On Thu, 8 Apr 2004 19:30:14 -0700, JIM.H. wrote:

how can you put page break based on a value of the
group
in the report? I do not want to put page break for each
value in the group, only for some certain values.

This was my reply from the Queries newsgroup:

Add a page break control to the top of the Group Header.
Code the Group Header Format event:
PageBreakName.Visible = [LastName] = "Jones"

Of course you'll use the correct name of the page break and the
correct group Field and criteria.

The Message you are getting leads me to believe you
Click to expand...
wrote
the above
code on the Event line, not in the event code window.

Start again.
On the GroupHeader Format event line, write:
[Event Procedure]
Then click on the button with the 3 dots that will
Click to expand...
appear
on that
line.
When the event code window opens there will be 2
Click to expand...
already
existing
lines of code.
BETWEEN those 2 lines, write:
myPageBreak.Visible = [myFiled] = "Test"

Exit the code window.
Run the report.

I'm assuming the actual name of the Page Break is 'myPageBreak', the
actual name of the field in Group Header is 'myFiled'
Click to expand...
(is
that exactly
how you spelled it?) and that the criteria is 'Test'.

You can place a page break in any section of your report.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
Click to expand...

There is nothing to remove.
The page break can sit there but won't have any effect unless the
criteria is met.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top