Home
What is MS Access
Forms
Queries
Reports
VBA Codes
Learn VBA
Access 2007/10
Access 97
Tips via email
Whats New!
Contact Me
Questions Answered
Tables

[?] Subscribe To This Site

XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines



Printing a Report of the Relationships

You may wonder where I get my tips from. No science involved - I just jot down ideas as they occur to me or by someone asking me a question or, if I am lucky enough, by someone showing me something new. The latter is where the tip comes from this week. I did not know this functionality existed in Access XP (I am not sure about earlier versions). This function is very handy as it builds a report based on your relationships.

To do this:

Open the relationships window;

On the menu bar click on ‘File’, then ‘Print Relationships’

A Microsoft Access report will be developed based on, and looking exactly like, your relationships window.

You can switch to Design view if you wish to move things around a little bit. This is great if you wish to study the design of your database or share it with somebody else.

Previously you had to do a screen dump to achieve this same outcome.

 

Do you like this tip? Subscribe to my weekly Newsletter to receive tips weekly via email. Click Here to subscribe.