Discuss "delete button" in the Microsoft Access forum.

techker · #1 (**permalink**) May 20th, 2008, 05:40 PM

hey guys i was wondering.i wan't to make a report with a delete button next to it?

what code to i put?is there any tutorials for this??thx!!

sbenj69 · #2 (**permalink**) May 20th, 2008, 05:49 PM

surely you mean form, right? If you meant report, think of the report itself being a piece of paper. What you're asking is, if I draw a delete button on my piece of paper, and I press that drawing with my finger, I want all of the rest of the ink to disappear from the piece of paper.

Hope that explains things better

techker · #3 (**permalink**) May 20th, 2008, 05:54 PM

lol funny..

i mean in a report you see the clients with a link to the details. but i wan't next to the client a delete button.

but i think you mean i can only do it in a form .now the part for me is to make the form show the clients in the database.??

sbenj69 · #4 (**permalink**) May 20th, 2008, 05:59 PM

It's as simple as using the query that you made your report with, you would merely change the form to continuous form in the properties. Include a delete button with each record. It's go-home time for me now..... Then off to billiards..... I will work on getting you a sample database to view tomorrow.

techker · #5 (**permalink**) May 20th, 2008, 06:14 PM

thx i will try it out.

AOG123 · #6 (**permalink**) May 21st, 2008, 04:48 AM

Another option which i use in my dbs, see below,.

I like using this as its easy to put in a select case incase the the record is deleted by accident. Just create a command button in your continuous form and paste the code in the onclick event. Feel free to change the MsgBox message to whatever you like.

Code:

 On Error Resume Next
 Dim intAnswer As Integer
 intAnswer = MsgBox("Are you sure you want to Delete selected Line?", vbOKCancel, "Delete")
 Select Case intAnswer
    Case vbOK
    
     intAnswer = MsgBox("Final Warning - Continue and Delete Line?", vbOKCancel, "Warning! Delete")
         Select Case intAnswer
             Case vbOK
    
        DoCmd.SetWarnings (warningsoff)        
        DoCmd.RunCommand acCmdSelectRecord
        DoCmd.RunCommand acCmdDeleteRecord
                       
     Case vbCancel
    DoCmd.CancelEvent
        
 End Select
      
    Exit Sub

    MsgBox Err.Description
    Resume Next
    
 End Select
End Sub

techker · #7 (**permalink**) May 21st, 2008, 06:06 AM

nice thx!

hey u was wondering.is it possible to merge to projects together?

like i made one that i want the same info in another db that im doing.

same form type.

techker · #8 (**permalink**) May 21st, 2008, 08:26 AM

by the way the delete button does not work in your example?

jmurrayhead · #9 (**permalink**) May 21st, 2008, 08:32 AM

Quote:

Originally Posted by techker

by the way the delete button does not work in your example?

Are you referring to AOG123's example? I just tested it and it works fine for me.

techker · #10 (**permalink**) May 21st, 2008, 08:36 AM

Quote:

Originally Posted by jmurrayhead

Are you referring to AOG123's example? I just tested it and it works fine for me.

?why is it then it does not work for me??is it the format?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Webform Default Button	Devwhiz	.Net Development	9	May 15th, 2008 01:15 PM
Display Radio Button Value onclick	theChris	JavaScript Programming	5	March 22nd, 2008 02:28 PM

The Following User Says Thank You to AOG123 For This Useful Post:
sbenj69 (May 27th, 2008)

Discuss "delete button" in the Microsoft Access forum.

Microsoft Access - Microsoft Access is a database for small to medium applications. Learn tips and tricks and best database practices here.