Need help on Stored Procedure

24 Feb 2005 3:20 PM

Sunny

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

Thanks.

24 Feb 2005 4:59 PM

Lynn Trapp

Try here:

http://office.microsoft.com/en-us/templates/TC010185841033.aspx?CategoryID=CT011366681033

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Show quote

"Sunny" <sunny_1***@hotmail.com> wrote in message
news:uqMpYRoGFHA.3876@TK2MSFTNGP14.phx.gbl...
> Can anyone give me sample code, how to call stored procedure from vba with
> output and input parameter?
>
> Thanks.
>
>

24 Feb 2005 5:08 PM

Lynn Trapp

Sunny,
Please ignore my previous reply. It was meant for another thread.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Show quote

"Sunny" <sunny_1***@hotmail.com> wrote in message
news:uqMpYRoGFHA.3876@TK2MSFTNGP14.phx.gbl...
> Can anyone give me sample code, how to call stored procedure from vba with
> output and input parameter?
>
> Thanks.
>
>