Results 1 to 3 of 3
  1. #1
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    171

    Hi Quality Export of the Relationships Layout


    Hello,

    For the past 20 plus years the company I work for has been almost completely managed in Microsoft Access. which is impressive considering we are fabrication company that did almost $17mil in revenue last year, what is really Impressive is that the entirety of the design, all of the programing, every form, report, query, and table was all done by one guy, a structural engineer who had no formal training in relational databases or IT.
    Anyay he moved on from the company a few years ago. and we are getting ready to move into a real ERP. but I wanted to get a a Hi resolution image of the relationships layout (organized it a bit first) but then I want to get it framed for him. there's over 150 tables so its going to need to be pretty decent size 2'x4' at least (i would think) does anyone have any past experience or advice for doing this I am worried i am going to have to manually recreate the tables and relationship lines in a program like Visio is made for that type of thing.any advice or thoughts would be appreciated


    Click image for larger version. 

Name:	Picture1.jpg 
Views:	18 
Size:	118.7 KB 
ID:	52054

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,941
    Nice idea you'll need someone who has got a machine capable of printing A0 paper size to hi res.

    Not sure how wide/deep the relationships window will go, but don't believe it is possible to take an image of the window that is 'off screen'. And unfortunately the relationships window does not have a print option

    you could take several screenshots of different parts of the layout and 'stitch' them together again - perhaps a question for your printer

    Or perhaps instead of one large framed picture, do a montage of 3 or 4 smaller pictures (A3/A4) - could still go into one frame - could be long or square depending how you lay out the relationships.

    If you want a high res image, you might be better using adobe professional to create hi res pdf's - I produce a multi page (around 100 pages) catalogue for a client which requires 600dpi - and the page size is A4 landscape. Pretty sure with professional you can also set very large page sizes.

    Either way, I would talk to your printer to determine their requirements to be able to print what you want

  3. #3
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,425
    If I had access to a large monitor I might try taking a pic with a DSLR, using a tripod, remote shutter release, slow shutter speed (to negate the raster scan of the monitor - if it has any) and a hi-res setting on the camera. Keeping the plane of the camera sensor parallel to the plane of the monitor would also be important. If a sharp high res image results, it could be printed by most commercial printers.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 12-16-2016, 12:55 AM
  2. Replies: 7
    Last Post: 08-05-2016, 11:53 AM
  3. Replies: 8
    Last Post: 04-21-2015, 12:05 PM
  4. Replies: 16
    Last Post: 01-10-2013, 07:14 PM
  5. Export data as text for layout
    By Debby in forum Import/Export Data
    Replies: 3
    Last Post: 04-26-2009, 05:10 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums