Hide footer on page1

[Chris Wagner]

My report header now takes up one page... Report header height is
9.5"... however I get a footer with 'Page 1 of 92'
thinking about it maybe this will be two questions.

First how do I get the first page from printing the footer... and I
think I've figured this part out but how can I get the footers to
start with page one when it is really the second page. and of course
'of 92' would be 'of 91'

thanks
Chris Wagner

 

[Fredg]

Chris,
Code the Page Footer Format event:
Cancel = [Page] = 1

Change the control source of the control that shows the page numbers.
Set the control source to:
= "Page " & [Page] - 1 & " of " & [Pages] -1

 

[Marshall Barton]

My report header now takes up one page... Report header height is
9.5"... however I get a footer with 'Page 1 of 92'
thinking about it maybe this will be two questions.

First how do I get the first page from printing the footer... and I
think I've figured this part out

Use the report's PageHeader/PageFooter properties to control
this.

but how can I get the footers to
start with page one when it is really the second page. and of course
'of 92' would be 'of 91'

You can use the report header's Format event to reset the
page number. What you set it to depends on what else is
going on, try setting it to 0 and see if that does it for
you.

 

[Fredg]

Chris Wagner wrote:

** snipped **

Everything appears to be OK
any way that I closed the window, and I go to preview the
report... I get this message


[Image]
Also I did notice on the bottom of the window it says 'Formatting
page,press Ctrl+Break to stop...


The MDB is on the local drive C:\
Access is installed on the local drive C:\ ..... Local drive C:\
meaning all in the same 'box' on my desk
Click OK on the above window and it goes to


[Image]


Any suggestions


Thanks


Chris Wagner

Chris,
Please do not send 88K messages with Images, unless asked to do so.
There was nothing in the images that you could not have as easily said
with words.
I am not using Outlook Express today and so had to open OE and download
your message a second time to see the Images, as this newsreader did not
rend the images properly.

It looks as though you have entered the code correctly.
I don't know why you are getting the
"Error accessing file. Network connecton lost"
error message.

It may also be you have something else going on.

Or perhaps there was some corruption with all that you were trying to
do.
Delete the event (Click on the event line, then on the 3 dot button.
Delete all 3 lines of the Sub procedure.
Then run the report (without the code) to see if it works properly.
Then add the code again. You know how, now.

By the way, you mentioned trying lots of things to close the code
window.
All you need do is click on the Top Right Corner X (with the red
background).
Or.. Click View + Object.

You might even have to make a new report and try it again.

 

[Fredg]

Chris,
Probably not if you're writing it as
[Union Relationship1].
But the best way to check something like this
is to just change the name.
Anyway it's always best not to use a name with
a space as a field or object name.
UnionRelationship1 is just a readable
and not likely to create a problem if you omit
using the brackets.
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.

Another Idea........
Could it be the use of a reserved word 'Union' in the name of the form
Union Relationship1?

Chris Wagner

Chris Wagner wrote:

** snipped **

Everything appears to be OK
any way that I closed the window, and I go to preview the
report... I get this message


[Image]
Also I did notice on the bottom of the window it says 'Formatting
page,press Ctrl+Break to stop...


The MDB is on the local drive C:\
Access is installed on the local drive C:\ ..... Local drive C:\
meaning all in the same 'box' on my desk
Click OK on the above window and it goes to


[Image]


Any suggestions


Thanks


Chris Wagner

Chris,
Please do not send 88K messages with Images, unless asked to do so.
There was nothing in the images that you could not have as easily said
with words.
I am not using Outlook Express today and so had to open OE and download
your message a second time to see the Images, as this newsreader did not
rend the images properly.

It looks as though you have entered the code correctly.
I don't know why you are getting the
"Error accessing file. Network connecton lost"
error message.

It may also be you have something else going on.

Or perhaps there was some corruption with all that you were trying to
do.
Delete the event (Click on the event line, then on the 3 dot button.
Delete all 3 lines of the Sub procedure.
Then run the report (without the code) to see if it works properly.
Then add the code again. You know how, now.

By the way, you mentioned trying lots of things to close the code
window.
All you need do is click on the Top Right Corner X (with the red
background).
Or.. Click View + Object.

You might even have to make a new report and try it again.

 

[Fredg]

Chris,
Probably not if you're writing it as
[Union Relationship1].

But the best way to check something like this
is to just make a copy of the form, change the name and try it.

Anyway it's always best not to use a name with
a space as a field or object name.
UnionRelationship1 is just a readable
and not likely to create a problem if you omit
using the brackets.
--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.

Another Idea........
Could it be the use of a reserved word 'Union' in the name of the form
Union Relationship1?

Chris Wagner

Chris Wagner wrote:

** snipped **

Everything appears to be OK
any way that I closed the window, and I go to preview the
report... I get this message


[Image]
Also I did notice on the bottom of the window it says 'Formatting
page,press Ctrl+Break to stop...


The MDB is on the local drive C:\
Access is installed on the local drive C:\ ..... Local drive C:\
meaning all in the same 'box' on my desk
Click OK on the above window and it goes to


[Image]


Any suggestions


Thanks


Chris Wagner

Chris,
Please do not send 88K messages with Images, unless asked to do so.
There was nothing in the images that you could not have as easily said
with words.
I am not using Outlook Express today and so had to open OE and download
your message a second time to see the Images, as this newsreader did not
rend the images properly.

It looks as though you have entered the code correctly.
I don't know why you are getting the
"Error accessing file. Network connecton lost"
error message.

It may also be you have something else going on.

Or perhaps there was some corruption with all that you were trying to
do.
Delete the event (Click on the event line, then on the 3 dot button.
Delete all 3 lines of the Sub procedure.
Then run the report (without the code) to see if it works properly.
Then add the code again. You know how, now.

By the way, you mentioned trying lots of things to close the code
window.
All you need do is click on the Top Right Corner X (with the red
background).
Or.. Click View + Object.

You might even have to make a new report and try it again.