SQL error

[Bill]

With strSession, strYear, intMtgNo, strTopic and strChariman
having been set in code, the following SQL statement is created.
I don't see what's causing the 3061 run-time error.


strSQL = "INSERT INTO TopicHist(Session, Year, MtgNo, Topic,
Chairman)"
strSQL = strSQL & " Values(" & strSession & ", " & strYear & ",
" & intMtgNo & ", "
strSQL = strSQL & """" & strTopic & """, " & """" & strChairman
& """);"

Debug.Print strSQL

CurrentDb.Execute strSQL

Run-time Error: '3061';
Too few parameters. Expected 1.

There are 5 variables and 5 values! What's missing?


Immediate Window:
INSERT INTO TopicHist(Session, Year, MtgNo, Topic, Chairman)
Values(April, 1975, 1, "Direction And Responsibilities", "Jack Lane");

 

[Dirk Goldgar]

With strSession, strYear, intMtgNo, strTopic and strChariman
having been set in code, the following SQL statement is created.
I don't see what's causing the 3061 run-time error.


strSQL = "INSERT INTO TopicHist(Session, Year, MtgNo,
Topic, Chairman)"
strSQL = strSQL & " Values(" & strSession & ", " &
strYear & ", " & intMtgNo & ", "
strSQL = strSQL & """" & strTopic & """, " & """" &
strChairman & """);"

Debug.Print strSQL

CurrentDb.Execute strSQL

Run-time Error: '3061';
Too few parameters. Expected 1.

There are 5 variables and 5 values! What's missing?


Immediate Window:
INSERT INTO TopicHist(Session, Year, MtgNo, Topic, Chairman)
Values(April, 1975, 1, "Direction And Responsibilities", "Jack Lane");

April is a string value, so it should be enclosed in quote like
"Direction And Responsibilities" and "Jack Lane".

 

[Bill]

Thanks, I'll fix it in the AM.
Bill

April is a string value, so it should be enclosed in quote like
"Direction And Responsibilities" and "Jack Lane".

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)