Private Sub Form_Open(Cancel As Integer) On Error GoTo Form_Open_Error
fRunSQL "DELETE * FROM tblMinTabel1" fRunSQL "DELETE * FROM tblMinTabel2" fRunSQL "DELETE * FROM tblMinTabell3" fRunSQL "DELETE * FROM tblMinTabel4" fRunSQL "DELETE * FROM tblMinTabel5"
DoCmd.Close acForm, Me.Name Raise MsgBox "Alle data slettet!", vbInformation
End Function ***************************************************************
I ovenstående kode er tblMinTabell3 "stavet forkert" for at fremprovokere en fejl. Denne fejl fanges i fRunSQL og en fejlmeddelelse vises, men så fortsætter rutinen og til sidst vises "Alle data slettet!", selvom en af tabellerne "ikke blev fundet".
Hvordan skulle ovenstående se ud, hvis jeg vil have vist fejlmeddelelsen og samtidig hvilke tabeller data rent faktisk blev slettet fra? (uden brug af 5 MsgBox'es!)
I dette særtema ser vi på, hvordan cloud og AI bliver fundamentet for virksomhedernes digitale forretning, og hvordan de nye muligheder for automatisering og forretningsværdi kan udnyttes uden at miste overblik, sikkerhed og menneskelig kontrol.
The error handler in Form_Open is never used because the error occurs in fRunSQL. You have to decide what you want before ist possible to give a solution.
Do you want to continue with the other tables even though one delete fails, or do you want to stop as soon as one error occurs?
If I have understood your code correctly then you will only get one error stating that tblMinTabell3 doesnt exist bit the other tables will get delete.
yes, that's correct terry. Well, it's difficult, VERY difficult to say what I need...on one hand, I'd like to notify the user that all but one table was transferred, but at the same time, I'd like him/her to know that NOT everything is ok. ;)
If I could some how "show a status list" or better yet, implement some form of roll-back......I would definetly prefer a roll-back, to maintain ACID rules, but I haven't worked with transactions in VBA, and the above code is used in Excel!
Hope you can get it to work, otherwise drop a comment.
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.