No value given for one or more required parameters error (Excel VBA)

Asked Nov 23 '22 at 19:10

Active Nov 23 '22 at 19:10

Viewed 44 times

I am creating a program which allows a user to extract student grades and other data for the students enrolled in a specified course. At the moment, I am trying to construct the SQL access statement but there appears to be an error that I am havng trouble disecting.

Additionally, it is important to note that the data is coming from 2 tables.

This is what I have so far. I tried adding brakets around the inner join, excluding the order by statement, and using the table names explicitly with the select statement and whatnot. Nothing has worked yet.

SQL = "SELECT G.course, G.A1, G.studentID, S.FirstName, S.LastName " _
        & "FROM grades G INNER JOIN students S ON G.studentID = S.studentID " _
        & "WHERE G.course =" & courseCode & " " _
        & "ORDER BY G.studentID"

This is what the database relatonships are if it helps.

asked Nov 23 '22 at 19:10

S P

have you a value for coursecode? – nbk Nov 23 '22 at 19:15
2

Is courseCode numeric? If not then you need single quotes around the value. – Tim Williams Nov 23 '22 at 19:19
courseCode is a string value structured as 2 letters followed by 3 numbers (ex.CP102) – S P Nov 23 '22 at 19:45
Then you need quotes – Tim Williams Nov 23 '22 at 19:52
1

I would encourage you to read the following [question about parametrizing commands](https://stackoverflow.com/q/49509615/8597922) - it would be best practice to use that approach instead of concatenation where possible. – Victor K Nov 23 '22 at 19:54
@TimWilliams Thank you very much, the quotes were indeed the problem – S P Nov 23 '22 at 20:04
@VictorK Will do! Thank you for the tip. – S P Nov 23 '22 at 20:06

No value given for one or more required parameters error (Excel VBA)

0 Answers0