I have a large SQL Server database that I access via MS Access. What I'd like to do is execute a stored procedure, passing parameters from a user form. Kinda like:
PARAMETERS Forms!Main!fromdate DateTime, forms!main!todate DateTime;
EXEC sp_Total_Time_For_Period @date1=forms!main!fromdate,@date2=forms!main!todate;
It seems like it ought to be possible but I haven't found any documentation to prove it... Clues anyone? If it isn't possible, please let me know too... ;-)
PARAMETERS Forms!Main!fromdate DateTime, forms!main!todate DateTime;
EXEC sp_Total_Time_For_Period @date1=forms!main!fromdate,@date2=forms!main!todate;
It seems like it ought to be possible but I haven't found any documentation to prove it... Clues anyone? If it isn't possible, please let me know too... ;-)