how VB update Table A INNER JOIN Table B, Set A.co=B.ID
Doug,
This person multiposted this response to the WORLD and expects answers to be
e-mailed. They are not ever going to see your post, most likely.
--
MichKa
Michael Kaplan
(principal developer of the MSLU)
Trigeminal Software, Inc. -- http://www.trigeminal.com/
the book -- http://www.i18nWithVB.com/
Quote:
> Hi Yuli,
> This ng is really for visual basic for applications as it pertains to
> Microsoft Word. You will be more likely to obtain the help that you are
> seek if you post to one of the Access newsgroups on msnews.microsoft.com.
> Please post any response to the newsgroups for the benefit of others who
may
> also be following the thread.
> Hope this helps,
> Doug Robbins - Word MVP
> > How vb update a table when this table inner join table b
> > Table A and Table B are in Different Access Database file.
> > table A.Co = Table B.ID, Set Table A.Remark = New
> > Private Sub Form_Load()
> > conString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path &
_
> > "\A.mdb;Persist Security Info=False"
> > Set objRe = New ADODB.Recordset
> > conString1 = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path
&
> _
> > "\B.mdb;Persist Security Info=False"
> > Set objUpd = New ADODB.Recordset
> > End Sub
> > -------------------------------------------------
> > Private Sub UpdateDB_Click()
> > With objUpd
> > If .State = adStateOpen Then .Close
> > .ActiveConnection = conString1
> > .Source = "UPDATE A INNER JOIN B ON A.co = B.id SET A.remark = "new"
> > .Open
> > End With
> > End Sub
> > thank you
