Search results

  1. A

    Appending in an Update query

    I found the solution myself. For anyone who is interested: DoCmd.RunSQL "UPDATE tblFileNotes SET fldActivitesUndertaken = fldActivitesUndertaken & '" & Me.fldClientFirstName & ", " & Me.fldClientLastName & ": ' WHERE fldClientID = " & Me.fldClientID
  2. A

    Appending in an Update query

    I am trying to do something that seemed quite simple at first but that doesn't appear to be working. I am trying to append text in an update query. DoCmd.RunSQL "UPDATE tblFileNotes SET fldActivitesUndertaken ='" & Me.fldClientFirstName & ", " & Me.fldClientLastName & ": " &...
  3. A

    Question Limiting a list in a continuous form

    I am currently trying to limit a list on a continuous form so that it is impossible to enter values that have already been entered. The list is the query value of a combo box placed on the continuous form itself. The combo box is bound to a form and I am trying to query to see if a value has...
Top Bottom