VBA delete record from table if certain fields are empty 1

[SeadnaS]

Subject says it all really. Need VBA code to delete a record if certain fields are empty in the table.

My form keeps saving useless records with empty fields and I keep going into the table and deleting them manually. So maybe in the forms on close event i could put in some code to delete records with null values.

 

[Andrzejek]

My form keeps saving useless records with empty fields

Here is your problem - fix your Form and you are set.

To get rid of 'useless records' try:
[tt]
DELETE FROM tblMyTable
WHERE SomeField = NULL
AND SomeOtherField = ' '[/tt]

Syntax depends on your definition of 'empty fields': NULL, Spaces, one space, empty string [tt]('')[/tt]?

Have fun.

---- Andy

 

[SeadnaS]

So how to I run that in VBA?

 

[SeadnaS]

its ok i got it.