Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2005
    Posts
    16

    sql in vb variables

    I have the following string in vb



    strSQL = "SELECT Torque1 FROM WHERE [Torque(3Shaft,1FPM,2lb)] = '" & str & "';"

    I want to extract the speicfy Torque1 field and store in a varaible. can anyone tell me how to do this. Thanks
    Emily

  2. #2
    Join Date
    Dec 2005
    Posts
    16
    well..that sql statement isn't correct, but bascially I just want torque1 stored ina variable...

  3. #3
    Join Date
    Dec 2005
    Posts
    16
    I was able to do it with DOA, but there has to be a way without opening record sets.

  4. #4
    Join Date
    Sep 2005
    Posts
    5
    Try
    DLookUp

    /Bengt

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Shell with Batch Variables
    By robbyaube in forum Programming
    Replies: 2
    Last Post: 12-19-2019, 11:06 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums