我如何比较两个记录？ （访问） [英] How can I compare two records? (Access)

问题描述

我应该创建一个有效按钮，一旦在单元格中插入密码，就会验证密码是否与已插入另一个表中的密码相同。



例如：

I should create a "Valid" button which once inserted the password inside the cell goes to verify that the password is equivalent to the one already inserted in another table.

Example:

Users table
User A 12345
User B 6789
User C 4785

Hours Mask

User A 8 hours 12345 [VALID] (Right password? Yes, proceed to insert the record. Wrong password? Error.)

（我正在使用Access 2007-2016）



我尝试了什么：



老实说，我徒劳无功，因为我不明白如何比较这两个记录。

我试过使用VBA（Ithink，模块）代码，但即使我输入错误的密码，记录也会添加相同的内容。

(I'm working on Access 2007-2016)

What I have tried:

Honestly, I tried in vain, since I do not understand how to compare the two records.
I tried with VBA ( Ithink, the modules) code but even if I enter the wrong password the record is added the same.

推荐答案

用户名和密码是身份验证的凭据。除此之外，不再需要凭证，因此实质上;第二个表格不需要密码。



问：我如何更改您的流程？

A：验证凭据表A，如果验证成功，则将新记录插入表B

User names and passwords are credentials for Authentication. Outside of that, the credentials are no longer needed, so in essence; the second table has no need for the password.

Q: How would I change your process?
A: Validate the credentials against "Table A", and if authentication succeeds, insert the new record into "Table B"

这篇关于我如何比较两个记录？ （访问）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！