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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Auto delete query.......
- Thread starter 3682763
- Start date
![[pipe]](/data/assets/smilies/pipe.gif "[pipe] [pipe]")
You can create and then delete query defs using VBA.
example:
Dim db As DAO.Database
Dim qDef As DAO.QueryDef
set db = currentdb()
Create the query:
Set qDef = db.CreateQueryDef ("TempQuery", "Use SQL to define query here"
Use query however you want to and then delete it:
db.QueryDefs.Delete "TempQuery"
example:
Dim db As DAO.Database
Dim qDef As DAO.QueryDef
set db = currentdb()
Create the query:
Set qDef = db.CreateQueryDef ("TempQuery", "Use SQL to define query here"
Use query however you want to and then delete it:
db.QueryDefs.Delete "TempQuery"
ApplePirate
Programmer
I would just use a delete query and have it run on a certain forms close event or the click of a button. much easier than VBA. Never ever, bloody anything, ever
![[upsidedown]](/data/assets/smilies/upsidedown.gif "[upsidedown] [upsidedown]")
?- Status
Similar threads
