Need help on Stored Procedure

From: Sunny (sunny_1178_at_hotmail.com)
Date: 02/24/05 

Date: Thu, 24 Feb 2005 09:20:01 -0600

Can anyone give me sample code, how to call stored procedure from vba with
output and input parameter?

Thanks.

Relevant Pages

  • Re: Text Search in Access2003/SQL
    ... Bobby L. Childers II ... "David Lloyd" wrote: ... > If you are using a stored procedure, you can declare an input parameter ...
    (microsoft.public.access.queries)
  • Re: Output Parameter To Global Variable (DTS)
    ... >article and used the dummy code. ... >end of the stored procedure thereby having the SP return a result set. ... Sorry, I am at a loss, as the sample code I posted previously works fine ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals ...
    (microsoft.public.sqlserver.dts)
  • Re: Desparete for advice on stored proc from asp.net
    ... > I have no hairs left and what is has gone gray. ... > I have a datagrid page which allows the user to select certain records ... within my stored procedure that gets called the ... here is sample code ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Re: command object
    ... I find your code very confusing. ... Your stored procedure takes an input parameter and doesn't explicitly ... >iam wondering how come iam not able to display msgbox, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Input Parameter/Data Type conflict
    ... I did have the original input query as datatype ... I started the stored procedure within ... When prompted for the input parameter I entered ... the number 0.06 which produced an empty record set. ...
    (microsoft.public.access.queries)