Delete empty entires

[justinwright]

I was wondering if there was a way in VB code to search for and delete empty entires (in case someone hits the Add Record button I made by mistake without putting anything in). The test would be if the SITE section (normally a number thats 3 - 6 digits) in the List table is filled in. If not, clear the entry (row).



I saw a post here:
https://www.accessforums.net/program...able-5608.html

But it's for columns, not rows.

I'm putting it as a button on an administration form.

Any help is much appreciated .

[pbaldy]

Try a delete query:

DELETE * FROM TableName WHERE Site Is Null

If you want to do it from code:

CurrentDb.Execute "DELETE * FROM TableName WHERE Site Is Null", dbFailOnError

[justinwright]

Worked perfectly, thanks!

[pbaldy]

No problemo, glad it worked for you.