Re: Problem updating memo field with string data from form

sara <saraqpost@xxxxxxxxx> wrote in
news:1184599230.171623.54830@xxxxxxxxxxxxxxxxxxxxxxxxxxx:


Bob -
Thanks for the response.

I did what you said and still get the "type Mismatch" error.

Im just wondering if the syntax of the Update section of the SQL
is wrong but throwing up the wrong message.


anyway, to debug this, first put some additional formatting into
the SQL statement

strSQL = "UPDATE tblInteractionHistory " & vbNewLine _
& "SET tblInteractionHistory.Notes = " & vbNewLine _
& strPresProblem & vbNewLine _
& " WHERE tblInteractionHistory.InteractionKey = " _
& lngInteractionKey & ";"

debug.print strSQL

Docmd.RunSQL strSQL

Run the code. Opem the immediate window {ctrl-G} key
Examine the actual sql that's being passed to the runSQL
statement. Maybe we can see the problem.



I still may be "working too hard" (I'm fairly inexperienced,
so I hear that rather often!), but let me explain what's
happening on this one.


[snipped]


Make sense? (This organization is so amazing - providing
services for people many would soon forget or wish would go
away, that I am trying to do everything I can so that their
money goes where it's needed most).

Long explanation! Many thanks -
Sara





--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

.

Relevant Pages

  • Re: SQL string problem
    ... clean up your parameters before sending them to SQL. ... > You must "escape" any single quotes when sending SQL statements ... > Just pass your SQL statement through this function when opening your ... >> Here is the full SQL statement that is assigned to the strSQL ...
    (microsoft.public.excel.programming)
  • Re: SQL string problem
    ... You must "escape" any single quotes when sending SQL statements directly to ... Just pass your SQL statement through this function when opening your ... > Here is the full SQL statement that is assigned to the strSQL ...
    (microsoft.public.excel.programming)
  • Re: Run-time error 3709
    ... Hi Fox ... dim strSQL as string ... CTRL-G to Goto the debuG window -- look at the SQL statement ...
    (microsoft.public.access.modulesdaovba)
  • Re: SQL TOP question
    ... Therefore you will need to generate the SQL statement dynamically. ... Assuming you have created a query named Query1 that contains the right syntax, switch it to SQL View. ... Dim strSql As String ... we base the team award on the top 3 scores. ...
    (microsoft.public.access.queries)
  • Re: Fraud Number Null:
    ... SQL Logical Table are multidimensional ... I used premise and axiom synonymously as a statement ... If Bob is credible and wrong, ... BB has no credibility ...
    (comp.databases.theory)
Loading