设置批准/拒绝对要在表中实施的表单所做的更改？ [英] Setting approval/denial for changes made to forms to be implemented in a table?

问题描述

我有一个使用主客户端表和表单创建的数据库来查看客户端信息，目前可以通过表单进行更改。我需要锁定数据库，以便其他人仍然可以查看所有表单但如果他们进行更改，将通过outlook向我发送一封电子邮件？所以我可以批准或否认这些变化。基本上我不希望任何人能够最终确定？主列表中的更改？直到我批准他们。


请帮我找到最简单的方法。我在VBA的经验非常有限，但过去一周我一直在努力工作。


非常感谢提前。

I have a database created with a master client table and forms to view the client information and currently changes can be made via the forms. I need to lock the database so that others can still view all the forms but if they make a change, an email will be sent to me through outlook ? so I can either approve or deny the changes. Essentially I don?t want anyone to be able to finalize the changes in the ?master list? until I approve them.

Please help me in finding the easiest way to do this. I have very limited experience in VBA but have been working very hard at it in the past week.

Much thanks in advance.

推荐答案

由于Access本质上是服务器和客户端，并且由于它的安全性能较差，因此您无法真正锁定用户数据。您可以将表单设为只读，但他们总是可以在基础表中更改它。

Because of the nature of Access being both the server and client, and because of it''s poor security features, you can''t really lock the user out of the data. You can make the form read only but they can always change it in the underlying tables.

robtech4，


一个可能的选择是用户可以查看数据，并且他们所做的任何更改都将添加到具有相同字段的另一个表中。然后，在更改之后，电子邮件将发送给您。您拉出表单的管理员级别，比较两个条目。然后，您可以通过命令按钮批准所有，部分或全部更改。无论哪种方式，这听起来都非常复杂......


另一个选择是在记录中只有一个备注字段，这是表单上唯一可更新的字段。然后，当有人更新该字段时，会发送一封电子邮件，您可以根据需要从管理员表单中查看。


这可能会让您指向正确的方向。可能有多种方法可以给这只猫上皮，有些方法比其他方法更有效。

robtech4,

One potential option would be to have the user be able to view the data, and any changes they made would be added to another table with identical fields. Then, after the changes, the e-mail goes to you. You pull up an adminstrator level of the form which compares the two entries. You could be able to then approve all, some or none of the changes via command buttons. Either way, this sounds pretty involved.....

Another option would be to simply have a memo field in the record, which is the only updateable field on the form. Then, when anyone updates that field, an e-mail is sent and you could review as necessary from an adminstrator form.

That might get you pointed in the right direction. There may be multiple ways to skin this cat, some more efficient than others.

Twinnyfo，


哇，很棒的解决方案！如果我要创建副本表单并在每个字段下面插入另一个框（可更新字段），那么设置批准/拒绝的过程是什么？按钮，以便一旦批准按钮单击按钮，主列表会自动更改新信息的旧信息吗？另外，您能否以最方便的方式建议设置电子邮件按钮。


再次，您的时间和专业知识非常受欢迎。

@twinnyfo

Twinnyfo,

Wow, great solution! If I were to create a replica form and below each field insert another box (updateable field), what would be the process for setting up the "approve/deny" button so that once the "approve" button is clicked, the master list would automatically change out the old information for the new information? Also, could you please advise on the most convenient way to set up the email button.

Again, your time and expertise are much appreciated.

@twinnyfo

这篇关于设置批准/拒绝对要在表中实施的表单所做的更改？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！