Selecting Image(s) to print in a Group Footer

[David]

Hi,

I am trying to do the following, but am running into limitations with my
approach. Has anybody done this before?

1. I am printing a letter, and depending on certain check boxes being
selected, I will be printing between 0 and 3 forms to go along with the
letter.
2. I have an Image control in group footer section, which is linked to page
1 of one of the images.
3. I have a second Image control in the group footer section, which is
linked to page 2 of the same image.

Issues:
1. When I try and move the 2nd image down below the first, Access tells me
"the control or subform is too large for this location". Therefore, page 2
overwrites part of page 1.

2. I have 2 more forms, 2 pages each to get onto this report. Again, no
room to do so.

3. Some of the forms will need to print double sided, meaning, I will have
to print the entire job as duplex, and insert blank pages between those forms
which are not to be duplexed. Any ideas on a "smart" way to do this, pending
the successful resolution of #1 and #2 above?

Thanks.

 

[trigirl]

Hi,

I am trying to do the following, but am running into limitations with my
approach. Has anybody done this before?

1. I am printing a letter, and depending on certain check boxes being
selected, I will be printing between 0 and 3 forms to go along with the
letter.
2. I have an Image control in group footer section, which is linked to page
1 of one of the images.
3. I have a second Image control in the group footer section, which is
linked to page 2 of the same image.

Issues:
1. When I try and move the 2nd image down below the first, Access tells me
"the control or subform is too large for this location". Therefore, page 2
overwrites part of page 1.

2. I have 2 more forms, 2 pages each to get onto this report. Again, no
room to do so.

3. Some of the forms will need to print double sided, meaning, I will have
to print the entire job as duplex, and insert blank pages between those forms
which are not to be duplexed. Any ideas on a "smart" way to do this, pending
the successful resolution of #1 and #2 above?

Thanks.

 

[David]

I think I've resolved this myself:

Use a subreport, 1 for each image file. Make the subreport VISIBLE or NOT
VISIBIBLE, depending on which FORM/IMAGE you want to report. I also am using
page breaks, making them visible/non-visible as needed.