Results 1 to 9 of 9
  1. #1
    Join Date
    Apr 2006
    Posts
    157

    Unanswered: best way to paste database relationship to word document

    hi guys,

    pretty dumb question here, if you could spare a moment :

    i just wondered what's the best way that i can paste the database relationship in access to a word document...

    thanks.
    Only quitters quit!

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    um, using copy/paste?

    sorry, i guess i don't understand why you're having a problem

    you can copy the diagram with Alt-PrtScrn

    but why paste it to Word? that app is so tres bloated

    i always paste my diagrams into Paint, then save as a .gif

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Apr 2006
    Posts
    157
    for documentation purposes actually, but i wanted it at its best resolution and best fit in the easiest possible way, i tried inserting the snapshot as an object but couldn't resize...
    Only quitters quit!

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    There's two ways:

    1. Hit PrintScreen when looking at the Relationship diagram, then go to Word (or your graphics package) and then Paste.

    2. Use the Print Relationships Wizard (which sucks big-time). Some version of Access don't have this anyway.

    I think Microsoft just "forgot" the Print command for the relationship window

    Edit: Gawd, this site needs more smilies!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    FWIW:
    In Office XP, AKA Office 2000, (SP3) there is an option in the file menu: PRINT RELATIONSHIPS, which does what it says on the tin

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    If you say so :Þ

    IMO, what it does is builds a report that doesn't quite match what you see in the relationships window. It doesn't even print it -- it creates a report. Just like other wizards.

    IE it's the tacked on Print Relationships Wizard that was added to Access 97 AFTER people complained that there was no functional print command to print the relationships at all. Microsoft just tacked on this wizard into the subsequent versions of Access... instead of working to make a functional print command that actually can scale exactly what you see in the relationship window and actually prints it to fit on the number of pages you want to give it... in landscape or portrait.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  7. #7
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    mebbe theres something odd going on then
    yes it is a report, who cares..... you can then print that report.
    it does allow multi page printing
    it does allow portrait or landscape
    it does expand to show all columns in a table
    and it does look very similar to the layout in the relationships. yes its flawed, yes its not as immaculate as I'd like it.. but it is what you've laid out int he relationships window
    If you change relationships you have to generate a new report
    you can't edit that report because all the lines and boxes aren't linked, so any changes don't keep the RI links assoicated with the object, but its a freebee.

    it aint perfect.. but it does print the relationships

    I'd prefer to have a full data modelling tool layout on A0 paper, but theres lots of things that I'd like, they are not always a good idea or costg effective, or even available.

    If I want a prettier report and the customer doesn't have suitable modeling tool then I'd gen a report using Visio and reverse engineer the db

    But I suspect for most people using Access, and by default using JET tables, will be happy enough with the result formt Print Realtionships

  8. #8
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Sure, and it's up to each individual to choose what is better for their needs. Each method has it's advantages. I'll always choose the Printscreen - Paste method when the entire ERD can be seen on one screen.

    My point was simply that the so called File - Print Relationships command DOESN'T quite do what it says "on the tin"

    I also thought it might be worth mentioning the history behind it to show why the command has such glaring flaws... and why you don't get a print dialog box when you choose File - Print... and why there is no File - Print Preview.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  9. #9
    Join Date
    Sep 2013
    Posts
    1

    Smile Took a while but I figure a good way to do it.

    Quote Originally Posted by syntaxerror View Post
    hi guys,

    pretty dumb question here, if you could spare a moment :

    i just wondered what's the best way that i can paste the database relationship in access to a word document...

    thanks.
    I used OneNote screen clipping. Print the screen and then clip it with OneNote and paste to word.

Posting Permissions

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