07-09-2010, 08:04 AM #5 Michael.K Registered User Join Date: Oct 2007 Posts: 5 Thanks: 0 Thanked Step 6: Uninstall and Reinstall the Microsoft Access Program Associated with Error 3022 If your 3022 error is related to a specific program, reinstalling Microsoft Access-related software could be the answer.

Instead of actually deleting your records, you flag them as being deleted by setting the new field to True (Yes). I am using Me.Dirty=False to force a save but if there are duplicates I just get the standard Runtime 3022 error message. I have several forms which have several text and/or combo boxes bound to required fields and I would want to have a generic code, like the one here to trap errors this page Locate Microsoft Access Error 3022-associated program (eg.

The problem I found was when the last record added is a duplicate. Can you post a stripped down version your db so I can have a quick look. By the way, The Form allows entry of Volunteer Hours worked at a seniors home by various church groups.

Do you have any other indexes specified?

Here are the two relevant subs: First the Form_Error Sub... I really appreciate the help. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.

View 2 Replies View Related Home Submit Resource Tracker Forum Advance Search Privacy Policy| Terms of Use & Service| Contact Us| Copyrights Notice Copyrights 2005-15 www.BigResource.com, All rights reserved View 1 Replies View Related Error Trapping Problem Aug 6, 2007 I have an "Error trapping" problem.I am relatively new to VBA and wondered if someone would be so kind and I obvously don't understand the sequence of events enough. Get More Info Both the front end and back end compact when they close so that should take care of that right?

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)If KeyCode >= 48 And KeyCode <= 57 And KeyCode >= 96 And KeyCode <= 105 ThenMe.Input.SetFocusEnd IfEnd SubThis does not however enter the Now you can let Access worry about generating a unique PK, and you just have to worry about generating your own unique TaskNo.......... Half of what you said made sense... Step 8: Install All Available Windows Updates Microsoft is constantly updating and improving Windows system files that could be associated with Error 3022.

Then, when I was looking at the relationships and object dependancies, I think everything looks to be in order. The only difference with this procedure is that I need to know the Autonumber ID at the time of writing the new data. Find More Posts by boblarson 07-09-2010, 04:21 PM #11 vbaInet AWF VIP Join Date: Jan 2010 Location: U.K. Click on the Microsoft Access-associated entry.

Guess that means the other 1001 do. I have a couple problems now. Click Programs. Posts: 26,373 Thanks: 0 Thanked 2,403 Times in 2,372 Posts Re: Run-time error 3022 with .AddNew We would have solved this problem since post #2 Michael But glad you eventually noticed

The pri key would not SEEM to be getting duplicated, and the subtable linked field is not keyed.