Posted By

martinbrait on 08/07/19


Tagged

list dao access queries


Versions (?)

[vba-access] liste des requêtes d'une base access


 / Published in: Visual Basic
 

List of access database queries

Pour tester, ouvre la fenêtre de Debug (CTRL G), et tapes-y 'ListeRequetes' et appuye sur la touche [Entrée].

  1. Sub ListeRequetes()
  2. Dim DaBase As DAO.Database
  3. Dim ReqD As DAO.QueryDef
  4.  
  5. Set DaBase = CurrentDb
  6. For Each ReqD In DaBase.QueryDefs
  7. Debug.Print ReqD.Name
  8. Next
  9.  
  10. Set DaBase = Nothing
  11. End Sub

Report this snippet  

You need to login to post a comment.