Search results for query: *

It worked!!! NoMatch and FindFirst were not in the list until I modified the DIM statments by adding DAO.Database and DAO.Recordset. It now appears to be working perfectly. Thanks for all of your help and patience!

Yes, I meant NOT the primary key. Thanks for the help. Unfortunetly, I am still having problems. I am now getting an error message stating that the Method or Data Member is not found. This seems to be happening on the rs.FindFirst line as well as the rs.NoMatch line. Any suggestions? Am I...

Okay, I solved the User-Defined type not defined problem by installing the DAO 3.6 Object reference library. Now I am getting an error message stating that the method or Data Member is not found. The error is on the “If Not rs.NoMatch Then” line. I have copied the actual VB code below for...

DZ, I did as your suggested but I am getting a compile error. "User-defined type not defined". The problem is with the Dim db as Database statement. I noticed that when I wrote the code, that Database was not in the list of choices that came up; however, Recordset was. I am usning...

Open your sub-form in design view, open the form properties, select the data tab and click the three dots next to the record source. This will either open up the Query builder for the Query or SQL statement. On the sort line of the field you want to sort, select either ascending or descending...

I need to warn of duplicate entry based on a user-entered field in a form. This is for an employee database and the field in question is the Social Security Number field. This field needs to be able to accept duplicates so setting the property to unique is not an option. After the user...