Runtime error 3061 too few parmeters - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Runtime error 3061 too few parmeters

Tim Rusk

2 years ago

I wrote the following VBA code

CurrentDb.Execute "INSERT INTO EmployeeXCourseT " & _
        "(EmployeeID, CourseID, EnrollmentDate, DeadlineDate, StatusID) " & _
        "VALUES (" & EmployeeID & ", " & MissingCourseList & ", #" & Date & "#, " & "# " & _
        Date + 30 & "#, 1)"

I keep on receiving this message, I tried to remove spaces but noting works

	Alex Hedley @Reply 2 years ago
Which message?

	Adam Schwanz @Reply 2 years ago
Your Problem is here. It's usually simpler to write these on one line, then you would probably catch the mistake. "# " & _ Date + 30 On one line that looks like "# Date + 30 & "#,1 Missing the & and " after the # symbol "#" & Date + 30 & "#,1

	Kevin Robertson @Reply 2 years ago
I tested the code as written above and it worked with no errors. It may be an incorrect data type. Or you may have made a mistake in one of the Queries that feeds the List Box. Too Few Parameters

Adam Schwanz @Reply

2 years ago

That & really works across two lines to concatenate the Date+30 as well? That's interesting.

I would still try to simplify the statement in one line, and remove the extra & "# " & and just put it in the string before it. See if this works

CurrentDb.Execute "INSERT INTO EmployeeXCourseT (EmployeeID, CourseID, EnrollmentDate, DeadlineDate, StatusID) VALUES (" & EmployeeID & ", " & MissingCourseList & ", #" & Date & "#,#" & Date + 30 & "#, 1)"

	Tim Rusk OP @Reply 2 years ago
Thank You everyone, I will try

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View