J Joseph Meehan Jul 4, 2005 #2 Anakin said: How do I call a query by clicking on a button in a form? Thanks! Ron Click to expand... In design mode set the "On Click" property to open query.
Anakin said: How do I call a query by clicking on a button in a form? Thanks! Ron Click to expand... In design mode set the "On Click" property to open query.
V Van T. Dinh Jul 4, 2005 #3 Which kind of Query you want to "call"? A Select Query returns rows while an Action Query performs some action but does not return any row. Check Access VB Help on the OpenQuery Method of the DoCmd object.
Which kind of Query you want to "call"? A Select Query returns rows while an Action Query performs some action but does not return any row. Check Access VB Help on the OpenQuery Method of the DoCmd object.
G Guest Jul 5, 2005 #4 Thanks! I was just trying to open a standard query (not sure what other kinds of queries there are). DoCmd.OpenQuery "Query" works! Thanks again!
Thanks! I was just trying to open a standard query (not sure what other kinds of queries there are). DoCmd.OpenQuery "Query" works! Thanks again!
G Guest Jul 5, 2005 #5 Thanks! Van T. Dinh said: Which kind of Query you want to "call"? A Select Query returns rows while an Action Query performs some action but does not return any row. Check Access VB Help on the OpenQuery Method of the DoCmd object. Click to expand...
Thanks! Van T. Dinh said: Which kind of Query you want to "call"? A Select Query returns rows while an Action Query performs some action but does not return any row. Check Access VB Help on the OpenQuery Method of the DoCmd object. Click to expand...
