| |
| |||||||
| Sponsored Links |
 |
| | LinkBack | Thread Tools | Display Modes |
| Sponsored Links |
|
#2
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  |
|
#3
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.?? |
|
#4
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. |
|
#6
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
__________________ If i helped you, make me famous by clicking the  Last edited by AOG123; May 21st, 2008 at 04:54 AM. |
| The Following User Says Thank You to AOG123 For This Useful Post: | ||
sbenj69 (May 27th, 2008) | ||
|
#9
May 21st, 2008, 08:32 AM
| ||||
| ||||
| Quote:
__________________ jmurrayhead If you agree with me... click the  icon! If my post solved your problem, click the  button in the lower right-hand corner of the post.If you like it here...throw us a few bones to help support us. Join our Folding team: DeveloperBarn Folding |
|
#10
May 21st, 2008, 08:36 AM
| |||
| |||
| Quote:
|
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
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 |
Linear Mode
