[AccessD] Relationships

Sun Feb 13 18:57:34 CST 2022

Aw Rocky, I just want to slap your face for the hello of it. You bst watch
out!😉

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

> Yeah I solved the problem actually - I stopped doing Access development.
> Got one client left (and a couple of others that call once in a while). So
> I rarely run into that problem anymore. :o)
>
> And yes, all my problems are first-world problems. Garage door broke
> yesterday. But I have a garage. My camera broke last week, but they're
> doing the repair and sending it back which costs the average family a
> week's worth of groceries but not me. My bicycle computer broke a few days
> ago. But I have a bicycle.
>
> My best friend in Chi is COVID+. Found out while he was in florida for a
> meeting.  Now he's confined to a beach side resort in Del Ray Beach.
>
> One of my bike buddies is fighting impaired kidney function. Another bike
> buddy is on the DL with prostatitis. A third bike buddy has COVID.  The
> ride was called off this Sunday. And probably for a few more Sundays.
>
> But I'm healthy and riding, eating and sleeping well, marketing my book,
> playing music in a string orchestra and a country trio.  If I complain
> about anything, you can slap my face.
>
> r
>
> On Sun, Feb 13, 2022 at 2:30 PM Arthur Fuller <fuller.artful at gmail.com>
> wrote:
>
> > 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
> > --
> > 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