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