LinkBack URL
About LinkBackshey 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!!
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!!
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
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.??
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.
thx i will try it out.
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
Last edited by AOG123; May 21st, 2008 at 05:54 AM.
If i helped you, make me famous by clicking the
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.
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.Originally Posted by techker
jmurrayhead
If you agree, give me rep.
If you like it here...throw us a few bones to help support us.
?why is it then it does not work for me??is it the format?
Posting Permissions 
Bookmarks