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


/ Published in: Visual Basic
Save to your folder(s)

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].


Copy this code and paste it in your HTML
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.