Print multiple copies and change id to make each page unique

  • Thread starter Thread starter Brian K. Sheperd
  • Start date Start date
B

Brian K. Sheperd

Hello,
I am trying to replace our debit memo form with access 2000. I have 2
tables (1 -- cust and other info, 2 -- items being returned -- 1 to many
rel). I have the form and report done. The report is generated by a query.
At the bottom of the report is a page designation (i.e., 1 page goes via
mail, 1 page goes to accounting, 1 page goes to warehouse, etc). These are
in 5 text boxes on the bottom of the report. I want to be able to click on
a print button on the form, and print 5 copies; however, for each copy, I
want to be able to change the font height and boldness for the different
areas (i.e., mail, accounting, warehouse, etc.) so that the user knows which
copy goes to which department. I put a print button on the form, and I
could add a loop, such as for next, to print 5 copies, but I don't know how
to modify the report for the different dept designations. Is this possible?

Also, my query has "[Debit Memo No]" in the criteria. How can I make it
only select the current information displayed on the form instead of an
input box asking me to key in the debit memo number (autonumber).

Thanks,
Brian
 
To create a copy of the report for each department:
1. Create a table with these fields:
DepartmentID Number primary key.
DepartmentName Text
Save it with the name tblDepartment.

2. Enter 5 records into the table for your departments.

3. Open in design view the query that feeds data to your report. Add
tblDepartment. If you see any lines between this table and other tables,
delete the lines. It is the *lack* of any join that causes the query to
repeat the records for all the departments. Drag the 2 fields from the new
table into the output grid. Save the query.

4. Open your report in design view. Open the Sorting'n'Grouping dialog (View
menu), and insert DepartmentID into the first row of the dialog (above any
other entries). Add a group header if you wish to display the department
name above each copy of the report.

5. Use conditional formatting to modify the size/boldness of the things you
chose, depending on the value of DepartmentID.

For instructions on how to only print the record in the form, see:
Print the record in the form
at:
http://members.iinet.net.au/~allenbrowne/casu-15.html
 
Allen,
So far that worked great.... thanks. Can I impose a little more help? Can
you provide a basic conditional formating example?
Thanks again,
Brian

Allen Browne said:
To create a copy of the report for each department:
1. Create a table with these fields:
DepartmentID Number primary key.
DepartmentName Text
Save it with the name tblDepartment.

2. Enter 5 records into the table for your departments.

3. Open in design view the query that feeds data to your report. Add
tblDepartment. If you see any lines between this table and other tables,
delete the lines. It is the *lack* of any join that causes the query to
repeat the records for all the departments. Drag the 2 fields from the new
table into the output grid. Save the query.

4. Open your report in design view. Open the Sorting'n'Grouping dialog (View
menu), and insert DepartmentID into the first row of the dialog (above any
other entries). Add a group header if you wish to display the department
name above each copy of the report.

5. Use conditional formatting to modify the size/boldness of the things you
chose, depending on the value of DepartmentID.

For instructions on how to only print the record in the form, see:
Print the record in the form
at:
http://members.iinet.net.au/~allenbrowne/casu-15.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Brian K. Sheperd said:
Hello,
I am trying to replace our debit memo form with access 2000. I have 2
tables (1 -- cust and other info, 2 -- items being returned -- 1 to many
rel). I have the form and report done. The report is generated by a
query.
At the bottom of the report is a page designation (i.e., 1 page goes via
mail, 1 page goes to accounting, 1 page goes to warehouse, etc). These
are
in 5 text boxes on the bottom of the report. I want to be able to click
on
a print button on the form, and print 5 copies; however, for each copy, I
want to be able to change the font height and boldness for the different
areas (i.e., mail, accounting, warehouse, etc.) so that the user knows
which
copy goes to which department. I put a print button on the form, and I
could add a loop, such as for next, to print 5 copies, but I don't know
how
to modify the report for the different dept designations. Is this
possible?

Also, my query has "[Debit Memo No]" in the criteria. How can I make it
only select the current information displayed on the form instead of an
input box asking me to key in the debit memo number (autonumber).

Thanks,
Brian
Click to expand...
Click to expand...
 
To make a text box bold if DepartmentID is number 2:

1. Select the box to become bold.

2. Choose Conditional Formatting on the Format menu

3. Set Conditoin 1 to:
Expression Is [DepartmentID] = 2
and click the B(old) icon.

Conditional Formatting is available in Access 2000 and later.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Brian K. Sheperd said:
Allen,
So far that worked great.... thanks. Can I impose a little more help?
Can
you provide a basic conditional formating example?
Thanks again,
Brian

