Parameter Query Without Prompt Dialog

[Guest]

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 (e-mail address removed) if you can

 

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