Re: Relationships. Does anyone use them?

Stephen, it's been said many times, i know, but....for your amazing
solutions and your generosity in sharing them with the Access community -
thank you! <bows low>


"Stephen Lebans" <ForEmailGotoMy.WebSite.-WWWdotlebansdot...@xxxxxxxxxxxx>
wrote in message news:rqR4g.571$A26.15468@xxxxxxxxxxxxxxxxxxxxxxxxxx
Gunny I also have another Relationship window tool in the works. I nearly
finished it several weeks ago but work in the real world caught up to me.
The solution was originally built for developers who defined a
Relationship
window view that would not fit onto the max page size width supported by
the
Access report object(22.75 in).
Basically, I recreated the view in the Relationship window within a PDF
document. I chose a PDF doc as you can easily send a PDF to a printing
center to be rendered on a plotter or the use the native scaling props of
a
PDF reader app to output the doc to the page size of your choosing.

Allen Browne's code is used to show the properties of each relationship,
table field size etc.The two most difficult issues were the logic behind
the
rendering of the Relationship Lines and creating logic to move/place and
size individual Table windows so that all fields are visible(even if they
are not in the Relationship Window view). These two issues are completely
intertwined and took several days to solve.

I should find time to finish Beta testing next week.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@xxxxxxxxxxxxxxxxxxxxxx> wrote
in
message news:vomdnWYSZPGoWc7ZRVn-qQ@xxxxxxxxxxxxxxx
Hi, Ken.

One of the "features" that I wish ACCESS would do is to remember the
organization of the Relationships window when one imports a database
into
a new one (which is one way of fixing corrupted databases)

It doesn't seem like it would be that difficult to program this into
Access, does it? Oh, well. At least we have the built-in Print
Relationships tool, so Microsoft has been making some effort into making
database documentation a little easier.

If you don't have access to professional E-R diagram software, then the
Relationships window is the only way to see the table and query
relationships. When you have your tables arranged correctly, use
Stephen
Lebans's tool to save the current Relationship View in a table. That
way
you can restore that same view to the current database or to any other
database you import these tables into. As Allen Browne mentioned in a
previous post, you'll find Stephen's tool on the following Web page:

http://www.lebans.com/saverelationshipview.htm

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and
tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.


"Ken Snell" <kthsneisllis9@xxxxxxxxxxxxxxxxxx> wrote in message
news:c7OdnQ-4Kt3vJs7ZnZ2dnUVZ_vWdnZ2d@xxxxxxxxxxxxxx
"'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@xxxxxxxxxxxxxxxxxxxxxx>
wrote
in message news:4sWdnVHJKYBgMc7ZnZ2dnUVZ_t-dnZ2d@xxxxxxxxxxxxxxx
Hi, Salad.

Over time I'd go into the window and see relationship
spaghetti....tables/queries all overthe place with lots of
relationship
lines between here and there.

It's up to you to organize the positions of the tables in that window.
If it looks like a mess of spaghetti, then take a few minutes to
organize it better. As the database designer, you're in charge of
this.


One of the "features" that I wish ACCESS would do is to remember the
organization of the Relationships window when one imports a database
into
a new one (which is one way of fixing corrupted databases).... after
doing this many times during development, I've just "given up" on
redoing
the window each time, until I have "finished" the database (of course,
with my "biggest" application, it seems I'm continually adding new
features as soon as one is done, so...... < g >)

--

Ken Snell
<MS ACCESS MVP>








.

Relevant Pages

  • RE: delete row blocked by non-existant relationship
    ... > with my basic design, I had to change the field name and size that I am using ... I checked the relationships window and selected show ... An error message ... > On an off chance the last thing I did was select Tools> Database Utilities ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Initial Caps
    ... in the combo box's record source. ... you can then export the query object. ... > When I export data from a database, the company field exports a number not ...
    (microsoft.public.access.externaldata)
  • Re: Can not see anymore table relationship
    ... There is an icon in the relationships window toolbar with nine table icons on ... distirubute my church membership database to many churches of my denomination. ... Dim db As DAO.Database ... Dim fld As Field ...
    (microsoft.public.access.modulesdaovba)
  • Re: Relationships. Does anyone use them?
    ... organization of the Relationships window when one imports a database into ... so Microsoft has been making some effort into making database documentation ... Relationships window is the only way to see the table and query ... One of the "features" that I wish ACCESS would do is to remember the ...
    (comp.databases.ms-access)
  • Re: Relationships. Does anyone use them?
    ... If you do not care to "go in into the relationships window to set the relationship" you are, quite simply, going to fail badly any relational database course. ... Relationships are the constraints that are needed to be set up to ensure database structural integrity. ... You really need to go over this in detail, because right now I can tell you, no offence intended and with the greatest of respect, that you are NOT DOING RELATIONAL DATABASE DESIGN WORK at present. ...
    (comp.databases.ms-access)