Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to Create Custom Print Layouts for Different Views?
- Thread starter erichsen
- Start date
A view consists of a table and a filter.
Multiple views can use the same table but alterations to the display of the table in one view are propagated to other views using that table.
Your solution:
For each constant view:
1. Create a table (T1) and select the columns, etc.
2. Create a view (V1) using that table (and a filter, of course)
3. Save the project.
Note: if you user "messes" with the View (adding columns, changing the width, etc.) those changes will be sticky.
If you want more control, you might want to look into putting buttons on a toolbar and have the buttons link to some vba that creates tables and views and then displays them. That way, every time the use clicks on the button, the table is recreated and the column definitions are, effectively constant.
Multiple views can use the same table but alterations to the display of the table in one view are propagated to other views using that table.
Your solution:
For each constant view:
1. Create a table (T1) and select the columns, etc.
2. Create a view (V1) using that table (and a filter, of course)
3. Save the project.
Note: if you user "messes" with the View (adding columns, changing the width, etc.) those changes will be sticky.
If you want more control, you might want to look into putting buttons on a toolbar and have the buttons link to some vba that creates tables and views and then displays them. That way, every time the use clicks on the button, the table is recreated and the column definitions are, effectively constant.
- Status
Similar threads
- Locked
- Question