Prompt stored procedure

[tlindeman]

Could you please tell me if there is a way in access to prompt for dates in a SQL stored procedure? Maybe in VBA? This is all I have right now:

exec uspScorecardSSSDetailAllStoresNet3 '9/03/2012','09/09/2012'

Thank you
Tony

 

[Galaxiom]

Not directly.

Ppass the parameters to the stored procedure. I do this by executing an ADO command with the parameters appended.