Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Update using inner joins and there tables
Im very new on Sql server. Here are two examples that seem to both work but Im not to sure. Could someone evaluate these statements for me. I would be very appreciative for the help. Example1. this seems to update correctly Update TBL-1 Set TBL-1.txtName = TBL-2.txtName From TBL-2 INNER JOIN...- nobeltlp
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
Convert Access Update Code to Sql 2k.
This works in VB MSACCESS But I can not seem to correctly convert to SQL 2000. UPDATE tblCmsA INNER JOIN tblCmsB ON tblCmsA.ACNo = tblCmsB.ACNo SET tblCmsA.ACNo = tblCmsB.ACNo], tblCmsA.BCNo = tblCmsB.BCNo, tblCmsB.flag = '1', tblCmsA.Flag = 1;"- nobeltlp
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Select individual reports from .Reports
Is it possible to select a saved report from Containers.Reports.documents Using the following I can list the entire contents in a form list box, but there are only seven reports I want to list. Private Sub Form_Load() Dim MyRep As Document, Mydb As Database Set Mydb = CurrentDb...- nobeltlp
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Selecting individual saved reports.
Is it possible to select a saved report from Containers.Reports.documents Using the following I can list the entire contence in a form list box, but there are only seven reports I want to list. I have tried veriations of If and For each with Like "*.XXX", but I always recieve;"expression not...- nobeltlp
- Thread
- Replies: 1
- Forum: Microsoft: Access Reports
