如何在Access中自动取消选中框 [英] How to auto uncheck boxes in Access

问题描述

大家好，


不确定以下是否可行。


标准的MS Access用户界面上有一个复选框号码菜单页面，例如工具/选项/视图。我被要求找到一种方法来通过使用VBA或任何其他方法编写宏或模块来自动取消选中这些控件。


想法是用户，具有有限的访问权限和技术知道如何，打开Access，只需运行宏或单击某些内容取消选中复选框。


这个问题不是关于运行宏或模块，而是关于编写一些自动进程取消选中复选框，虽然它可能或可能不涉及使用宏或模块来执行此操作。


此外，这些标准菜单页面，例如工具/选项/视图，具有可以的名称被引用，例如viewForm.checkboxXX.checked = false


任何帮助将不胜感激

Denis

Hi Everyone,

Not sure the following is possible to do.

The standard MS Access user interface has checkboxes on a number of menu pages, such as Tools/Options/View. I have been asked to find a way to automatically uncheck these controls by writing either a macro or module using VBA or any other method.

The idea is that the user, with limited access rights and technical know how, opens Access and just run a macro or click something to uncheck the checkboxes.

This question is not so much about running a macro or module but about writing some auto process to uncheck the checkboxes although it may or may not involve using macros or modules to do it.

Also, do these standard menu pages, eg Tools/Options/View, have names that can be referenced, eg viewForm.checkboxXX.checked = false

Any help would be appreciated
Denis

推荐答案

@ dragon52


以编程方式控制
工具中的所有选项==> 选项 ==> 查看 ==> 显示标签：

@dragon52
To programmatically control all the Options in the
Tools ==> Options ==> View ==> Show Tab:

展开 | 选择 | Wrap | 行号

如果在单词 SetOption上按F1键然后它将打开Context-Sensitive帮助页面，其中包含指向列出可用值的另一个页面的链接。


如果更改是，Big-Brother喜欢，是永久分配，然后SetOption很好。如果您需要仅为会话进行更改，请在更改之前使用GetOption保存当前设置，并在完成后将它们设置回以前的值。

If you press F1 on the word SetOption then it will open the Context-Sensitive help page which contains a link to another page where the usable values are listed.

If the changes are, Big-Brother like, to be assigned permanently, then SetOption is fine. Should you require to make the changes just for the session, then use GetOption to save the current settings before the change is made, and set them back to their previous values upon completion.

嗨大家好，


非常感谢您的回复。你给了我我需要的信息。


我已经将VBA代码附加到表单上的按钮，而该表单依次附加到工具栏上的新菜单项。它有效。


我想知道是否可以将VBA代码直接附加到我创建的菜单项。只是想让它更优雅（用户友好）。

Hi guys,

Thanks a lot for your responses. You gave me exactly the info I needed.

I have attached the VBA code to a button on a form which in turn is attached to a new menu item on the toolbar. It works.

I am wondering if it is possible to attach the VBA code directly to the menu item I have created. Just want to make it a little more elegant (user friendly).

这篇关于如何在Access中自动取消选中框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！