[AccessD] Relationships

[Arthur Fuller]

If that is your life's largest problem, then I envy you. 😉

On Sun, Feb 13, 2022 at 4:59 PM Rocky Smolin <rockysmolin2 at gmail.com> wrote:

> I'm working on a 32" display right now.  Problem is that when the form or
> report gets bigger, so does the cursor.
>
> r
>
> On Sun, Feb 13, 2022 at 12:52 PM Arthur Fuller <fuller.artful at gmail.com>
> wrote:
>
> > 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
> > --
> > 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