Multiprints

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

Hi everyone



I have a report and I have to print it three times. This report as a field
name wich I called [via] and I want that each time this report prints the
field via will take three different specific values, for example, [VIA]="via
1", VIA="via 2", VIA= "via 3". I tried to do this with multiple
docmd.openreport lines filling the where condition with the values I want
the field [VIA] assume but it didn't work. Can any one help me.



Tks in advance

Andy
 
I would try create a table
tblVIA
==========
1 VIA 1
2 VIA 2
3 VIA 3
You can add this table to your reports record source without any join lines.
This creates three copies of each record with differing VIA values. Set one
of your sorting level to the VIA description field. You can add the VIA
description to the report.
 
Tks Duane that is the solution I found and it works just fine however it
doesn't seem to me a very nice way to do it. Isn't there some other way to
do this programmatically without create a new table?



Tks in advance

Andy



Duane Hookom said:
I would try create a table
tblVIA
==========
1 VIA 1
2 VIA 2
3 VIA 3
You can add this table to your reports record source without any join lines.
This creates three copies of each record with differing VIA values. Set one
of your sorting level to the VIA description field. You can add the VIA
description to the report.
--
Duane Hookom
MS Access MVP


Andy said:
Hi everyone



I have a report and I have to print it three times. This report as a field
name wich I called [via] and I want that each time this report prints the
field via will take three different specific values, for example, [VIA]="via
1", VIA="via 2", VIA= "via 3". I tried to do this with multiple
docmd.openreport lines filling the where condition with the values I want
the field [VIA] assume but it didn't work. Can any one help me.



Tks in advance

Andy
Click to expand...
Click to expand...
 
There is always many methods of getting at the same result but I don't spend
valuable time finding a different one when a simple solution that works has
been found. Maybe someone else has more time.

--
Duane Hookom
Microsoft Access MVP


Andy said:
Tks Duane that is the solution I found and it works just fine however it
doesn't seem to me a very nice way to do it. Isn't there some other way to
do this programmatically without create a new table?



Tks in advance

Andy



Duane Hookom said:
I would try create a table
tblVIA
==========
1 VIA 1
2 VIA 2
3 VIA 3
You can add this table to your reports record source without any join lines.
This creates three copies of each record with differing VIA values. Set one
of your sorting level to the VIA description field. You can add the VIA
description to the report.
--
Duane Hookom
MS Access MVP


Andy said:
Hi everyone



I have a report and I have to print it three times. This report as a field
name wich I called [via] and I want that each time this report prints the
field via will take three different specific values, for example, [VIA]="via
1", VIA="via 2", VIA= "via 3". I tried to do this with multiple
docmd.openreport lines filling the where condition with the values I want
the field [VIA] assume but it didn't work. Can any one help me.



Tks in advance

Andy
Click to expand...
Click to expand...
Click to expand...
 
Back
Top