Allen Browne said:
To create a copy of the report for each department:
1. Create a table with these fields:
DepartmentID Number primary key.
DepartmentName Text
Save it with the name tblDepartment.

2. Enter 5 records into the table for your departments.

3. Open in design view the query that feeds data to your report. Add
tblDepartment. If you see any lines between this table and other tables,
delete the lines. It is the *lack* of any join that causes the query to
repeat the records for all the departments. Drag the 2 fields from the
new
table into the output grid. Save the query.

4. Open your report in design view. Open the Sorting'n'Grouping dialog (View
menu), and insert DepartmentID into the first row of the dialog (above
any
other entries). Add a group header if you wish to display the department
name above each copy of the report.

5. Use conditional formatting to modify the size/boldness of the things you
chose, depending on the value of DepartmentID.

For instructions on how to only print the record in the form, see:
Print the record in the form
at:
http://members.iinet.net.au/~allenbrowne/casu-15.html


Brian K. Sheperd said:
Hello,
I am trying to replace our debit memo form with access 2000. I have 2
tables (1 -- cust and other info, 2 -- items being returned -- 1 to
many
rel). I have the form and report done. The report is generated by a
query.
At the bottom of the report is a page designation (i.e., 1 page goes
via
mail, 1 page goes to accounting, 1 page goes to warehouse, etc). These
are
in 5 text boxes on the bottom of the report. I want to be able to
click
on
a print button on the form, and print 5 copies; however, for each copy, I
want to be able to change the font height and boldness for the
different
areas (i.e., mail, accounting, warehouse, etc.) so that the user knows
which
copy goes to which department. I put a print button on the form, and I
could add a loop, such as for next, to print 5 copies, but I don't know
how
to modify the report for the different dept designations. Is this
possible?

Also, my query has "[Debit Memo No]" in the criteria. How can I make
it
only select the current information displayed on the form instead of an
input box asking me to key in the debit memo number (autonumber).

Thanks,
Brian
Click to expand...
Click to expand...
Click to expand...
 
Allen,
Thank you very much. Works like a charm.
Thanks again,
Brian


Allen Browne said:
To make a text box bold if DepartmentID is number 2:

1. Select the box to become bold.

2. Choose Conditional Formatting on the Format menu

3. Set Conditoin 1 to:
Expression Is [DepartmentID] = 2
and click the B(old) icon.

Conditional Formatting is available in Access 2000 and later.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Brian K. Sheperd said:
Allen,
So far that worked great.... thanks. Can I impose a little more help?
Can
you provide a basic conditional formating example?
Thanks again,
Brian

Allen Browne said:
To create a copy of the report for each department:
1. Create a table with these fields:
DepartmentID Number primary key.
DepartmentName Text
Save it with the name tblDepartment.

2. Enter 5 records into the table for your departments.

3. Open in design view the query that feeds data to your report. Add
tblDepartment. If you see any lines between this table and other tables,
delete the lines. It is the *lack* of any join that causes the query to
repeat the records for all the departments. Drag the 2 fields from the
new
table into the output grid. Save the query.

4. Open your report in design view. Open the Sorting'n'Grouping dialog (View
menu), and insert DepartmentID into the first row of the dialog (above
any
other entries). Add a group header if you wish to display the department
name above each copy of the report.

5. Use conditional formatting to modify the size/boldness of the things you
chose, depending on the value of DepartmentID.

For instructions on how to only print the record in the form, see:
Print the record in the form
at:
http://members.iinet.net.au/~allenbrowne/casu-15.html


Hello,
I am trying to replace our debit memo form with access 2000. I have 2
tables (1 -- cust and other info, 2 -- items being returned -- 1 to
many
rel). I have the form and report done. The report is generated by a
query.
At the bottom of the report is a page designation (i.e., 1 page goes
via
mail, 1 page goes to accounting, 1 page goes to warehouse, etc). These
are
in 5 text boxes on the bottom of the report. I want to be able to
click
on
a print button on the form, and print 5 copies; however, for each
Click to expand...
copy,
I
want to be able to change the font height and boldness for the
different
areas (i.e., mail, accounting, warehouse, etc.) so that the user knows
which
copy goes to which department. I put a print button on the form, and I
could add a loop, such as for next, to print 5 copies, but I don't know
how
to modify the report for the different dept designations. Is this
possible?

Also, my query has "[Debit Memo No]" in the criteria. How can I make
it
only select the current information displayed on the form instead of an
input box asking me to key in the debit memo number (autonumber).

Thanks,
Brian
Click to expand...
Click to expand...
Click to expand...
 
Back
Top