This worked fine before I installed SP3 for Office XP. I had SP2 and all pre-SP3 patches installed before.
My form [fForm] is tied to a temp table [tTemp]. Data is entered into the form and then the user pushes the "Save" button that I have placed on the form. This button runs a macro mFormSave which does the following:
RunCommand > SaveRecord
OpenQuery > qAppend (this is a simple query that appends [tTemp] to [tProduction]
RunCommand > DeleteRecord
Now, The macro appears to complete because the record is saved, appended, and then deleted. But then Access throws up an error where you can choose "halt" to halt the macro. The error code is 223, but I can't find any info on it. Here is the weird thing. If I remove the DeleteRecord from the macro, the record is saved and appended and the macro ends without arror. Clearly a DeleteRecord problem. BUT, if I run the "no DeleteRecord" macro and then hit the ">x" (Delete Record) button on the toolbar, it deletes the record without incident. I just doesn't like it when I do this in a macro. I even tried creating a second macro that only had RunCommand > DeleteRecord and running that at the end of the first macro. Same error. Then tried adding a button to the form that only ran the "DeleteRecord" macro and tried hitting it after running the shortened first macro via the "Save" button. Same error. It only happens when DeleteRecord is used in a macro.
One other piece of information that might be useful. I recently installed the post-SP3 Access patch hoping it would fix the problem. But it made it worse. Now, I still get the 223 error that I have to "Halt", but after that, I also get another error that says "no current record"
I need to find out what is causing this and how to get around it. I can't just hit the ">x" button on the toolbar because I have to enter hundreds of records in a 1 hour sitting and halting a macro error followed by clicking OK on the second error for each record would take up way too much time and be rather annoying. Any help would be greatly appreciated. Thank you.