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
|
|||
|
|||
Print multiple copies and change id to make each page unique
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 |
#2
|
|||
|
|||
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. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Brian K. Sheperd" wrote in message ... 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 |
#3
|
|||
|
|||
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" wrote in message ... 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. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Brian K. Sheperd" wrote in message ... 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 |
#4
|
|||
|
|||
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. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Brian K. Sheperd" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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 |
#5
|
|||
|
|||
Allen,
Thank you very much. Works like a charm. Thanks again, Brian "Allen Browne" wrote in message ... 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. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Brian K. Sheperd" wrote in message ... 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" wrote in message ... 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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Page Layout for 4.25" X 5.5" Booklet-- How to Make Easy to Collate | Bo_Jack | Page Layout | 12 | January 3rd, 2005 11:17 PM |
Printing Multiple Copies | Gail Zuro | Powerpoint | 2 | September 22nd, 2004 07:11 PM |
How do I change data in one cell so other copies& vice versa | sedain | New Users | 3 | September 8th, 2004 10:07 PM |
Changing default Print copies | Pach | General Discussion | 1 | September 6th, 2004 04:58 PM |