Search results for query: *

Thanks for your input. Eric

Good day all, I have recently installed sql 2005. when running access 2003 I get the following error messages. Anybody got a clue how to solve these?? Thank for your troubles. "This version of MS Access doesn't support design changes with the version os SQL you are connected to." "New...

Good day all, I have recently installed sql 2005. when running access 2003 I get the following error messages. Anybody got a clue how to solve these?? Thank for your troubles. "This version of MS Access doesn't support design changes with the version os SQL you are connected to." "New...

I am still not getting output. Also I would like to use the stored procedure as rowsource in a combobox. How do i go about that? thanks for your input. Eric

this is SP_TravelRate SELECT TravelRate_Km FROM dbo.TblProject_Crewing WHERE (Employee_ID = @EMPLOYEE_ID) AND (Proj_ID = @PROJECT_ID) When adjusting VBA to just .Parameters("@PROJECT_ID") = Forms!frmwork_entry.SubFrmWork.Form!Proj_ID I get error message Item cannot be found...

Thanks for your input crowley, I have adjusted like this .Parameters.Append .CreateParameter("@PROJECT_ID", adInteger, adParamInput) .Parameters("@PROJECT_ID") = Forms!frmwork_entry.SubFrmWork.Form!Proj_ID when in debugging mode it shows a value, but a still get same error message...

I have a Stored Proc which works when run directly, but when trying to run through form I get error message. Does anybody have a suggestion?? Thanks a lot Eric With cmd .ActiveConnection = cnn .CommandText = "dbo.SP_TravelRate" .CommandType = adCmdStoredProc .Parameters.Append...

Thanks for your input, I have declared input parameters like that, but after running the stored procedure they are no longer in the properties box. Leading possibly to the error message Any additional ideas? Thanks Eric

I have a report it's recordsource links to as SP. To pass 3 variables I use a form to select the criteria. When passing criteria manually to the SP it runs OK. However when it's supposed to open the report with the required records it stays blank and I get the following error message "Must pass...