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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 01:35 PM |
Print report or page header on each page of a sub-report? | Chris | Setting Up & Running Reports | 1 | November 4th, 2005 03: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 |