I have a SQL stored procedure which I would like to run through Access.
This procedure has a paramert.
I created a form and by clicking a buttom I want to run this procedure but before to be able to input the parametr as well.
I am not sure if there is any way I can do this in the Access interface or wherther I have to use VBA code(which I am not familiar with)
Thank you very much.
Regards.
Pete
Quote:
Originally Posted by petr_podskubka
Hi there
I have a SQL stored procedure which I would like to run through Access.
This procedure has a paramert.
I created a form and by clicking a buttom I want to run this procedure but before to be able to input the parametr as well.
I am not sure if there is any way I can do this in the Access interface or wherther I have to use VBA code(which I am not familiar with)
Thank you very much.
Regards.
Pete
I would like to know if you would have information I trying to find information on how can I have my SQL stored procedure through Access...
Thank you for helping
|||Quote:
Originally Posted by petr_podskubka
Hi there
I have a SQL stored procedure which I would like to run through Access.
This procedure has a paramert.
I created a form and by clicking a buttom I want to run this procedure but before to be able to input the parametr as well.
I am not sure if there is any way I can do this in the Access interface or wherther I have to use VBA code(which I am not familiar with)
Thank you very much.
Regards.
Pete
it will be a little bit of both...you need the VBA to establish connection and some setting. although there are objects that can handle some of these tasks, you still might need some VBA coding to handle some stuff, ie, error handling.
|||Try this:http://archives.postgresql.org/pgsq...05/msg01260.php
Basically what it does, it changes text of your query every time you pass parameters.
The best part it is ready to use you dont need to write it yourself.
Good Luck.
Irina.|||
Quote:
Originally Posted by petr_podskubka
Hi there
I have a SQL stored procedure which I would like to run through Access.
This procedure has a paramert.
I created a form and by clicking a buttom I want to run this procedure but before to be able to input the parametr as well.
I am not sure if there is any way I can do this in the Access interface or wherther I have to use VBA code(which I am not familiar with)
Thank you very much.
Regards.
Pete
Look at ADP files in Access stored procedures are exposed in the GUI interface along with views you enter paramters for the stored procedure via the Forms Inputparameters property of the form
Regards
Jim|||
Quote:
Originally Posted by Jim Doherty
Look at ADP files in Access stored procedures are exposed in the GUI interface along with views you enter paramters for the stored procedure via the Forms Inputparameters property of the form
Regards
Jim
As I understood this question it is a pass through query that runs on SQL Server side and not on Access side.
|||Quote:
Originally Posted by iburyak
As I understood this question it is a pass through query that runs on SQL Server side and not on Access side.
Hi Iburyak,
You're probably right of course and me way off the mark at the end of the day :)... but the poster simply mentioned 'Access' and my presumption is that they might not be aware that in Access .ADP files as distinct from mdb files were intended to work directly with SQL Server. The connection method is (universal data link) automated within the interface they might want to consider their options?
Regards
Jim
