Deleting a Query

  • Thread starter Thread starter Anne
  • Start date Start date
Hi,
If you mean how do you delete a query from code:
CurrentDb.QueryDefs.Delete("yourQuery")

HTH
Dan Artuso, MVP
 
Currentdb.QueryDefs.Delete "queryName"

Hope This Helps
Gerald Stanley MCSD
 
Another way:

docmd.DeleteObject acQuery,"QueryName"

Chris Nebinger
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record insert/delete anomaly 0
View query written in VBA 2
Delete Query: Could not delete from specified tables 0
Deleting a temp query 2
Delete Queries, Forms, Reports And Modules 1
DAO qdfs does not delete my queries 9
Another little problem in SQL!! 2
Delete query in another database 1

Back
Top