How to open query in MS Access VBA

Use one from ….

DoCmd.OpenQuery "Q_run_payments", , acReadOnly
DoCmd.OpenQuery "yourQueryName", acViewNormal, acEdit
CurrentDb.OpenRecordset("yourQueryName")
CurrentDb.Execute "qryAddLoginfoRow"

 

You may also like...