[AccessD] [EXTERNAL] A Couple of Settings

Tue Feb 13 12:16:38 CST 2024

Shane:

That is EXACTLY what I was looking for. I knew it was there because I had
used it in the dim past but I'll be danged if I could remember where.

I have continued to work in A2010 because some of my old clients are still
on it. Or some less than the most recent Access. I have access 2019, loaded
it, tried to run it with 2010 installed, ran into some problems, and
uninstalled it.  I only have a few clients left - I'm on the way out -
almost entirely retired - just doing the fun parts.

So not motivated to upgrade me and anyone else I might have to work with
(yes I could move to late binding - resolving references was a problem
developing in a later version than the client was using - they always
resolved if their version was later than mine; and of course that SafePtr
thing).

I'm not too worried about 2010 not being supported. It has worked very well
for me since it came out and I don't have any problems with it. That's what
I love about obsolete tech - it works!

Thank you for the directions to the Wizard thingy.

Best,

Rocky

On Mon, Feb 12, 2024 at 10:34 PM Shane Groff via AccessD <
accessd at databaseadvisors.com> wrote:

> I don't have a copy of Access 2010 handy (and neither should you, it's out
> of support!)
>
> However, it is still much the same.  I'm talking about the 'Controls'
> section of the ribbon in the Form Design ribbon.
> You know, where you click to add a new button (or other control)
> If you click the little down arrow at the bottom of the scrollbar next to
> the controls, it will show some additional commands:
> Set Control Defaults
> Use Control Wizards
> ActiveX Controls
>
> Shane
>
> -----Original Message-----
> From: AccessD <accessd-bounces+shaneg=microsoft.com at databaseadvisors.com>
> On Behalf Of Rocky Smolin
> Sent: Monday, February 12, 2024 5:19 PM
> To: Access Developers discussion and problem solving <
> accessd at databaseadvisors.com>
> Subject: Re: [AccessD] [EXTERNAL] A Couple of Settings
>
> Re: 1. - yep, that works. Except I was hoping that would be object
> dependent - that is when in the design view of a form I almost always want
> the property sheet on - for queries almost always off. If I can remember to
> close the property sheet on the form before opening a query that would
> work. Except I'm trading off closing it in the query for closing it in the
> form.  And 1/2 the time I'm opening a query it's from the property sheet in
> the form. Oh well, can't have everything, I guess.
>
> Re: 2. Forgot to say that I'm using Access 2010. Where is this 'tool
> gallery' of which you speak? :o) Is it not in 2010?
>
> Thanks and regards,
>
> Rocky
>
>
> On Mon, Feb 12, 2024 at 11:26 AM Shane Groff via AccessD <
> accessd at databaseadvisors.com> wrote:
>
> > Hi Rocky,
> >
> >
> >   1.  The property sheet will be in the state it was last in when you
> > opened something in design (the state is shared across
> > table/form/query design), so if you don't want it to pop up in the
> > middle of the view, then close it, or dock it on the side, and it will
> > remember that state next time you open something in design.
> >   2.
> > Yes, there is.  You can use the "Use Control Wizards" toggle in the
> > tool gallery, or you can set this through code (application.SetOption
> > "Control Wizards", 0).
> >
> > Shane
> > ________________________________
> > From: AccessD
> > <accessd-bounces+shaneg=microsoft.com at databaseadvisors.com>
> > on behalf of Rocky Smolin <rockysmolin2 at gmail.com>
> > Sent: Monday, February 12, 2024 8:43 AM
> > To: Access Developers discussion and problem solving <
> > accessd at databaseadvisors.com>
> > Subject: [EXTERNAL] [AccessD] A Couple of Settings
> >
> > Dear List:
> >
> > 1) Is there a setting that will open a query in design view with the
> > property sheet not visible? (It's always in the middle of the QBE grid
> > or hiding part of the tables.
> >
> > 2) When creating a new command button, is there a setting that will
> > disable the command button wizard?
> >
> >
> > MTIA
> >
> > Rocky
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> >
> > https://data/
> > baseadvisors.com%2Fmailman%2Flistinfo%2Faccessd&data=05%7C02%7Cshaneg%
> > 40microsoft.com%7C4541e9adc92f4fe650be08dc2c31cc45%7C72f988bf86f141af9
> > 1ab2d7cd011db47%7C1%7C0%7C638433839613569125%7CUnknown%7CTWFpbGZsb3d8e
> > yJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%
> > 7C%7C%7C&sdata=RESJ5gqsjppuh69cmwOldZqkXbpuN99L%2Fbr80jgXGkI%3D&reserv
> > ed=0
> > <https://dat/
> > abaseadvisors.com%2Fmailman%2Flistinfo%2Faccessd&data=05%7C02%7Cshaneg
> > %40microsoft.com%7C4541e9adc92f4fe650be08dc2c31cc45%7C72f988bf86f141af
> > 91ab2d7cd011db47%7C1%7C0%7C638433839613579971%7CUnknown%7CTWFpbGZsb3d8
> > eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0
> > %7C%7C%7C&sdata=SsgB4%2BVVY0Hh89BPzzjW%2FX%2BtoVSFe1dJEDh0sMiPyO8%3D&r
> > eserved=0>
> > Website:
> > http://www.d/
> > atabaseadvisors.com%2F&data=05%7C02%7Cshaneg%40microsoft.com%7C4541e9a
> > dc92f4fe650be08dc2c31cc45%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7
> > C638433839613591002%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIj
> > oiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=jrydFqCeF%
> > 2Bhn7B944m%2Fppaaa6OiL6VqIysaPatQDZ4Y%3D&reserved=0
> > <http://www/.
> > databaseadvisors.com%2F&data=05%7C02%7Cshaneg%40microsoft.com%7C4541e9
> > adc92f4fe650be08dc2c31cc45%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%
> > 7C638433839613598595%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQI
> > joiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=KvgnYkfkK
> > JFN9ldumAXnPKhMJxqzRn51BAWqseEKOYI%3D&reserved=0>
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://data/
> > baseadvisors.com%2Fmailman%2Flistinfo%2Faccessd&data=05%7C02%7Cshaneg%
> > 40microsoft.com%7C4541e9adc92f4fe650be08dc2c31cc45%7C72f988bf86f141af9
> > 1ab2d7cd011db47%7C1%7C0%7C638433839613605377%7CUnknown%7CTWFpbGZsb3d8e
> > yJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%
> > 7C%7C%7C&sdata=bJlp9HQO1rYNiPn7RjJDrvKxCb77ziVPvSg41A48Lek%3D&reserved
> > =0
> > Website:
> > http://www.d/
> > atabaseadvisors.com%2F&data=05%7C02%7Cshaneg%40microsoft.com%7C4541e9a
> > dc92f4fe650be08dc2c31cc45%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7
> > C638433839613613128%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIj
> > oiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=c1G4Fp8k3q
> > 8rCeglWmK%2FPrfG2yP79HAANpXkvnzp%2B9o%3D&reserved=0
> >
> --
> 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
>