Select and delete a record

  • Thread starter Thread starter Luis Marques
  • Start date Start date
L

Luis Marques

I need a code to select a record in a table and delete it.

Could you help me?
 
I need a code to select a record in a table and delete it.

Could you help me?
Click to expand...

Create a new query in the Query design window. Base it on the table; apply
whatever criteria are needed to select the record that you want to delete.
Change it to a Delete query using the Query menu option or the query type tool
in the toolbar.

Run the query and the record will be deleted. BACK UP YOUR DATA first - if
your query deletes 81224 records instead of the 1 you want, there's basically
no way to get them back.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record insert/delete anomaly 0
How to delete just one record? 2
Word VBA for deleting Selected Row 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Delete all Records 4
Deleting Records from recordset 9
Delete records in form 1
Can VBA amend data in tables 1

Back
Top