[AccessD] Relationships

Sun Feb 13 17:23:24 CST 2022

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
>