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
|
|||
|
|||
Report format - Access 07
I would like to copy the exact format of a report that I had created earlier
but with a different set of data (another query as data source). How do I do this? This would save me a lot of time involved in formatting the columns, rows, fonts, colors, etc. once again. Please advise. Thanks, Bob |
#2
|
|||
|
|||
Report format - Access 07
1. While the report is NOT open, select it in the Navigation Pane, copy
(Ctrl+C), and paste (Ctrl+V.) Access will ask what name to give the new copy. 2. Open the new report in design view, and set its RecordSource property. That's the first property on the Data tab of the Properties sheet, when looking at the properties of the report (not those of a text box.) There may be a way to filter the report without having to duplicate it and create lots of queries. Here's an example where you can filter the report to a specific date range: http://allenbrowne.com/casu-08.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. "Bob76" wrote in message ... I would like to copy the exact format of a report that I had created earlier but with a different set of data (another query as data source). How do I do this? This would save me a lot of time involved in formatting the columns, rows, fonts, colors, etc. once again. Please advise. Thanks, Bob |
#3
|
|||
|
|||
Report format - Access 07
Just copy the report and give it a new name. Then open the report in Design
and bring up the report properties. You can then change the Record Source to whatever new set of data you want (table, query, sql statement, etc.). Then go to the report and if the fields of the new record source is different, bring up the properties of each data field on the report and change it the new data field. Capeesh? Drew Bob76 wrote: I would like to copy the exact format of a report that I had created earlier but with a different set of data (another query as data source). How do I do this? This would save me a lot of time involved in formatting the columns, rows, fonts, colors, etc. once again. Please advise. Thanks, Bob |
#4
|
|||
|
|||
Report format - Access 07
Allen,
I did it!!! Thanks so much... You've helped me quite a few times already. I have another question (tho' this might be an irrelevant and silly question). Is there a way of having the Report Header print on top of every page of a report (top of the page header)? If not, that's okay... I did check a lot of Access books and often times can't find the solution to some basic database problems... This Discussion Group is a Godsend.. Appreciate your help.. Bob "Allen Browne" wrote: 1. While the report is NOT open, select it in the Navigation Pane, copy (Ctrl+C), and paste (Ctrl+V.) Access will ask what name to give the new copy. 2. Open the new report in design view, and set its RecordSource property. That's the first property on the Data tab of the Properties sheet, when looking at the properties of the report (not those of a text box.) There may be a way to filter the report without having to duplicate it and create lots of queries. Here's an example where you can filter the report to a specific date range: http://allenbrowne.com/casu-08.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. "Bob76" wrote in message ... I would like to copy the exact format of a report that I had created earlier but with a different set of data (another query as data source). How do I do this? This would save me a lot of time involved in formatting the columns, rows, fonts, colors, etc. once again. Please advise. Thanks, Bob |
#5
|
|||
|
|||
Report format - Access 07
"Bob76" wrote in message
... Allen, I did it!!! Thanks so much... You've helped me quite a few times already. I have another question (tho' this might be an irrelevant and silly question). Is there a way of having the Report Header print on top of every page of a report (top of the page header)? Try using the Page Header instead of the Report Header. -- 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. |
Thread Tools | |
Display Modes | |
|
|