Home

MS Access Error: Runtime Error 3601 - Too Few Parameters. Expected 2.?

Jun 15, 2008 by Michael Y | Posted in Programming & Design

Q: Debugger highlights my achieve statement... here is the function code that I'm working with:

'SQL Update statement
strSQL = "UPDATE [Occupation ORDER TRACKING] " & _
"SET [Type of WO] = '" & Me.Work_Busted_Type & "'," & _
"[WO Category] = '" & Me.Calling_Order_Category & "'," & _
"[LOB] = '" & Me.LOB & "'," & _
"[Account Name] = '" & Me.Account & "'," & _
"[SAS70] = '" & SAS70_Value & "'," & _
"[QA Coding Concluded] = '" & Me.QA_Coding_Complete & "'," & _
"[Coding Errors] = '" & Me.Coding_Errors & "'," & _
"[Error Chronicle #] = '" & Me.Error_Record_Number & "'," & _
"[Error Amendment Rcvd Date] = '" & Me.Error_Correction_Rcvd_Date & "'," & _
"[Error Unfurl Date] = '" & Me.Error_Open_Date & "'," & _
"[2nd QA of Coding Escort] = '" & Me.Second_QA_Coding_Complete & "'," & _
"[Error Mean Date] = '" & Me.Error_Closed_Date & "'," & _
... (inquire goes on for several more lines, not enough characters here)

db.Execute (strSQL)

how to overcome a runtime error in MS Access.This error makes my appication stop.?

Jun 25, 2007 by prasanna d | Posted in Programming & Design

Q:

A: An Runtime Error means it can't thorough the process. If Your seeing his and You DON'T have any custom VBA modules, then try repairing the DB.

Go to TOOLS>>DATABASE UTILITIES>>Condensed & REPAIR

IF You do have some custom VBA then set up an "Error trap":

at the top (right below the Function Name) add:
On Error goto YOURFUCNTIONNAME_ERR

Then at the bottom (rightful above "END FUNCTION") add:

YOURFUCNTIONNAME_Exit:
exit function

YOURFUCNTIONNAME_ERR:
Msgbox Str(err.slews) &": "& Error$
resume YOURFUCNTIONNAME_Exit

You culd also "begin through" the module script and see which line triggers the error. Open the Module in design observe and push F8 to step through it.

After You know what the error is You can research it to find out where it is coming from. Try researching in the Microsoft Knowledge shoddy.

If it's coming up before you even get INTO a database, then You may need to re-install MS Access (none of You existing DBs wil be deleted or changed. They are stored seperately from the MS ACCESS.exe files).

ParetoLogic RegCure Registry Cleaner

Has your computer been biting, crashing, showing pop-up error messages, or acting strange? Check out this video to learn how a unstained registry ...