Report copies issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello.. Is there some VB code that would allow me to print three copies of a report with each copy having a different text indication printed ("Office Copy", "Shipping Copy", "Purchasing Copy"). I am currently printing the report from a form (command button).
 
You can create a table
tblCopies
CopyNum CopyTitle
1 Office
2 Shipping
3 Purchasing

Then add this table to the record source of your report (no join lines).
Then use the CopyNum as one of the sorting and grouping levels in your
report and you can add a text box bound to CopyTitle.


--
Duane Hookom
MS Access MVP
--

EdS said:
Hello.. Is there some VB code that would allow me to print three copies of
Click to expand...
a report with each copy having a different text indication printed ("Office
Copy", "Shipping Copy", "Purchasing Copy"). I am currently printing the
report from a form (command button).
 
Great idea! I'll try it.
--
Thanks. EdS


Duane Hookom said:
You can create a table
tblCopies
CopyNum CopyTitle
1 Office
2 Shipping
3 Purchasing

Then add this table to the record source of your report (no join lines).
Then use the CopyNum as one of the sorting and grouping levels in your
report and you can add a text box bound to CopyTitle.


--
Duane Hookom
MS Access MVP
--


a report with each copy having a different text indication printed ("Office
Copy", "Shipping Copy", "Purchasing Copy"). I am currently printing the
report from a form (command button).
Click to expand...
 
Duane.. That DOES work. Yet, is it possible (and can you show me the code) to accomplish this in the VB of the form (without having to create a table)?
 
Sure, it's possible to do this with code. I'm not sure why you would want to
go through the trouble to do it that way. I won't go through the effort ;-)
I like the table method.

--
Duane Hookom
MS Access MVP
--

EdS said:
Duane.. That DOES work. Yet, is it possible (and can you show me the
Click to expand...
code) to accomplish this in the VB of the form (without having to create a
table)?
 
OK.. You know best!
--
Thanks. EdS


Duane Hookom said:
Sure, it's possible to do this with code. I'm not sure why you would want to
go through the trouble to do it that way. I won't go through the effort ;-)
I like the table method.

--
Duane Hookom
MS Access MVP
--


code) to accomplish this in the VB of the form (without having to create a
table)?
Click to expand...
 
I'm not sure it is "best" but from experience, it works the best for me. I
generally try to keep things simple and any code solution was looking more
complex.
 
Duane.. I have a wrinkle! The table solution worked fine with one of my report query's, but on another one, when I add the Copies Table to the query, I get the "ambiguous outer joins" message when I try to run it. This query is not really complicated (Customer, address, etc), and is a working query. Any ideas?
 
Back
Top