访问输入表单 - 字段验证&密码过骑 [英] Access Input Forms - field validations & password over ride
问题描述
嗨：
我希望有人可以帮助我。
如果必须覆盖验证规则，是否有办法在特定字段中添加密码？
我已经在我正在创建的数据库中创建了一个输入表单。特别是一个字段具有输入验证。 < = 125000"带有警告信息，表明净重必须小于或等于125,000磅或需要验证。
用户希望能够覆盖此规则，必要时，通过密码或其他类型的登录验证。换句话说，他不希望任何人都有能力覆盖这个规则。
我正在使用带有Service Pack 3的Access 2000.
谢谢，
JMKC
Hi:
I hope someone can help me.
Is there a way to add a password to a particular field in the event that the validation rule must be over written?
I''ve created an input form in a database that I''m creating. One field in particular has an input validation of " <=125000 " with a warning message that states "THE NET WEIGHT MUST BE LESS THAN OR EQUAL TO 125,000 lbs OR VALIDATION IS REQUIRED."
The user would like the ability to override this rule, when necessary, via a password or some other type of login validation. In other words he does not want just anyone to have the ability to override this rule.
I am using Access 2000 with service pack 3.
Thanks,
JMKC
推荐答案
嗨。是的，这确实是可能的。您需要远离现在使用的验证的自动性质并手动编码所有内容。
您可以将特定单词硬编码为密码，也可以将用户密码存储在表中并在验证输入时查找它们。
Hi. Yes this is indeed possible. You would need to step away from the automatic nature of the validation you are using right now and code everything by hand.
You could either hard code a particular word as a password or you could store user passwords in a table and look them up when validating the input.
嗨：
我希望有人可以帮助我。
如果必须覆盖验证规则，是否有办法在特定字段中添加密码？
我已经在我正在创建的数据库中创建了一个输入表单。特别是一个字段具有输入验证。 < = 125000"带有警告信息，表明净重必须小于或等于125,000磅或需要验证。
用户希望能够覆盖此规则，必要时，通过密码或其他类型的登录验证。换句话说，他不希望任何人都有能力覆盖这个规则。
我使用带有Service Pack 3的Access 2000.
谢谢，
JMKC
Hi:
I hope someone can help me.
Is there a way to add a password to a particular field in the event that the validation rule must be over written?
I''ve created an input form in a database that I''m creating. One field in particular has an input validation of " <=125000 " with a warning message that states "THE NET WEIGHT MUST BE LESS THAN OR EQUAL TO 125,000 lbs OR VALIDATION IS REQUIRED."
The user would like the ability to override this rule, when necessary, via a password or some other type of login validation. In other words he does not want just anyone to have the ability to override this rule.
I am using Access 2000 with service pack 3.
Thanks,
JMKC
这是一个直接来自帮助文件的例子，说明如何通过VBA完成此任务。它将[年龄]字段中的验证规则设置为> 65附带验证文本：
Here is an example straight from the Help Files as to how you would accomplish this via VBA. It sets the Validation Rule in the [Age] Field to > 65 with accompanying Validation Text:
非常感谢！
JMKC
Thanks so much!
JMKC
这篇关于访问输入表单 - 字段验证&密码过骑的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
