Cancelling button actions (1 Viewer)

[Fiona]

Cancelling button actions in VB [solved]

Hey,

For my project I am doing a database kind of thing with VB (& Access)... and I have a button to delete records from the database. Anyway, how do I program it so that when you click on delete it gives you the option of cancelling, so you don't delete it, in case you press Delete by accident?

Thanks,

Fiona

 

[Fosweb]

What language you using?

Add a boolean variable, set to false.
Get confirmation of deleting user.
If the user wants to delete user, set boolean to True,
Then run the delete user code ONLY if the boolean is true...
Simple...

 

[fatmuscle]

SQL language?

 

[Fiona]

Oh woops... Doofus of the day is me...

VB...

 

[Fiona]

There is an option... Cancel... so I set that to true, and it didn't stop things from being deleted

 

[sunny]

    Dim retVal As Long
    retVal = MsgBox("really delete", vbOKCancel, "Delete?")
    
    If retVal = vbOK Then
      ' do delete
    end if

 

[Fiona]

Thankyou Sunny!

It worked, brilliance!

 

[neester]

Fiona
Even better would be (also i think its nicer coded):

If MsgBox("Are You Sure You Want To Delete?", "Delete Record", vbQuestion+VbYesNo) = vbYes then
'Do Delete
End If

You will get a message box, with YES NO options, and a QUESTION Mark Picture in the box

Hope It Helps You Out!

 

[Fiona]

For some reason I couldn't get that one to work... Hmm... I'll fiddle around with it later, thanks