How to call a query in my vba module

[unixkid]

Hey guys,

I'm fairly new to this all so bear with me!

I have a query called "ClearTable Query" which clears the contents of a table, how do I call this in my vba module thingy? (i.e. the bit where you write the whole
sub myfunction
...
end sub

also, when i run the query on its own, it asks me for confirmation, how do I fix it so it just does the query without asking?

Thanks

 

[JANR]

Sub ClearTable()
Currentdb.Execute("ClearTable"), dbFailOnError
End Sub

This will run the query without any prompts from Access, or you can use this and you don't need your query:

Sub ClearTable()
Currentdb.Execute "DELETE * From YourTableName", dbfailOnError
End Sub

JR

 

[kevala]

Add this line to your code.
DoCmd.SetWarning (False)

This will disable all the confirmation messages. However, this will also disable all other system messages. So it may be prudent to set the SetWarnings property to True after you execute the function. I hope this helps