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

    Creating field names from table values

    I can't think for you apoena... it was an example for you to build upon... :-)
  2. loveTech

    What is wrong with If Then Else Statement

    Hey james33, just a quick update... instead of setting the format to fixed set it to General number... :-)
  3. loveTech

    What is wrong with If Then Else Statement

    james33, You need to set your format to General Number. DOnt worry about the decimal palcement.. :-)
  4. loveTech

    Only 1 record per...

    if i am not mistaken... is it ok for it to have multiple identifiers?... but the dates should be the same for each of the identifier that are similar... Key Indentifier Date Information 1 2002 2/28/02 28th info 2 2002...
  5. loveTech

    Building a report from search results

    first thing you do is create a query that takes a field (e.g. 113B). then make a report based upon the query whenever the user previews the report, it will ask for the field, then... when the user clicks the button the report will be generated... email me if anything: larosema@acenturewilm.com
  6. loveTech

    IF, ELSE STATEMENT NOT WORKING

    try this If "field" = TUBE_NO Then notice i take the &&'s out...
  7. loveTech

    Creating field names from table values

    use an UPDATE STATEMENT UPDATE [tableWithCorrectFieldName] SET [tableWithCorrectFieldName].Field1 = [TableWithData.]Filed WHERE (([tableWithCorrectFieldName] = "Detroit");
  8. loveTech

    VB Code using ADO Returning Too Many Records

    RealQuiet, take the query you've created and turn it into a stored procedure, then use ADO to call the stored procedure... That should work
  9. loveTech

    How do I Wrap Long Lines of SQL??

    Stickarm, here you go strSQL = "select FIeld1, FIeld2, FIeld3,Field4 from SomeTable " strSQL = strSQL & "where FIeld1 like '%" & TheCriteria & "%' and " strSQL = strSQL & "FIeld2 like '%" & SecondCriteria & "%' and " strSQL = strSQL &...

Part and Inventory Search

Back
Top