[AccessD] [EXTERNAL] A Couple of Settings

[Shane Groff]

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/