[AccessD] Relationships

[Rocky Smolin]

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
>