Good Day..
I have a small problem in vb6 ...
I Programed a program that use Ado to read and write to DataBase(Access97)..In the base
there are 4 tables(A-B-C-D)..and have the same Fields I want The code to Move From The
table A (for example) to table B or C..That the the names appeares in the same TextBoxes.
And Thank you(Please in hurry Because the code not for me...)
Notic: I used the Wizard Not code connection..
That some of failed tries:
Text5.Text = Adodc1.RecordSource
Adodc1.RecordSource = Adodc1.RecordSource + 1
Selly ,Is n't it ^.^I prefer VB.Net
How to Move from a tabel to another (VB6-Ado)
wapmill
pdinesh
An ADODC control just handles 1 table or recordset. If you want the contents of your ADODC to be displayed in the textbox you should do this:
Text1.DataSource = Adodc1
Text1.DataMember = "FieldName"
Just change the datasource of your text if you want to move to another table. And if my memory serves me right there's a movenext method in the ADODC control. Just look it up on MSDN.
BTW, this forum only discusses .Net specific products such as VB 8. questions regarding VB6 should be posted in Microsoft Newsgroups.
cheers,
Paul June A. Domag