Password Fields

[wideasleep]

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.

[ADezii]

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:

Private Sub Form_BeforeUpdate(Cancel As Integer)
  If Not IsNull(Me![txtCode]) Or Not IsNull(Me![txtLBS]) Then
    If IsNull(Me![txtCHKD_BY]) Then
      MsgBox "You must enter a Password in the CHKD BY Field in order to proceed", _
             vbExclamation, "Required Field Missing"
      Cancel = True
    End If
  End If
End Sub