Advanced Search

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

Expand | Embed | Plain Text

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.