A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Print to Header, Not Detail



 
 
Thread Tools Display Modes
  #1  
Old November 24th, 2005, 01:47 AM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Print to Header, Not Detail

I'd like to print the first record of a group to the Page or Group header,
but not print that record again in the detail section.

How's it done?
Thanks,
Bernie


  #2  
Old November 24th, 2005, 02:42 AM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Print to Header, Not Detail

Please excuse me, as I'm becoming senile.

I works just like I wanted.
Bernie

"bw" wrote in message
...
I'd like to print the first record of a group to the Page or Group header,
but not print that record again in the detail section.

How's it done?
Thanks,
Bernie



  #3  
Old November 24th, 2005, 02:57 AM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Print to Header, Not Detail

On Wed, 23 Nov 2005 17:47:35 -0700, bw wrote:

I'd like to print the first record of a group to the Page or Group header,
but not print that record again in the detail section.

How's it done?
Thanks,
Bernie


Place your controls in the Page header.

Add an unbound control to the detail section.
Name it Show.
You can make it not visible.

Code the Page Header Format event:
Me![Show] = 1

Code the Detail Format event:
Cancel = Me![Show] = 1
Me![Show] = 2

That should do it for you.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
  #4  
Old November 24th, 2005, 10:12 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Print to Header, Not Detail

Thanks for the reply, Fred
I'm getting an error:
"Microsoft Access can't find the macro 'Me![Show]=1."

I'm not sure were, or how you wanted me to enter your code. I have the
following procedure, which is producing the error:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Cancel = Me![Show] = 1
Me![Show] = 2
End Sub

Can you please explain in further detail?
Thanks,
Bernie


"fredg" wrote in message
.. .
On Wed, 23 Nov 2005 17:47:35 -0700, bw wrote:

I'd like to print the first record of a group to the Page or Group
header,
but not print that record again in the detail section.

How's it done?
Thanks,
Bernie


Place your controls in the Page header.

Add an unbound control to the detail section.
Name it Show.
You can make it not visible.

Code the Page Header Format event:
Me![Show] = 1

Code the Detail Format event:
Cancel = Me![Show] = 1
Me![Show] = 2

That should do it for you.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail



  #5  
Old November 25th, 2005, 06:04 AM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Print to Header, Not Detail

On Thu, 24 Nov 2005 14:12:01 -0700, bw wrote:

Thanks for the reply, Fred
I'm getting an error:
"Microsoft Access can't find the macro 'Me![Show]=1."

I'm not sure were, or how you wanted me to enter your code. I have the
following procedure, which is producing the error:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Cancel = Me![Show] = 1
Me![Show] = 2
End Sub

Can you please explain in further detail?
Thanks,
Bernie

"fredg" wrote in message
.. .
On Wed, 23 Nov 2005 17:47:35 -0700, bw wrote:

I'd like to print the first record of a group to the Page or Group
header,
but not print that record again in the detail section.

How's it done?
Thanks,
Bernie


Place your controls in the Page header.

Add an unbound control to the detail section.
Name it Show.
You can make it not visible.

Code the Page Header Format event:
Me![Show] = 1

Code the Detail Format event:
Cancel = Me![Show] = 1
Me![Show] = 2

That should do it for you.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail


Did you add an unbound control to the Detail section of your report?
Did you name it "Show", as I wrote in my first reply?

Add an unbound control to the detail section.
Name it Show.
You can make it not visible.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
  #6  
Old November 25th, 2005, 10:38 AM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Print to Header, Not Detail


"fredg" wrote in message
...
On Thu, 24 Nov 2005 14:12:01 -0700, bw wrote:

Thanks for the reply, Fred
I'm getting an error:
"Microsoft Access can't find the macro 'Me![Show]=1."

I'm not sure were, or how you wanted me to enter your code. I have the
following procedure, which is producing the error:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Cancel = Me![Show] = 1
Me![Show] = 2
End Sub

Can you please explain in further detail?
Thanks,
Bernie

"fredg" wrote in message
.. .
On Wed, 23 Nov 2005 17:47:35 -0700, bw wrote:

I'd like to print the first record of a group to the Page or Group
header,
but not print that record again in the detail section.

How's it done?
Thanks,
Bernie

Place your controls in the Page header.

Add an unbound control to the detail section.
Name it Show.
You can make it not visible.

Code the Page Header Format event:
Me![Show] = 1

Code the Detail Format event:
Cancel = Me![Show] = 1
Me![Show] = 2

That should do it for you.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail


Did you add an unbound control to the Detail section of your report?
Did you name it "Show", as I wrote in my first reply?

Add an unbound control to the detail section.
Name it Show.
You can make it not visible.

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


Yes sir, I did.
Specifics of that control a
Name=Show
Control Source= empty
Visible=No
It is located in the Detail Section.

