Access Reports

[Dee]

Hi,

I have an access report based on two tables. After much
painful deliberation with my boss, we were able to set up
a format that we like and would like to use it as a
template for all other reports. So far, the only way I
have been able to accomplish this is by Saving the Report
with a different name and then changing the Control
Source to the new table. Is there an easier and more
portable way of doing this? Help!!!!


Thanks!

 

[Ken Snell [MVP]]

Which version of ACCESS? How are you opening the report (from a form? from
the database window?)?

 

[david epsom dot com dot au]

If you want to use the report as a template for all
new reports, then go to the menu Tools, Options,
Forms/Report, and set the template value. (The menu's
may be different in your version of Access).

Or do you want to just use the same report for two
different tables?

(david)

 

[Dee]

Its Access 2000 and I am opening it from the Database
window.

 

[Ken Snell [MVP]]

david epsom's idea elsethread may be the better approach for you to take
right now, then.

It's possible to have a report ask you what to use as the record source when
it opens, but it sounds as if you want to know how to make things easier for
creating new reports, not opening existing reports.

 

[Dee]

Hi Ken:

I'd love to know how I can get a report to prompt me as
to which table/Query I need to use as a Record Source.
How can I do that? My preference would be to dynamically
populate the list of tables from the existing database
into a list box and fire an on-change event. This way I
can keep user errors to a minimum....

When I tried specifying the report template in
Tools/Options, it did not work (in what I wanted it to
do - it creates a generic report)

Thanks for all your help

 

[Guest]

Hi David:

Thanks for your suggestion. But for some reason, Access
is bent on creating a generic report for me....
It does not use the one I specified in Tools/Options

 

[Ken Snell [MVP]]

Are the names of the fields the same in all tables? I assume that you're
using bound controls in the report for various fields that are in the
report's RecordSource?