Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Mar 2002
    Location
    St Albans, Hertfordshire, England
    Posts
    48
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Controling the Relationships window using VBA (Access 2000/SR1)

    Hi folks - Firstly, thanks to all of you who provided insights into my last Relationships question (Charlotte, I went with a similar idea to your own - thanks for that! <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30> )

    I would like to manipulate the relationships window using VBA - i.e. show and hide relationships automatically, and then use the print relationships option to create snapshots of each of my data hierarchies

    To help, I have about 220 tables, each table belonging to 1 of 8 hierarcical areas, so I can control the displayed tables using this list

    Long shot, I know, but does anybody have any suggestions?

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Controling the Relationships window using VBA (Access 2000/SR1)

    It would be far more work to figure out how to do it programmatically than it would to do it manually when you want to print the things. If you want to do this in order to document that database, look into a product like Visio or the far cheaper DeZign For Databases.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •