Access: delete data record via VBA - how it works

You can also use VBA to delete a record in Access. We'll tell you exactly how this works in this practical tip.

Access: delete data record via VBA - how it works

1. Open Office Access and the respective database.
2. Then create a new macro first.
3. Enter the command "DoCmd.RunCommand acCmdDeleteRecord" so that the data record is deleted.
4. Tip: If you want the data record to be deleted without confirmation, enter the command "DoCmd.SetWarnings False DoCmd.RunCommand acCmdDeleteRecord DoCmd.SetWarnings True".
5. To delete the data record, you simply have to run the macro.

We have put together the 5 best access tips for you in the next practical tip.