[AccessD] [EXTERNAL] A Couple of Settings

[Rocky Smolin]

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://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdatabaseadvisors.com%2Fmailman%2Flistinfo%2Faccessd&data=05%7C02%7Cshaneg%40microsoft.com%7C3b0fdbf3ef5b472aa0ff08dc2be9e177%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C638433530799532092%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=%2FZfLKGhaXXOzKndswqsw%2FhE8CKPNoB2HWBFxgjKQ8E4%3D&reserved=0
> <https://databaseadvisors.com/mailman/listinfo/accessd>
> Website:
> https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.databaseadvisors.com%2F&data=05%7C02%7Cshaneg%40microsoft.com%7C3b0fdbf3ef5b472aa0ff08dc2be9e177%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C638433530799541863%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C0%7C%7C%7C&sdata=8Y4sdHmFR%2Fk4Z4fjv10wuFZO3DTjuG1IbX9dXcqfNUg%3D&reserved=0
> <http://www.databaseadvisors.com/>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>