Printing/Exporting Relationships

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with over 80fields. In the relationships window access doesn't
let me resize the table show that i can show all fields of the table but it
let's me up to a limit and then i have to scroll down. This causes the
problem that i cannot print correctly the table since it shows only the
fields available without scrolling down, an d hence the rest of the
relationships show at previous fields.

Is there a way to print (even in multiple pages) the whole table and avoid
this scrolling problem?

Is there a way to save an image (i.e. TIFF file) nomatter how large it is
that contains all the database relationships?

Thanx for reading this, the help and the answers!

Nezos
 
Before working on the print/export issue, a review of the tablesdbdesign
newsgroup will reveal that it is very unusual for a well-normalized
relational database (e.g., Access) table to contain more than 25 or 30
fields. If your table has 80 fields, there's a chance that it is designed
more like a spreadsheet. If so, your database/application would benefit
from further normalization.

If you'll post an example of the kinds of data fields this table holds, the
newsgroup readers may be able to offer an alternate approach, employing
well-normalized (and smaller!) tables, which would also help with your
print/export issue.


--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
If you want a simple solution that will produce a Bitmap of the entire
Relationship Window view see:
http://www.lebans.com/windowtobitmap.htm


For a professional solution, if you can send me the MDB containing the
Relationships window layout I will EMail you back a PDF document of a single
page containing all of your tables and fields. The single page is sized to
match your entire Relationship window layout. Max size is the PDF Doc page
size limit of I think 256 inches * 256 inches. I don't have the PDF spec
handy at this moment.

I wrote this utility last year but never got around to finish the final Beta
testing. I did test it on several relationship window layouts, with more
than 100 tables and more than 80 fields in some tables. The only issue is
that in order to accomodate the "hidden" fields within the table window, I
have to apply logic to move and resize the individual windows within the
Realtionship window layout. If you leave enough space under each Table
window that contains hidden fields, then your layout will be preserved. If
not you are at the mercy of the logic I implemented to perform the
move/resize.
(e-mail address removed)

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Thanx for the replies, as far as i understand Access does not provide a
solution to my problem. I have a solution (which cannot considered very
handy) like exporting two times the table 1. with the bottom fields hidden
and 2. with the upper fields hidden and then use Corel and that's it.

Thanx Lebans for your offer, but i can't send this database because it is
part of a project.

Thanx again for the answers

Nezos
 
Back
Top