Re: Missing semicolon error???
- From: "Dale Fye" <dale.fye@xxxxxxxxxx>
- Date: Thu, 18 Sep 2008 21:32:55 -0400
Actually, I think your problem is that you are trying to open an action
query as a recordset. Unless this is actually a pass-thru query to SQL
Server, I don't think you really need the terminal semi-colon.
Replace:
set objRS = objDB.OpenRecordset(strSQL1)
with:
objDB.execute strSQL1
then delete the RS.Close and RS = Nothing statements.
HTH
Dale
"Al" <Al@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BC7706AB-6729-4FF4-93F2-B3AA5E614045@xxxxxxxxxxxxxxxx
I am trying to run an Insert query and keep getting a "Rub-time error
'3137':
Missing semicolon (;) at end of SQL stement. I haven not seen this error
before; however, I have a form event that triggers the following code to
run
(I populate the variables and have other code too, but this is where the
problem lies):
Dim strSQL1 As String
Dim objDB As DAO.Database
Dim objRS As DAO.Recordset
strSQL1 = "INSERT INTO StatusArchive([ID],[Priority],[Prev Activity],[Curr
Activity],[Plan
Activity],[Phase],[Percent],[BeginDate],[Code],[Rank],[Scolor]) Values ( "
&
PID & ",'" + CStr(Prty) + "','" + CStr(PrAct) + "','" + CStr(cAct) + "','"
+
CStr(PlAct) + "','" + CStr(Phas) + "'," + Pcent + ",'" +
CStr(FridayOfWeek) +
"','" + CStr(Cd) + "'," & Rnk & "," & sCol & ") Where [ID] = " & PID & ""
Set objDB = CurrentDb
Set objRS = objDB.OpenRecordset(strSQL1) 'IT ERRORS HERE
Call objRS.Close
Set objRS = Nothing
Set objDB = Nothing
This is what I see in debug (everything is getting populated fine):
"INSERT INTO StatusArchive([ID],[Priority],[Prev Activity],[Curr
Activity],[Plan
Activity],[Phase],[Percent],[BeginDate],[Code],[Rank],[Scolor]) Values (
1,'High','','Test Curr','Test Plan','Complete',1,'Friday, September 12,
2008','C',1,1) Where [ID] = 1"
Thanks in advance,
Al
.
- References:
- Missing semicolon error???
- From: Al
- Missing semicolon error???
- Prev by Date: Re: Iif not working for multiple options
- Next by Date: Re: Missing semicolon error???
- Previous by thread: Re: Missing semicolon error???
- Next by thread: Re: Missing semicolon error???
- Index(es):
Relevant Pages
|
