ADO question

[cwassel]

I am trying to write some ADO statements to enter a sum from a query in a report footer section. My ADO statements open the query as the recordset, then assign the sum to a textbox. The query, however, requires two parameters, beginDate and endDate. I am having trouble using this query in my report because i can not figure out how to enter the parameters in my ADO statements. Is there any way to write an ADO statement that opens a recordset and prompts for parameters? Or is there a way to pass the parameters when opening the recordset? Thanks for the help!

 

[PHV]

Take a look at the Parameters collection of the ADODB.Command object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[MarQ]

can anyone help me how to save in an access databse from a vb application using arrays of textbox so that if it is in an array textboxes the code would probably be shorter and faster in saving going to the database..maybe just by using Lbound and Ubound..hope i am right..thank you very much in advance and more power