A
Anne
How do I delete a query in a module?
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.
D
Dan Artuso
Hi,
If you mean how do you delete a query from code:
CurrentDb.QueryDefs.Delete("yourQuery")
HTH
Dan Artuso, MVP
If you mean how do you delete a query from code:
CurrentDb.QueryDefs.Delete("yourQuery")
HTH
Dan Artuso, MVP
G
Gerald Stanley
Currentdb.QueryDefs.Delete "queryName"
Hope This Helps
Gerald Stanley MCSD
Hope This Helps
Gerald Stanley MCSD
A
Anne
Many thanks to you both.
C
Chris Nebinger
Another way:
docmd.DeleteObject acQuery,"QueryName"
Chris Nebinger
docmd.DeleteObject acQuery,"QueryName"
Chris Nebinger