[AccessD] Relationships

[Arthur Fuller]

Maybe an HDMI cable hooked to a 60" TV might help?

On Sun, Feb 13, 2022 at 11:50 AM Rocky Smolin <rockysmolin2 at gmail.com>
wrote:

> One of the things I always wanted to see is the ability to magnify a form
> or report in design view. Sometimes I'm working with controls, lines, or
> rectangles that are so hard to grab that I'm wishing I could magnify the
> form or report on the display. I have workarounds, but they're annoying and
> slow up my productivity.
>
> I'm still using 2010 so maybe they did this in later versions?
>
> r
>
> On Sun, Feb 13, 2022 at 5:58 AM Jim Dettman via AccessD <
> accessd at databaseadvisors.com> wrote:
>
> >
> > I should add that one of the things I did bring up did make it in, right
> > click and choose "size to fit" and you'll automatically expand the width
> of
> > a table so that you can read all the column names.   Also double clicking
> > the bottom of the window will expand it vertically to display all the
> > fields.
> >
> > Those features do make it a little easier to work with the relationships
> > window.   But the multiple layout pages is the only thing that would
> solve
> > the problem with complex databases.  They did allow you to select
> multiple
> > tables as a group though, which does help a bit.
> >
> > Jim.
> >
> > -----Original Message-----
> > From: AccessD On Behalf Of Jim Dettman via AccessD
> > Sent: Sunday, February 13, 2022 8:47 AM
> > To: 'Access Developers discussion and problem solving' <
> > accessd at databaseadvisors.com>
> > Cc: Jim Dettman <jimdettman at verizon.net>
> > Subject: Re: [AccessD] Relationships
> >
> > << Maybe some heavyweights like Jim Dettman (MVP) could put a bee(r) in
> the
> > bonnets of the Access Dev team toward fixing this serious inadequacy.
> This
> > is sooo frustrating!>>
> >
> > I would not call myself a heavyweight, but certainly one of the voices in
> > the choir on this.   In fact, I have already done so.   A list of
> features
> > was requested, and this is one I asked for specifically (the ability to
> > save multiple layout pages), but it was a bridge too far ☹.
> >
> > They did however implement many of the suggestions that were made.
>  Those
> > are covered in a video here:
> >
> > https://www.youtube.com/watch?v=m4xTwmflTcI
> >
> >  You might see some additional changes when the new Monaco SQL editor is
> > released later this year, as the query designer pane and the
> relationships
> > window share some common traits (same deal you got with the changes
> already
> > done).
> >
> > Jim.
> >
> > -----Original Message-----
> > From: AccessD On Behalf Of Arthur Fuller
> > Sent: Saturday, February 12, 2022 3:49 PM
> > To: Access Developers discussion and problem solving <
> > accessd at databaseadvisors.com>
> > Subject: [AccessD] Relationships
> >
> > One of the most hateful things about Access is its implementation of the
> > Relationships diagram. Maybe theye team underestimated the ambitions of
> > Access developers, but when you get to 100 tables a single diagram is
> > ludicrous at best. By contrast, even the Community versions of SQL Server
> > allow creation of numerous diagrams, enabling you to focus on some small
> > group of trees, Rather than the whole jungle at once.
> > I have a client who doesn't wish to move to SQL Server. My only
> alternative
> > ithat I know of is to migrate the BE to SQL Server, create many
> > Relationship diagrams there, perform my adjustments there, and then
> > painstakingly copy them back to the ACCDB.
> > Maybe some heavyweights like Jim Dettman (MVP) could put a bee(r) in the
> > bonnets of the Access Dev team toward fixing this serious inadequacy.
> This
> > is sooo frustrating!
> >
> > --
> > Arthur
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Arthur