469,601 Members | 2,240 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,601 developers. It's quick & easy.

setting value to sql varialble thru access

Hi everyone
help me iam having a problem passing a value to an sql variable thru VBA.
I have a stored procedure

declare @rec
delete tablename where field1 = @rec

the variable is to get a value from an access form linked to another table.
the procedure is to be triggered by a button using the current record me!field as the value to be passed to the variable.
Aug 19 '07 #1
0 833

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

11 posts views Thread by ckerns | last post: by
1 post views Thread by Ben | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.