Parameter Query Without Prompt Dialog

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Select Query Prompting for NonExistent Parameter 8
parameter passthrough query 1
Pass thru query to SQL server with parameters 3
Parameter query prompts twice 2
Update Query: Enter Parameter Value 2
query parameters 2
Access pass-through query to Oracle 10g stored procedure - results 1
Pass a parameter to a stored procedure from ms access 2

Back
Top