Parameter Query Without Prompt Dialog

D

DAWIA

hello,

SQL server has stored procedure so we can pass variables (parameters) into
it.

An access beginner, i'v read ACCESS documentation, nocticing that it has
PARAMETER QUERY - it looks basically like a SQL stored procedure. However it
prompting a dialong box to enter the Data. IS THERE A WAY to write a ACCESS
PARAMEER QUEURY passing the data in WITHOUR PROMPTING FO A DIALOG

Thanks
please CC a copy to [email protected] if you can
 
V

Van T. Dinh

You can use code to resolve the Parameter values for JET by using the
Parameters Collection of the QueryDef Object which is the Query in code.

Check Access VB Help on the QueryDef Object and its Parameters Collection.
 
Top