claracruz
asked on
"Multiple-step operation generated errors.
i GET THE ABOVE ERROR when i try to delete records from my recordset via the user-interface. here's my code;-
If MsgBox("Delete Entries For " & _
adoPayTracker.Recordset.Fi elds("MT.D ateWorked" ) & _
"?", vbYesNo) = vbNo _
Then Exit Sub
adoPayTracker.Recordset.De lete (adAffectCurrent)
adoPayTracker.Recordset.Mo veNext
I use the exact same code elsewhere in my program and it works fine.
the textboxes are bound to adopaytracker.
If MsgBox("Delete Entries For " & _
adoPayTracker.Recordset.Fi
"?", vbYesNo) = vbNo _
Then Exit Sub
adoPayTracker.Recordset.De
adoPayTracker.Recordset.Mo
I use the exact same code elsewhere in my program and it works fine.
the textboxes are bound to adopaytracker.
Dim dDateWorked
dDateWorked = NZ(adoPayTracker.Recordset
if dDateWorked = 0 then : Exit Sub
If MsgBox("Delete Entries For " & dDateWorked & _
"?", vbYesNo) = vbNo _
Then Exit Sub
adoPayTracker.Recordset.De
adoPayTracker.Recordset.Mo
Alan :)
ASKER
i'm sorry, but known of this has helped. i am deleting from 2 tables that are linked and error is on code:-
adoPayTracker.Recordset.De lete (adAffectCurrent)
adoPayTracker.Recordset.De
Hi claracruz,
Try setting the cursortype to 2 'adOpenDynamic
' Debug.Print adoPayTracker.Recordset.cu rsortype
Alan :)
Some discussion on this error:
http://www.utteraccess.com/forums/access/access493251.html
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q247/2/02.asp&NoWebContent=1
http://www.dougscode.com/faq/faq_doug1/dbp/dbp.asp?pkey=q1022
Try setting the cursortype to 2 'adOpenDynamic
' Debug.Print adoPayTracker.Recordset.cu
Alan :)
Some discussion on this error:
http://www.utteraccess.com/forums/access/access493251.html
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q247/2/02.asp&NoWebContent=1
http://www.dougscode.com/faq/faq_doug1/dbp/dbp.asp?pkey=q1022
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
INFO: Troubleshooting Guide for 80004005 Errors in Active Server Pages and Microsoft Data Access Components
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q306518
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q306518
If so, and the record you are deleting is referenced in that table, you will get
this error