u3kim
asked on
Using ADODC1 Control in VB6
Guys,
I wants to add a ADODC1 Control to my form and Assign the Connection and Recordset Property throught Coding.
After that i wants to Assign that Current Record set to One more new Recordset. So that i can populate that record in some fileds. (please not i dont wants to assign that directly to the controls thro ADODC control. becase using the values i need to get some more records for that).
Each click in ADODC1 movenext or movelast.... i need that values in TEMP RECORDSET.
So that i can using that Temp recordset i can do the next steps.
Please if you any one have idea for this?
I wants to add a ADODC1 Control to my form and Assign the Connection and Recordset Property throught Coding.
After that i wants to Assign that Current Record set to One more new Recordset. So that i can populate that record in some fileds. (please not i dont wants to assign that directly to the controls thro ADODC control. becase using the values i need to get some more records for that).
Each click in ADODC1 movenext or movelast.... i need that values in TEMP RECORDSET.
So that i can using that Temp recordset i can do the next steps.
Please if you any one have idea for this?
ASKER
Hi
This method is not working.
please note this
**************************
After that i wants to Assign that Current Record set to One more new Recordset. So that i can populate that record in some fileds. (please not i dont wants to assign that directly to the controls thro ADODC control. becase using the values i need to get some more records for that).
"Each click in ADODC1 movenext or movelast.... i need that values in TEMP RECORDSET.
So that i can using that Temp recordset i can do the next steps."
**************************
but now i added a textbox and asssign the value to that and each time the Text Field Change Event i am executing the other values.
This method is not working.
please note this
**************************
After that i wants to Assign that Current Record set to One more new Recordset. So that i can populate that record in some fileds. (please not i dont wants to assign that directly to the controls thro ADODC control. becase using the values i need to get some more records for that).
"Each click in ADODC1 movenext or movelast.... i need that values in TEMP RECORDSET.
So that i can using that Temp recordset i can do the next steps."
**************************
but now i added a textbox and asssign the value to that and each time the Text Field Change Event i am executing the other values.
I don't mind, but I would like to get my two cents in on this one. If it didn't work, then let me know, and I can propose new or different techniques to solve your problem. Abandoned questions get on my nerves, when I discover that someone didn't give me a chance to help.
Thanks,
Bob
Thanks,
Bob
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Me.Adodc1.RecordSource = "Table1"
Me.Adodc1.Refresh
MsgBox "Test = " & Me.Adodc1.Recordset!Test