Executing SQL Command

[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!

 

[Van T. Dinh]

DoCmd.RunSQL strSQL

or

CurrentDb.Execute strSQL, dbFailOnError

Check Access VB on RunSQL and Execute.

 

[Simon Harris]

Thanks Van - Thats the one!

Simon.