Running Access Query from Visual Basic with parameter

[BigJimSlade]

Hi, Big Jim here:

I am running an Access query from Visual Basic (not VBA)...the query has a user defined parameter in it.

However, when the query runs in VB, the Access window does not notify the user to switch to Access to enter the parameter. Is there anyway to force the Access parameter box to pop up in Visual Basic?

Please let Big Jim know if he is not being clear enough on the problem. Thanks in advance!

Big Jim

 

[dcx693]

I'd guess that you're going to run into the same problem using VB as you would with VBA - you need to specify the parameters for your query before you run them. This article might help: Open Parameter queries from code

 

[BigJimSlade]

Thanks dcx693

The number of parameters will vary from query to query with hundreds of variations. Is there a way to do this without having to write out each possible parameter?

Thanks again,

Big Jim