Recent content by zmizzi1

step 1 enter your employee ID step 2 click the search button If the record with a matching ID has no empty fields, then make a new record else go to the record that hasn't been filled. DCount won't work because I'm not verifying that there are no duplicates, i'm verifying that the duplicates...

So the record has to be completed in stages which is why we can't just prevent incomplete records from being stored. could the problem be solved by making the validation occur before the temporary record is created through some kind of ID search form? the form generate a new record if the...

If the record with a duplicate ID is completely filled, then allow the button to work else go to the record that hasn't been filled and delete this one.

its intended for no names to be typed at all but rather a PIN. fields go as follows: ID, First Name, Last Name, Various other unrelated fields that also need to be filled before allowing duplication. so you type in the PIN and your name appears following a button click verifying that you typed...

I have a button that prints out names based on an employee ID field. but I need to be able to stop people from duplicating records if they haven't completely filled out the previous record with their employee ID

Private Sub Timestamp_Click() If Not IsNull(Me.Timestamp) Then Me.TimeStampButton.Enabled = False MsgBox "Already Timestamped" DoCmd.Close Else Me.Timestamp = Now() MsgBox "Timestamped" DoCmd.Close End If

ok i discovered If Not and got it working lol, thank you

the problem is i don't know the code to check for a timestamped field, everything i can find is looking for empty fields rather than full ones

the problem is i don't know the code to check for a timestamped field

so i have a button that creates a timestamp but i don't want the timestamp to be replaced. anyway i can disable the button on 1 record after a click? also open to clever workarounds that you might have.