ADODC and MS Access with Parameters

Hi:
I'm currently modifying and old program. The database control and management were all using Early Binding with ADODC.

To modify all with ADO Object are monumental task!

So I'm asking FOR HELP! How can I do this:

ADODC.RECORDSOURCE=QUERY + parameter (---> MS Access Query at database with parameter)

How can i pass the parameter/s to the Query?

Thanks

Simon :confused:

I don't understand what you mean by "passing the parameters"... wouldn't those be included in the WHERE clause of your query? I need more specifics on what you are trying to accomplish.

Have a look at my signature, it includes a link for a tutorial on Adding records to a database, it includes using a parameter, you can use it as a guide.

Quote:

---

Originally Posted by simon ong

Hi:
I'm currently modifying and old program. The database control and management were all using Early Binding with ADODC.

To modify all with ADO Object are monumental task!

So I'm asking FOR HELP! How can I do this:

ADODC.RECORDSOURCE=QUERY + parameter (---> MS Access Query at database with parameter)

How can i pass the parameter/s to the Query?

Thanks

Simon :confused:

---

Did you mean you have the query already at MS-ACCESS ?
why don't you build the query with ADO Recordset code ? so you don't need to pass it the parameter to your MS-Access build-in query ?

Regards,
Willy