Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 FIX: Prob changed order of delete events (ADP/MDB)

Author  Topic 

SupaHoop
Starting Member

8 Posts

Posted - 2004-02-17 : 11:56:00
More searching on the MSDN Knowledge base revealed the following solution:

http://support.microsoft.com/default.aspx?scid=kb;en-us;224333&Product=acc2000

You need to copy and paste the code into your form and make sure that wherever you update the form's recordset you update the rsADO object they create.

Thanks to all of you who took a look at this and where thinking of a solution.
____________________________________________________________________

I have just been searching through the Microsoft knowledge base and found the following article confirming that Bill & his cronies have changed the order of form events when using an Access ADP.

http://support.microsoft.com/default.aspx?scid=kb;en-us;234866&Product=acc2000

Unfortunately, it doesn't tell you how to resolve my problem of wanting to fire an event after the record has been deleted.

Any Ideas?_________________________________________________________________

Can anyone help me?

I have a subform where if a user deletes a record, I simply want to recalculate the total.

Reading MSAccess Help, it seems to imply that I can do this in the AfterDelConfirm event. According to the help, at this point the record is deleted and therefore totals can be recalc'd.

However, in my example this doesn't work.

I have put break points in my code and have seen that the AfterDelConfirm event is occuring BEFORE the Delete event and therefore the record that I am trying to delete still exists and is therefore included in my totals.

Easy, I thought, I'll just recalculate the totals in the Delete event, but NO, the record doesn't actually get deleted until you leave this event.

Can anyone help, this is driving me CRAZY. This MUST be a simple thing to do, am I going out of my mind or simply mis-understanding the help pages?

Cheers,
Rich

____
QPR's Blue & White blood runs through the veins.
RTID
   

- Advertisement -