i want to copy the "current record" in adodc1 to adodc2.
how can i do that ?
I also want to add the "current record" in adodc2 to a datareport.
how can i do that ?
please help
i want to copy the "current record" in adodc1 to adodc2.
how can i do that ?
I also want to add the "current record" in adodc2 to a datareport.
how can i do that ?
please help
Assuming the two controls are accessing different tables that are identical and the column names are known, the procedure would be something like this:
create a new blank record in adodc2
adodc2.Items("column1") = adodc1.Items("column1")
adodc2.Items("column2") = adodc1.Items("column2")
.....
etc.
.
PC - Ubuntu 15.04 64bit Desktop
HP Pav G60-236US 3GB RAM Laptop, Ubuntu 15.04 64bit and Win7 Home
"So Daddy, how come you telling me stealing not right when YOU copying DVDs? How come? How Come?"
RIP Ramesh ...
i am having a problem with the ".items" part , it is not working.
the thing is to copy the current record in adodc1 to adodc2.
can i use this " adodc2.recordset.fields = adodc1.recordset.fields"
or is there another way please help me out
I could be wrong...it's a long time since I've done it, so perhaps the .fields("<column1.name>") may be the way to go.Originally Posted by Dj Still
.
PC - Ubuntu 15.04 64bit Desktop
HP Pav G60-236US 3GB RAM Laptop, Ubuntu 15.04 64bit and Win7 Home
"So Daddy, how come you telling me stealing not right when YOU copying DVDs? How come? How Come?"
RIP Ramesh ...
how can i use Sql to select the Current record in a database form adodc1 and then add it to adodc2. ?
can this work
search_text2 = txtname.Text
SQL = "Select * From tran Where [" & field & "] Like '%" & search_text2 & "%' "
Adodc1.RecordSource = SQL
Adodc1.Refresh
Adodc2.RecordSource = SQL
Adodc2.Refresh