SQL Newbie - stored procedure

• Michael Graves

  Old Hand

  Points: 305

  More actions

  May 31, 2005 at 5:27 am

  #362748

  I'm running a access 2000 adp front end working from  a SQL2000 database. I've got a sproc P_insertsessions i can get this work from a cmd button on a form but i'm having problems setting the paramerters i want it to use controls on the form.

  @contractid = contractid

  @start_date = startdate

  @end_date = enddate

  @hours = duration

  Can anyone help.

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  May 31, 2005 at 5:36 am

  #561846

  Is this related to this question?

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=185868

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]