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!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nobeltlp

    Force cell wrapping?

    Im new a ASP and HTML but I just got this APS page to do what I thnk you are trying to do. There are two sections. Using textarea I created a set width and a row limit, the formated var, str or Table cell will wrap the width and row limit. If not what you seek, sorry. I've been at this a...
  2. nobeltlp

    Update using inner joins and there tables

    If Im responding correctly. To: Ankor Yes, TBL-3 is tblRelationships, Sorry to All for that. To: jabrony76 Thank you for the proper inner join of the tables, I used you example and the update was correct. Query Analyzer is not my friend. Does it alway say this; "The Query Designer does not...
  3. nobeltlp

    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...
  4. nobeltlp

    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;"
  5. nobeltlp

    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...
  6. nobeltlp

    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...

Part and Inventory Search

Back
Top