By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,503 Members | 2,788 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,503 IT Pros & Developers. It's quick & easy.

Password Fields

P: 72
Hello Everyone,

I have to set up a electronic form for recording additions to a chemical proccess where I work. Think of this as a big kitchen but instead of food products we have chemicals. So here's the lowdown on this.

In each record there are two fields where a product is added to the process called LBS and CODE. One is of course for the amount and the other is the product code. After this is entered in we have someone come over to verify that this is correct. There is another field (CHKD BY) where this person will type in a personal password for verification that everything is correct before it's added.

Here's what I need. Each record doesn't always record an add of product. I would like be able to set this up where entry in the CODE or LBS fields will trigger a requirement of a password in the CHKD BY field other wise you cannot continue.

Now a second part of this is that we need to make sure the operator for this process doesn't use his own code. I have an initial password field for logging into the database. Is there anyway that the CHKD BY field can deny the password based on what is entered into the inital login area?

Currently Running Vista and Access 2007.

All help is appreciated.
Jun 8 '07 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,597
Hello Everyone,

I have to set up a electronic form for recording additions to a chemical proccess where I work. Think of this as a big kitchen but instead of food products we have chemicals. So here's the lowdown on this.

In each record there are two fields where a product is added to the process called LBS and CODE. One is of course for the amount and the other is the product code. After this is entered in we have someone come over to verify that this is correct. There is another field (CHKD BY) where this person will type in a personal password for verification that everything is correct before it's added.

Here's what I need. Each record doesn't always record an add of product. I would like be able to set this up where entry in the CODE or LBS fields will trigger a requirement of a password in the CHKD BY field other wise you cannot continue.

Now a second part of this is that we need to make sure the operator for this process doesn't use his own code. I have an initial password field for logging into the database. Is there anyway that the CHKD BY field can deny the password based on what is entered into the inital login area?

Currently Running Vista and Access 2007.

All help is appreciated.
In the BeforeUpdate() Event of your Form, write code similar to that listed below:
Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_BeforeUpdate(Cancel As Integer)
  2.   If Not IsNull(Me![txtCode]) Or Not IsNull(Me![txtLBS]) Then
  3.     If IsNull(Me![txtCHKD_BY]) Then
  4.       MsgBox "You must enter a Password in the CHKD BY Field in order to proceed", _
  5.              vbExclamation, "Required Field Missing"
  6.       Cancel = True
  7.     End If
  8.   End If
  9. End Sub
Jun 9 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.