User Profile

Collapse

Profile Sidebar

Collapse
robertGreen613
robertGreen613
Last Activity: Oct 14 '07, 04:52 PM
Joined: Sep 12 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • robertGreen613
    replied to Error Executing Query
    in Visual Basic
    I fixed it already! Seems Access looks for ' ' around the values.

    i.e., this code worked
    "UPDATE [Contract Line Items] set CONTRACTNO = '" + tmpContractNo + "' where CONTRACTNO = '" + oldContractNo + "'"
    See more | Go to post

      Leave a comment:

    • robertGreen613
      started a topic Error Executing Query
      in Visual Basic

      Error Executing Query

      Hi All,

      I am trying to execute a query in my VB Code for this Access application. THe code i have is:

      Dim dbcon227 As Database
      Dim qryDeff As QueryDef
      Dim dbrs2, rs As Recordset
      Dim strSQL As String


      strSQL = "Update [Contract Line Items] set CONTRACTNO = tmpContractNo where CONTRACTNO = oldContractNo"
      ...
      See more | Go to post
      No activity results to display
      Show More
      Working...