use existing report as a template for new Access 2007 reports

[GarryB]

Access Options - Object Designers implies you can name a saved report as a
template for new report creations in Access 2007. Saved a report (no control
source) with logo and page headings and page footers etc. I made the change
in Object Designers but new reports dont seem to use it as a template. Any
suggestions?

 

[Golfinray]

Go to tools/options/form&reports and set the form or report as the template.
Then NEW reports will follow the layout of the template. Old forms or reports
will not.

 

[GarryB]

No such options in Access 2007 as "Tools/Options ...". However I have
discovered something further ... I went back to my template report and did
something differently with it. I amended the (blank) details section to a RED
background and saved it. Now when I create a new report I can see it is using
the template after all. I thought it was not using it but it is! However !!!
- In my template I wanted to have a series of standard controls coming
through into new Access 2007 report creations - such as the company logo in
the page header and certain date / time / page count fields in the page
footer. They are set up in my template but they don't come through into new
report creations. Annoying really, I am going to have to set them up with
each new report - unless anybody can tell me how to resolve this. The
"Template" issue is answered as such - it does work, but with considerable
dissappointment.

 

[Larry Linson]

You are correct. Reports do not inherit either pictures or pre-existing
fields from the template... they inherit properties, and if you have set
properties for Controls, those will be used when you create a new Control of
that type.

To solve the problem for the logo (picture) and pre-existing text, do not
create a new report, but copy the template report and modify it to create
the new report.

No such options in Access 2007 as "Tools/Options ...".

The corresponding funtion/selections are available, but the user interface
was drastically changed for Access 2007, so you will have to search and find
where you specify those options. I don't have a copy of Access 2007 on this
computer, so can't go look and tell you. You might start with the nice
round "Office Button"... some menu items that are not "view-specific" were
moved there.

There's no database window, either, but the navigation pane (sometimes, not
so fondly, called "navigation pain") actually does allow you to get to every
object in your database, just not the same way that you are used to.

Larry Linson
Microsoft Office Access MVP