To copy design properties

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

Guest

How can I copy design properties of a report to other reports. They have same
fields but gets values from different queries. I don't want to create the
reports one by one.
Thanks.
 
After creating the first report, you can copy it in the database window, and
paste it back. Then open it in design view, and change the report's
RecordSource property to the query you want.

If might be more efficient to use a WhereCondition to open the one report
with different criteria. For an example, see:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html
 
Thanks for the link to the article about limiting a report to a date range.
How can I copy a report design to another database? The databases are
identical, save for the individual records.
 
Just open the target DB and click on File/Get External Data/Import.
Access will show a File Open dialog. You browse to the DB file where the
report is, click the Import button and you will get a dialog where you can
select the report and clik OK.

Ragnar
 
Back
Top