Tip:
Highlight text to annotate it
X
Hi, I’m Chris Downs, a writer for Microsoft Access.
Most of the Access 2010 web database templates include a Report Center
that provides a great way to browse, preview, and print
the reports that were included with the template.
For example, in the Contacts web database template,
I can click these links to select the report I want to see.
However, if you create a new report of your own,
it is not automatically added to the Report Center.
I’ll show you how to add a report to this list
so that you can run it from here.
I have new report that I just built, and it shows my contacts
grouped by the state or province where they live.
Right now, the only obvious way to run the report
is by using the Navigation Pane.
The report will be a lot more convenient to use if I add it to the Report Center.
So to get this report into the Report Center list, I’ll close the report,
and then on the Home tab, I’ll click Layout View.
If the Property Sheet isn’t already open, click Property Sheet on the Design tab.
I’ll undock the property sheet from the side of the window
so we can see the report links.
If I click one of the existing report links, I can see in the Property Sheet
that each one is actually a Command Button, just formatted to look like a hyperlink.
So I’ll follow that pattern and add a new Command Button to the Select a Report list.
On the Design tab, I click Button, and then I’ll click in the empty cell
where I want the button.
And I’ll edit the caption on my new button to say “Contacts by State.”
Since I’m using the existing buttons as a guide,
I’ll click the Phone Book button and then click the Event tab in the Property Sheet.
Each of these existing buttons contains an embedded macro like this one
that displays the report when the button is clicked.
So I’ll click the Build button, and the macro is displayed.
This looks pretty simple.
I’ll click Expand All so we can see the full macro.
I’m going to copy these macro actions and use them in my new button.
I’ll select all of the actions by pressing CTRL+A,
And then copy them by pressing CTRL+C.
And I’ll close the Macro Builder, without saving changes.
I’ll select my new button, and then in the OnClick event property box,
I’ll click the Build button.
And, I’ll paste in the macro actions by pressing CTRL+V.
Now I need to edit these actions so that
they open my new Contacts by State report,
instead of the Phone Book.
If you’re interested in learning more about the BrowseTo macro action,
there is some good information about it on the Access Blog.
Now I’ll save and close the macro.
And I’ll switch back to Form view, and see how it works.
I’ll click the new button, and there’s my new report!