Re: same insert into problem
- From: "Dirk Goldgar" <dg@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 20 Sep 2006 11:50:22 -0400
"Bongard" <b.bomgren@xxxxxxxxx> wrote in message
news:1158765849.557585.144350@xxxxxxxxxxxxxxxxxxxxxxxxxxx
The new error, when I click debug, does not point there anymore it now
points to (or makes yellow) the line with the insert into statement.
strsql = "Insert Into [tbl_Transactions] ([Loan Number], [Notes]) " &
"Values(" & [Loan Number] & "," & Chr(34) & Replace([LoanNotes],
Chr(34), Chr(34) & Chr(34)) & Chr(34) & ")"
Was that statement originally all on one line, or was it broken onto
three lines the way I see it in your post? If you had it on three lines
in your original code, you need to include the line continuation
characters, as I originally posted it. Did you try copying and pasting
exactly this:
strsql = _
"Insert Into [tbl_Transactions] ([Loan Number], [Notes]) " & _
"Values(" & [Loan Number] & "," & _
Chr(34) & _
Replace([LoanNotes], Chr(34), Chr(34) & Chr(34)) & _
Chr(34) & ")"
into your code?
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
.
- Follow-Ups:
- Re: same insert into problem
- From: Bongard
- Re: same insert into problem
- References:
- same insert into problem
- From: Bongard
- Re: same insert into problem
- From: Dirk Goldgar
- Re: same insert into problem
- From: Bongard
- Re: same insert into problem
- From: Dirk Goldgar
- Re: same insert into problem
- From: Bongard
- same insert into problem
- Prev by Date: Re: New Record On Open
- Next by Date: Re: Mainform / subform / popup form
- Previous by thread: Re: same insert into problem
- Next by thread: Re: same insert into problem
- Index(es):
Relevant Pages
|
