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.
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=acc2000You 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=acc2000Unfortunately, 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 |
|
|
|
|
|
|