G
Guest
Hi
I am aware that one can run an SQL Server stored proc from Access and return
records and even pass in parameters to the stored proc to get the desired
result. At the moment I am doing this with a "Pass-through" query with
Hard-Coded parameters.
What I want to do however is have the parameter that is passed in to the
stored proc from access created dynamically from a form in Access.
eg.
exec spr_my_report [forms]![frmeomreports]![statementnumber]
instead of
exec spr_my_report 55
Or equivalent, any ideas?
Thanks,
Jesse
I am aware that one can run an SQL Server stored proc from Access and return
records and even pass in parameters to the stored proc to get the desired
result. At the moment I am doing this with a "Pass-through" query with
Hard-Coded parameters.
What I want to do however is have the parameter that is passed in to the
stored proc from access created dynamically from a form in Access.
eg.
exec spr_my_report [forms]![frmeomreports]![statementnumber]
instead of
exec spr_my_report 55
Or equivalent, any ideas?
Thanks,
Jesse