Topics Search

Delete a record using VBA code in Access

Delete a record using VBA code in Access
Views: 3606
I want to delete the currently selected record. How do I delete the current record in the form?
Sponsored Links:

More topics

 

delete one record by from

Preview
I have 3 table.and every table have to relation.
2.i do QRY for 3 table link in from
3.i make from form for add, edit , and delete

my Qustion
1.when I delete in from but table not delete?
** I'm enforce and cascade delete related but can't delete it
in step 1 can't delete it I will do step 2
2.i make new button in code VBA

Private Sub Command123_Click()
DoCmd.RunSQL "Delete * from tbl_com"
Me.Requery
End Sub

it delete all record in table

I want delete 1 record in from and intable
 

Delete Record and Subform Records

Preview
I have searched the forum for the answer to this question but have not found the solution yet.
I would like to get rid of as many macros in my database as possible and rely on the VBA. I have a button to delete a record on my mainform, which I have put the following code:

Private Sub cmdDeleteSupplier_Click()
If (MsgBox("Deleting a supplier record will permanently delete it. Are you sure you want to delete?", vbYesNo, "Delete Confirmation")) = vbYes Then
If Me.Dirty Then
Me.Undo
DoCmd.SetWarnings False
If Not Me.NewRecord Then
DoCmd.RunCommand acCmdDeleteRecord
DoCmd.SetWarnings True
End If
End If
MsgBox "The supplier was successfully deleted.", , "Delete Confirmation"
End If End Sub

I have tried this code with a normal form and it does seem to work but my form has 3 subforms in it on tabbed pages.
My question is how do I get the code to work and delete the record including the other information referenced in the subforms? How do I select this info in
 

How to delete all records in a table

Preview
I an about to write some VBA code, where following some procedures, I will want to delete all record from a table to start fresh the next time I run the code.
 

Command button issue

Preview
I am trying to set up a command button in my form that when clicked will delete the record from my form and append it to an archive table. I have tried doing this via VBA and it works but it takes forever to run. So I have tried to set up a macro to do this, which also works but it requires you to click the button, go to the next record, go back to the desired record and click the button again (works much faster than the VBA code). The macro does the following once clicked it first sets the value of the delete field to delete and then runs the append query then runs the delete query (for records with a value of delete in the delete field). I am not sure why I have to change records and click the button again. Does anyone know of a way to do accomplish this task without changing records
 

Running Code based on User's Response to delete macro

Preview
I am using the standard delete macro that the access button creator has. I added a line to the macro that runs a vba code segment, but I only want this to run if the user presses yes to deleting the record. Is there a condition that I can write that will allow me to determine if the user pressed yes or no and run the code accordingly?
 

VBA delete current record continuous form

Preview
I have a button on a continuous form that appears next to each record on the form. I want it to delete the record on the same row from the source table using vba. I've tried Recordset.Delete, and I'm getting error messages.
 

VBA delete current record continuous form

Preview
I have a button on a continuous form that appears next to each record on the form. I want it to delete the record on the same row from the source table using vba. I've tried Recordset.Delete, and I'm getting error messages.
 

Delete Record and have combobox update

Preview
It's me again with another relatively simple access issue. I have a button that is set to delete a record, then refresh the list of records in a combobox; however, for some odd reason it takes two or three attempts to delete the actual record because it keeps showing up, and when it does delete it shows up in the combobox until you try to delete again, at which point you get a debug error saying that the record has been deleted
 

Delete Command Button not working on form

Preview
I have a Delete Command Button on a form which does not appear to be working properly.

I originally had a delete button macro created by the command button wizard and it seemed to be functioning properly. from the form it would ask if you want to delete the record permanently. If I chose yes, it would appear to delete it, meaning that if I were to search for the record to verify it would say that the record does not exist. Upon closing the form and viewing the table, the record would not actually be deleted and would then be back on the form when I would reopen it.

So, I browsed through the discussion board and found a suggestion on a couple of posts and tried that as well creating the delete button in the code builder using the following code:
 

Delete continuous form record

Preview
I have a button in my continuous form that shows up next to each record. I want this button to delete the record next to it with the Recordset.Delete code. Sometimes it works, and other times it says a current record is not selected. What can I added to the code to make sure that it selects the record it is next to?