Bruce - Can you tell me more?

[G Lam]

Hi, I saw the following three lines of codes. How does it work? What is
[z1 - PretblPermitsFinal]"? Is it a query?
Thank you in advance.
Gary

Dim dbDel As Database
Set dbDel = DBEngine(0)(0)
dbDel.Execute "DELETE * FROM [z1 - PretblPermitsFinal]", dbFailOnError

 

[John Spencer (MVP)]

The [z1 - PretblPermitsFinal] should be the name of a specific table.

What this does is delete all the record in the table after the FROM.

Genericly, that would be
"DELETE * FROM [YourTableName]"

By the way, it is best to continue questions in the same thread. That way
people responding have background information available.