Executing SQL Command

  • Thread starter Thread starter Simon Harris
  • Start date Start date
S

Simon Harris

Hi All,

Quick question, I seem to remember that there is a away of executing an SQL
string from Access VBE. I'm not talking about a record set, simpler than
that, some sort of function.

I used it once before, but cant remember where or how.

I now wish to use it for a delete record button.

Any help would be appreciated.

Regards,

Simon.
--
-
* Please reply to group for the benefit of all
* Found the answer to your own question? Post it!
* Get a useful reply to one of your posts?...post an answer to another one
* Search first, post later : http://www.google.co.uk/groups
* Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!
 
DoCmd.RunSQL strSQL

or

CurrentDb.Execute strSQL, dbFailOnError

Check Access VB on RunSQL and Execute.
 
Back
Top