Search results

If you have data such as employee Id that has a one to many relationship on another table(such as Positions the person has held) you can use a combobox to select the employee id. once selected you can use a command button to open a new form with the positions(use a list box based on a query)...

Jack, What I am trying to do is create a combo box that will allow the person to lookup all employees that have been entered. If the person has not been entered it will prompt them to make sure they want to add the person. Once added it will allow them to add the rest of the information...

I seem to have gotten past that error message but now the field is not updated because an error is occuring prior the item being added. any ideas?

Here is my code: Private Sub Combo35_NotInList(NewData As String, Response As Integer) Dim db As Database, rs As Recordset Dim strMsg As String strMsg = "'" & NewData & "' is not an available Social Security Number." strMsg = strMsg & " Click Yes to Add or No to re-type it."...

Yeah that should work.

Jack, I thought about thaat but the problem I think I will have with that is: They may have multiple times that this is entered per person and many entries per day. Will the query catch all that were added that day? I would like for the command_click to process this at the same time it...

If you are trying to check a text box against a primary key or field in a database then yes it can be modified to fit your needs. I had to modify it slightly to fit my needs and it worked all except one line. I removed that line and no further problems.

Thanks that helped me figure it out!

I need to be able to update the current pay field based on pay increase/decrease amount that is entered after evaluations. It must be based on the person's Social Security Number to validate the correct employee and then current pay = current pay + Pay Change. It will do this each time a new...

Yes the bound field is the primary field in the table.

I have a text box that the user will enter the SSN in. I need to figure out a way that when they tab to the next field access will check to see if SSN has been entered before. If it has I want a vbok error message to show that the SSN has been entered before. On ok the field will be cleared...