Post reply

passing parameter to stored procedure via a form

  • February 18, 2015 at 3:24 am

    #74392

    Hi

    I have an access .adp project and have a stored procedure created in sql server, I wanted to know if its possible to have an access form that takes input and when a button is clicked this runs the stored procedure where the parameter value required is what the user has input into the form and this generates a report.

    Thanks

  • February 18, 2015 at 6:56 am

    #1778328

    See if this helps:

    http://www.databasejournal.com/features/msaccess/article.php/3407531/How-to-Execute-SQL-Stored-Procedures-from-Microsoft-Access.htm

    Rob

  • February 18, 2015 at 10:39 am

    #1778421

    Because you are working with an ADP Access project, you will need to use a different approach than if you were working with a .MDB or .ACCDB format front-end to SQL Server. The details are beyond what can be put in a single thread easily, but check the link parameters from ADP form to stored procedure and the link referenced in that link for two different ways of doing what you are attempting.

    However you should also be aware of the fact that the .ADP format is no longer supported in the current (2013) version of Access, and will not be in future versions. So you might want to consider switching to the .MDB or .ACCDB format, especially if you are at the novice stage with Access. In that case the article by Danny Lesandrini referenced in Rob Taylor's post would be quite useful.

    Wendell
    Colorful Colorado
    You can't see the view if you don't climb the mountain!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply