Search results

Just one more thing, I am going to do a similar thing to this using a different form and tables, only I am using an index of 10 fields to see if any duplicates exist. I want the fields to be ignored if they are empty though. I would just set this on the description of the index, as well as the...

oh, never mind, I just needed to delete a bracket. It's working now, thank you so much for your help!

I swapped the strWhere line for the one you gave me, but it is giving me a compiler error at that line. I didn't change anything else about the code, but here it is again. There's probably something small wrong with it, but I don't know enough about VBA syntax to pick it out. Private Sub...

Here is my code as it stands, but I still have the same problem of the the OK option taking me to the first record instead of the one that has the values that the user typed. It also gives me the error message before every update, not just the ones that have problems. Private Sub...

I implemented the suggestions you gave me, and they work great! Thanks a lot! I was wondering though, I want the error message to take the user to view the record that was already existing with the values they entered if they select OK. if I don't use bookmarks, how do I do this?

how do I do Dcount with two fields?

Still using the same code I have for now: I've just noticed that when I select OK, the record that I want it to go to appears for a second before the user is taken to the first record. Is there a way to make this record stay?

Also, there are two fields that need to be unique together, but can have their own duplicate values. How does Before update work with two fields? Right now they are my primary keys, so an error message displays any ways.

Ok, I am pretty new at using VBA, so most of the code I have has been modified from stuff I've found online. So you are suggesting I use "before update" instead of "on error", and DLookup will replace the line: strWhere = "MfrPartNumbers_MfrPartNumber ='" & Me.MfrPartNumbers_MfrPartNumber & "'...

access 2007

I don't know why, but I have created an index and now can't set any of the properties for it. It has multiple values, but I have tried setting indexes with one values, and still the properties options are greyed out. There is no place to enter yes/no for uniqueness. Any suggestions as to what...

error message for duplicate entry I have two primary keys and when duplicates are entered in the form, it is not allowed. I would like to display a custom error message that gives the user the option to go back and change the information they entered, or to be taken to the form with the...