VBA Codes + Passing a parameter

(0) Share

Report

Posted on by Romryan

Dear All,

I would like to feed my stored procedure with a parameter (voucher number) from VBA window through a combo box. This parameter is required severally through my stored procedure during execution.

I have already selected all voucher numbers I need on a combo box. Now I need to a solution whereby if select a voucher number from my combo list and click a button, the voucher selected will be passed to stored procedure as stored procedure culminates its execution.

Any suggestions. I will be very grateful.

RomRyan

*This post is locked for comments

All responses (2)

Answers (1)

Romryan on at

Like (1)

Report

RE: VBA Codes + Passing a parameter

Thanks Mick, this really helped. You nailed it.
Verified answer

Mick Egan 3,561 on at

Like (0)

Report

RE: VBA Codes + Passing a parameter

Assume you can setup VBA with the connections, but would look something like:

Dim StrVoucher as String

StrVoucher = Trim(Me.Voucher)

cmd.CommandText = "exec VoucherStoredProcedure '" & StrVoucher & "' "

cmd.Execute

Mick