Search results

I have a form that will not load the records on open. I have an on open command that points it to a new record but I would like the user to be able to go back through the list to edit prior entries if need be. Why will it not load all records. The control source is a query and when the query...

I need to develop a report that will check the database for all names who have not had an evaluation in the past 30 days. The tables are linked by Social Security Number. They have multiple evaluations per person.

What Reference has to be turned on in order to get the third option of get data based on selection? I can't seem to find the correct Reference! Thanks Landon

Please help with the following problem http://www.access-programmers.co.uk/ubb/Forum7/HTML/002491.html thanks [This message has been edited by kellan4459 (edited 12-03-2001).]

I have asked before but I didn't get the solution. What I am looking at is a Table Named EmployeeData. This table contains the fields {SSN, LastName, FirstName, MiddleInitial, OriginalHireDate, OriginalPayRate, Discipline, Level} I want the combo box to check if SSN(combo box field) has been...

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."...

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...

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...