Error -2147217900

This topic is locked

Error -2147217900	9/15/2006 4:48:43 PM
ASPRunnerPro General questions
C chris author I have sent you an email with my zipped files. The text of the error screen is below. Technical information Error number -2147217900 Error description [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '[EmployeeID] ='. URL /Time_Card_Expenses_add.asp SQL query select [TimeCardExpenseID], [TimeCardID], [ExpenseDate], [ProjectID], [ExpenseDescription], [ExpenseAmount], [ExpenseCodeID], [ClientID], [EmployeeID], [ReceiptAttachment] From [Time Card Expenses] where (1=0) Additional info Event: RetVal = BeforeAdd(dict) Thanks for any help. Chris.


	Sergey Kornilov admin 9/18/2006
	Chris, answered to your personal email, CCing here: you have a custom BeforeAdd Event which breaks if EmployeeID field was left empty on the Add page. Probably you can make this field required.