Recent content by numbat

Does any one know how to determine which index is causing a dupicate value error (3022) in a table with multiple, no duplicate indexes. Thanks

Thanks for the tips. I think I will try something along those lines or perhaps use an unbound form. My current strategy is simply not working.

RoyVidar, You are correct that 'me.undo' will clear the form and hence the record in the case of a new record. My goal is to send the user back to the control that is causing the data validation error and give them the opportunity to change the value. I have an undo button, and if the user...

RoyVidar Thanks for your reply. This was the approach I had been taking although I hadn't used the undo command because I wanted the data in the other controls kept. So the problem I am encountering arises, for example, if the user clicks the save button, are sent back to the control and they...

I have created a form for entering new records with custom navigation and new record buttons. I have also created custom error messages for primary key and null value violations. My problem is how to allow the user to cancel a new entry if, for instance, enter a empty string in a primary key. At...

I need a routine that finds a record typed into a text box. My question is how do you notify the user if the record was not found. DoCmd doesn't seem to return an error when it doesn't find a record. Does anyone have any tips?