Command button to run delete query

davie303

New member
Local time
Today, 17:48
Joined
Oct 26, 2000
Messages
6
can any tell me how to get a command button
to execute a delete query
i tried to do this by adding a button
onto my form and then link it to the query
in the event wizard but my delete query
does not show up in my list of queries
help
 
When you use the command button wizard, select "misc" and then "run query". If your query is not in the list, then it is not saved as a query. Maybe it was saved as an SQL? If all else fails, re-created the query.
If it is a multiuser db with security, you might want to set the "run permissions" property of the query to "owner". That way it won't keep prompting throughout the query.
 

Users who are viewing this thread

Back
Top Bottom