复选框：锁定Access 2003中的用户输入数据 [英] Checkboxes: to lock down user input data in Access 2003

问题描述

表单上有一个复选框，上面写着输入所有数据后，请选中此框。现在它什么也没做，但是我想让它锁定那个特定的数据集，这样就无法从数据输入表单中更改数据。我仍然希望能够对数据运行查询，但基本上想要锁定数据，以便其他用户无法更改它。


感谢您的帮助

解决方案

我在表单上有一个复选框，上面写着输入所有数据后，请选中此框。现在它什么也没做，但是我想让它锁定那个特定的数据集，这样就无法从数据输入表单中更改数据。我仍然希望能够对数据运行查询，但基本上想要锁定数据，以便其他用户无法更改它。


感谢您的帮助

以下代码将锁定输入表单上的当前记录：

展开 | 选择 | 换行 | 行号

< blockquote>

以下代码将锁定输入表单上的当前记录：

展开 | 选择 | Wrap | 行号

----


这似乎不起作用。在输入上面的代码后，这就是代码在代码中的样子：

Private Sub Done_Click（）

''必须首先保存记录

SendKeys" + {ENTER}"，True''保存记录

Me.AllowEdits = False

End Sub


我很擅长处理背景数据库，所以我可能不得不做其他事情，我没有看到。

感谢您的帮助，非常感谢。也许有一些我在这里缺少的东西。

当用户输入数据然后选中该框时，我希望他们放入数据的方框灰显出来。而且无法再添加任何数据。用户可以放入更多数据的唯一方法是取消选中复选框，然后他们可以输入更多数据。这可能吗？

I have a checkbox on the form that says "When all data has been entered, check this box". Right now it does nothing, but I want it to lock down that particular set of data so the data cannot be changed from the data input form. I would still like to be able to run queries on the data, but would basically like to lock down the data so other users cannont change it.

Thanks for the help

解决方案

I have a checkbox on the form that says "When all data has been entered, check this box". Right now it does nothing, but I want it to lock down that particular set of data so the data cannot be changed from the data input form. I would still like to be able to run queries on the data, but would basically like to lock down the data so other users cannont change it.

Thanks for the help

The following code will lock the Current Record on your Input Form:

Expand|Select|Wrap|Line Numbers

The following code will lock the Current Record on your Input Form:

Expand|Select|Wrap|Line Numbers

----

This does not seem to work. This is what the code looks like in the form after I input the above code:

Private Sub Done_Click()
''Must Save the Record first
SendKeys "+{ENTER}", True ''Save Record
Me.AllowEdits = False
End Sub

I am rather new to working on the "background" of databases, so there may be something else that I may have to do that I am not seeing.
Thanks for the help and very much appreciate it. Maybe there is something I am missing in this though.

When a user puts in the data and then checks the box, i would like the boxes where they put in data to "grey out" and not be able to put any more data in it. The only way a user could put more data in would be to uncheck the check box and then they could put more data in. Is this possible?

这篇关于复选框：锁定Access 2003中的用户输入数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！