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?




u3kimAsked:
Who is Participating?
 
NetminderCommented:
TheLearnedOne,

Your objection is noted, and well-taken, I hope, by the person who asked this question.

Points (250) refunded, but question not deleted; instead, I've closed it.

Netminder
EE Admin
0
 
Bob LearnedCommented:
Me.Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Temp\db1.mdb;Persist Security Info=False"
Me.Adodc1.RecordSource = "Table1"
Me.Adodc1.Refresh
   
MsgBox "Test = " & Me.Adodc1.Recordset!Test
0
 
u3kimAuthor Commented:
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.
0
 
Bob LearnedCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.