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!

Register Log in
  • Congratulations Chriss 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: *

  1. wakgtech

    Calling a stored procedure with a parameter.

    THAT IT IT!!!!!!!!!!!! How could i have been so blind??!!! Thank you thank you! This is cool stuff, I will use this all the time now! Thanks again!
  2. wakgtech

    Calling a stored procedure with a parameter.

    ..or maybe I am looking at this all wrong (sorry, sp is very new to me) after retreiving the cnrecordset, how do I view the results? I have tried a message box, (msgbox cnRecordset(it should only retreive 1 field of 1 record)) but that is when we get the message. If i do this "msgbox err.number"...
  3. wakgtech

    Calling a stored procedure with a parameter.

    myValue = "391" strCS = "Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Office ContributionSQL;Data Source=ADMPCLKVCGR0\SQLEXPRESS" Set cn = CreateObject("ADODB.Connection") cn.Open strCS Set cnCmd = CreateObject("ADODB.Command") cnCmd.ActiveConnection...
  4. wakgtech

    Viewing the Modules in MS Access

    Greetings all, I have created a MS Access file that is linked to a SQL on the backend that I made by using the upsizing wizard. It creates some modules that I would like to view,but when I go to open the module, I get a message that tells me the project is un viewable. I have went to the MSDN...
  5. wakgtech

    Calling a stored procedure with a parameter.

    Thanks for the assistance all! I think I am getting somewhere. I created the ADO command object and I can connect and pass the value into the sp. However I am now getting the "type-mismatch" error when I run the procedure. I know that the sp's parameter is set to "varchar(5)" and it works from...
  6. wakgtech

    Calling a stored procedure with a parameter.

    //create a pass through qurey Pwise, I tried that and it did not work. dhookom, do I need to use anything else with that DAO? Other statements? Or would that line be all that I need?
  7. wakgtech

    Calling a stored procedure with a parameter.

    getValues(08322) getValues('08322') getValues 08322 getValues(myVar)
  8. wakgtech

    Calling a stored procedure with a parameter.

    I have a stored proc in SQL express: ALTER PROCEDURE [dbo].[getValues] @atty_no char(5) AS SELECT (attorney_no) FROM TBL1 WHERE attorney_no = @atty_no I want to call that SP from MS Access and assign a value to the parameter. how would I go about that? Everything I have tried so far has...

Part and Inventory Search

Back
Top