Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Parameters with DoCmd.OpenStoredProcedure
Thanks for your help mvpacc, I have looked at your web site and the code you mentioned is very helpful. I will need to revise my VBA code and make the necessary changes to use Temporary tables. It is a shame that Access does not cater for the ability to open a stored procedure with parameters...- Sid100
- Post #5
- Forum: Microsoft: Access Other topics
-
Parameters with DoCmd.OpenStoredProcedure
Thankyou for your response, how could I assign a global variable for @Get_Id in Access, because as far as I am aware @Get_Id has to be declared witin the stored procedure and not at global level. I look forward to your reply.- Sid100
- Post #3
- Forum: Microsoft: Access Other topics
-
Parameters with DoCmd.OpenStoredProcedure
I have a the following stored procedure: Alter Procedure GetResults @Get_Id INT As SELECT * FROM TBLSAMPLE WHERE ID =@Get_Id I am calling the stored procedure using the following: DoCmd.OpenStoredProcedure "GetResults", acViewNormal It is possible to call the stored procedure using...- Sid100
- Thread
- Replies: 4
- Forum: Microsoft: Access Other topics
