P
pokdbz
How do you run a query using code? I have a delete query named
ProviderDelete. How do I run this using code?
ProviderDelete. How do I run this using code?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
If you add a button to your form, the button wizard will build the code for
you. It is in the "miscellaneous" category.
you. It is in the "miscellaneous" category.
W
Wayne Morgan
Using the query name,
CurrentDb.Execute "ProviderDelete", dbFailOnError
There are modifications on the syntax, depending on how you're wanting to do
it. This will run without any prompting or warning, but will return and
error and undo what it may have already done if something fails.
CurrentDb.Execute "ProviderDelete", dbFailOnError
There are modifications on the syntax, depending on how you're wanting to do
it. This will run without any prompting or warning, but will return and
error and undo what it may have already done if something fails.
P
pokdbz
Perfect. Exactly what I was looking for.
Wayne Morgan said:Using the query name,
CurrentDb.Execute "ProviderDelete", dbFailOnError
There are modifications on the syntax, depending on how you're wanting to do
it. This will run without any prompting or warning, but will return and
error and undo what it may have already done if something fails.