I could be missing something that is obvious, so don't be afraid to let me
know.
Bernie


  #7  
Old November 25th, 2005, 06:44 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Print to Header, Not Detail

On Fri, 25 Nov 2005 02:38:52 -0700, bw wrote:

"fredg" wrote in message
...
On Thu, 24 Nov 2005 14:12:01 -0700, bw wrote:

Thanks for the reply, Fred
I'm getting an error:
"Microsoft Access can't find the macro 'Me![Show]=1."

I'm not sure were, or how you wanted me to enter your code. I have the
following procedure, which is producing the error:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Cancel = Me![Show] = 1
Me![Show] = 2
End Sub

Can you please explain in further detail?
Thanks,
Bernie

"fredg" wrote in message
.. .
On Wed, 23 Nov 2005 17:47:35 -0700, bw wrote:

I'd like to print the first record of a group to the Page or Group
header,
but not print that record again in the detail section.

How's it done?
Thanks,
Bernie

Place your controls in the Page header.

Add an unbound control to the detail section.
Name it Show.
You can make it not visible.

Code the Page Header Format event:
Me![Show] = 1

Code the Detail Format event:
Cancel = Me![Show] = 1
Me![Show] = 2

That should do it for you.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail


Did you add an unbound control to the Detail section of your report?
Did you name it "Show", as I wrote in my first reply?

Add an unbound control to the detail section.
Name it Show.
You can make it not visible.

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


Yes sir, I did.
Specifics of that control a
Name=Show
Control Source= empty
Visible=No
It is located in the Detail Section.

I could be missing something that is obvious, so don't be afraid to let me
know.
Bernie



Are you sure it's the Detail Format code and not the Page Header
format code causing that error?

Did you write the
Me![Show]=1
in the code window or directly on the Page Header On Format event
line?
It belongs in the code not on the line, i.e. the On Format event line
should read [Event Procedure].

The actual Page Format event code should read:

Private Sub PageHeader_Format(Cancel As Integer, FormatCount As
Integer)
Me!Show = 1
End Sub

Other than that, I have no idea why you're getting that error message.
My test report works fine.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
  #8  
Old November 25th, 2005, 07:16 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default Print to Header, Not Detail

Fred,
It works now. Thanks much for your help.
Bernie


"fredg" wrote in message
...
On Fri, 25 Nov 2005 02:38:52 -0700, bw wrote:

"fredg" wrote in message
...
On Thu, 24 Nov 2005 14:12:01 -0700, bw wrote:

Thanks for the reply, Fred
I'm getting an error:
"Microsoft Access can't find the macro 'Me![Show]=1."

I'm not sure were, or how you wanted me to enter your code. I have the
following procedure, which is producing the error:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Cancel = Me![Show] = 1
Me![Show] = 2
End Sub

Can you please explain in further detail?
Thanks,
Bernie

"fredg" wrote in message
.. .
On Wed, 23 Nov 2005 17:47:35 -0700, bw wrote:

I'd like to print the first record of a group to the Page or Group
header,
but not print that record again in the detail section.

How's it done?
Thanks,
Bernie

Place your controls in the Page header.

Add an unbound control to the detail section.
Name it Show.
You can make it not visible.

Code the Page Header Format event:
Me![Show] = 1

Code the Detail Format event:
Cancel = Me![Show] = 1
Me![Show] = 2

That should do it for you.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Did you add an unbound control to the Detail section of your report?
Did you name it "Show", as I wrote in my first reply?

Add an unbound control to the detail section.
Name it Show.
You can make it not visible.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail


Yes sir, I did.
Specifics of that control a
Name=Show
Control Source= empty
Visible=No
It is located in the Detail Section.

I could be missing something that is obvious, so don't be afraid to let
me
know.
Bernie



Are you sure it's the Detail Format code and not the Page Header
format code causing that error?

Did you write the
Me![Show]=1
in the code window or directly on the Page Header On Format event
line?
It belongs in the code not on the line, i.e. the On Format event line
should read [Event Procedure].

The actual Page Format event code should read:

Private Sub PageHeader_Format(Cancel As Integer, FormatCount As
Integer)
Me!Show = 1
End Sub

Other than that, I have no idea why you're getting that error message.
My test report works fine.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
I cant get my report to fit on one page rmoritzky Setting Up & Running Reports 16 February 10th, 2009 02:35 PM
Print report or page header on each page of a sub-report? Chris Setting Up & Running Reports 1 November 4th, 2005 04:32 PM
Only display page header if Detail session has data Tran Hong Quang Setting Up & Running Reports 5 October 25th, 2005 01:37 AM
How do I print the attachment data in header - not entire attachm. Chris, Syracuse NY General Discussion 1 October 2nd, 2004 08:21 AM
How do I print the details view David Running & Setting Up Queries 5 August 28th, 2004 12:17 AM


All times are GMT +1. The time now is 04:49 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.