Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: EMEP
  • Order by date
  1. EMEP

    Access 2003 and sql 2005

    Thanks for your input. Eric
  2. EMEP

    Access 2003 and sql 2005

    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...
  3. EMEP

    Parameter query and GetDate() problems

    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...
  4. EMEP

    SP and forms

    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
  5. EMEP

    SP and forms

    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...
  6. EMEP

    SP and forms

    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...
  7. EMEP

    SP and forms

    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...
  8. EMEP

    Error on SP as recordsource

    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
  9. EMEP

    Error on SP as recordsource

    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...

Part and Inventory Search

Back
Top