Is there a way to run an update query using a macro? I have an update query that I would like the end user to be able to click a command button to run it. I tried the way that I usually run a query in Macro but when I choose "OpenQuery", my update query is not in the list.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
macro to run an update query
- Thread starter smith7255
- Start date
I think you have to choose RunSQL not OpenQuery
Leslie
Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual
Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi
Leslie
Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual
Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi
- Status
Similar threads
- Locked
- Question
- Locked
- Question