rhk6446
asked on
How do I copy paste and print the MS Access Relationship Diagram and Table Documentation to MS Word?
Hello Experts,
I think the caption says it all: How do I move these from reports in MS Access to a MS Word Doc?
Thanks
rhk6446
I think the caption says it all: How do I move these from reports in MS Access to a MS Word Doc?
Thanks
rhk6446
You can't get the graphics from Access into Word. One option is to print to pdf. Put that requires som kind of PDF tool installed.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Jerryb30:
Thanks!
Will this work for the relationship diagram also?
rhk6446
Thanks!
Will this work for the relationship diagram also?
rhk6446
The actual diagram would have to be copied with a screen shot, and pasted into the Word document.
Don't know if there are add-ons which allow you to copy the relationships so you can move the individual elements as their own objects, so you could rearrange in a document, or powerpoint presentation.
here, I have a hard-working colleague who copies a screenshot of each table into a powerpoint slide, adds lines in the presentation indicating the relationships, and sizes things for large scale plotting. So, if anybosy has an automaed way to do that, my life would be easier.
Don't know if there are add-ons which allow you to copy the relationships so you can move the individual elements as their own objects, so you could rearrange in a document, or powerpoint presentation.
here, I have a hard-working colleague who copies a screenshot of each table into a powerpoint slide, adds lines in the presentation indicating the relationships, and sizes things for large scale plotting. So, if anybosy has an automaed way to do that, my life would be easier.
Some years ago I used Microsoft Visio to document the db. Relatinoships could be axtracted from access db's. You could also do the db design in Visio and create an Access db from that design.
Did not dig so deep unto that but it seem quite good. Since then Microsoft has taken over the devoelopment so I presume it has been even more integrated with Access/Office.
Did not dig so deep unto that but it seem quite good. Since then Microsoft has taken over the devoelopment so I presume it has been even more integrated with Access/Office.
The system table msysrelationships will give you text info, but I suspect drawing things into a diagram from that in Word or another office program would also present a challenge.
kirenievs:
Thanks. Haven't worked with Visio, but makes sense. As to microsoft adding functionality............. ..well, who knws.
Thanks. Haven't worked with Visio, but makes sense. As to microsoft adding functionality.............