Bruce - Can you tell me more?

  • Thread starter Thread starter G Lam
  • Start date Start date
G

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
 
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.
 
Back
Top