Deleting records from a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a question :
I want to use the action 'OnClose' to delete the records of a table called
"customers",where the value of the field "status" and the field "receiving
date" of the table are NUll.
 
Pietro,

You can use a macro or a VBA procedure to run a Delete Query. In code,
a suggested way would be like this...
CurrentDb.Execute "DELETE * FROM Customers WHERE Status Is Null AND
[Receiving Date] Is Null", dbFailOnError
 
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

DELETE FROM a table WHERE... 1
cannot delete from specified tables 7
Turning a 3 column flat file into a "3D" Table 2
Query design 0
Special characters 3
Delete related Records 6
Access Validation rule in MS access 2010 1
Search utility 2

Back
Top