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
|
|||
|
|||
Suppress Report Footer
I have three footers in my report:
COM_VAD PROCESS LABEL_TYPE PROCESS is either canned or frozen. COM_VAD is either commodity or value-added. Frozen can be either commodity or value-added; canned will only be commodity. How can I suppress the PROCESS footer if the process is canned? Thank you in advance! Karen |
#2
|
|||
|
|||
Suppress Report Footer
On Fri, 26 Oct 2007 14:58:02 -0700, frpkaren wrote:
I have three footers in my report: COM_VAD PROCESS LABEL_TYPE PROCESS is either canned or frozen. COM_VAD is either commodity or value-added. Frozen can be either commodity or value-added; canned will only be commodity. How can I suppress the PROCESS footer if the process is canned? Thank you in advance! Karen Code the Process Footer Format event: Cancel = Me![ControlName] = "Canned" Where the (X) is the Group header's section number, i.e. the Report Header is section(1), the PageFooter is section(4), etc. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
Suppress Report Footer
You kind of lost me. I tried typing in the Cancel = Me![PROCESS] = "Canned"
assuming the [ControlName] is the field called Process. It comes back and says it can't find the field. Not sure what you mean by "where the (x) is the...." The Process Group Footer shows as GroupFooter0. Event procedures are new to me. "fredg" wrote: On Fri, 26 Oct 2007 14:58:02 -0700, frpkaren wrote: I have three footers in my report: COM_VAD PROCESS LABEL_TYPE PROCESS is either canned or frozen. COM_VAD is either commodity or value-added. Frozen can be either commodity or value-added; canned will only be commodity. How can I suppress the PROCESS footer if the process is canned? Thank you in advance! Karen Code the Process Footer Format event: Cancel = Me![ControlName] = "Canned" Where the (X) is the Group header's section number, i.e. the Report Header is section(1), the PageFooter is section(4), etc. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#4
|
|||
|
|||
Suppress Report Footer
On Tue, 30 Oct 2007 12:39:00 -0700, frpkaren wrote:
You kind of lost me. I tried typing in the Cancel = Me![PROCESS] = "Canned" assuming the [ControlName] is the field called Process. It comes back and says it can't find the field. Not sure what you mean by "where the (x) is the...." The Process Group Footer shows as GroupFooter0. Event procedures are new to me. "fredg" wrote: On Fri, 26 Oct 2007 14:58:02 -0700, frpkaren wrote: I have three footers in my report: COM_VAD PROCESS LABEL_TYPE PROCESS is either canned or frozen. COM_VAD is either commodity or value-added. Frozen can be either commodity or value-added; canned will only be commodity. How can I suppress the PROCESS footer if the process is canned? Thank you in advance! Karen Code the Process Footer Format event: Cancel = Me![ControlName] = "Canned" Where the (X) is the Group header's section number, i.e. the Report Header is section(1), the PageFooter is section(4), etc. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail 1) [Process] is the name of your table field that stores "Canned" or "SomeOtherValue" The name of the control in the report may or may not be "Process". You need to refer the actual name of the control in the Process Group Header that displays the value "Canned". Look at it's property sheet on the Other tab. 2) Is [Process] a text datatype field, or is it a LookUp field. Look in table design view. If the datatype of the Process field is Text, fine. If, however, it is Number, look at the LookUp tab in the lower panel. It will say Combo Box. You are using that infamous lookup field, which stores a Number value but displays text. You can most likely substitute the "Canned" number value: Cancel = Me.[Process] = 3 Where 3 is whatever the actual value is. You'll need to look it up in whatever table you are storing the Process values. Once again, make sure that [Process] is the actual name of the control. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#5
|
|||
|
|||
Suppress Report Footer
THANK YOU! I ended up adding a text box to the footer for the field Process;
inserted the control name of the new text box in the Event Procedure and everything works fine. Set the property on the new text box to not visible because I really don't need it to show. You're a life saver! "fredg" wrote: On Tue, 30 Oct 2007 12:39:00 -0700, frpkaren wrote: You kind of lost me. I tried typing in the Cancel = Me![PROCESS] = "Canned" assuming the [ControlName] is the field called Process. It comes back and says it can't find the field. Not sure what you mean by "where the (x) is the...." The Process Group Footer shows as GroupFooter0. Event procedures are new to me. "fredg" wrote: On Fri, 26 Oct 2007 14:58:02 -0700, frpkaren wrote: I have three footers in my report: COM_VAD PROCESS LABEL_TYPE PROCESS is either canned or frozen. COM_VAD is either commodity or value-added. Frozen can be either commodity or value-added; canned will only be commodity. How can I suppress the PROCESS footer if the process is canned? Thank you in advance! Karen Code the Process Footer Format event: Cancel = Me![ControlName] = "Canned" Where the (X) is the Group header's section number, i.e. the Report Header is section(1), the PageFooter is section(4), etc. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail 1) [Process] is the name of your table field that stores "Canned" or "SomeOtherValue" The name of the control in the report may or may not be "Process". You need to refer the actual name of the control in the Process Group Header that displays the value "Canned". Look at it's property sheet on the Other tab. 2) Is [Process] a text datatype field, or is it a LookUp field. Look in table design view. If the datatype of the Process field is Text, fine. If, however, it is Number, look at the LookUp tab in the lower panel. It will say Combo Box. You are using that infamous lookup field, which stores a Number value but displays text. You can most likely substitute the "Canned" number value: Cancel = Me.[Process] = 3 Where 3 is whatever the actual value is. You'll need to look it up in whatever table you are storing the Process values. Once again, make sure that [Process] is the actual name of the control. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|