sql in module

[weeze2]

Ok maybe my first question was too vague. But I thought that I could solve the problem with sql. Can some one help me with the syntax of using sql in a module.
How does one use sql in a vb function? Can you write sql in the function or does one have to use it in a string?

 

[mp9]

Within a module:

CurrentDb.Execute("UPDATE tblStaff SET Status='A';")

Or, if you're doing loads of statements:

Dim dbs as DAO.Database
Set dbs = DBEngine(0)(0) 'Faster than CurrentDb
dbs.Execute("UPDATE tblStaff SET Status='A';")
dbs.Execute("UPDATE tblMgr SET Status='A';")
dbs.Execute("UPDATE tblDir SET Status='A';")
dbs.Execute("UPDATE tblBoard SET Status='A';")
Set dbs = Nothing
dbs.Close