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!
-
Opening a Stored Procedure
I am currently trying to open a stored procedure from a form in ADP. I can open the procedure with a command button using VB- easy. I however, get popup parameter message boxes...i would like to be able to directly transfer the parameters from the form to the stored procedure. I was wondering...- cschan80
- Thread
- Replies: 2
- Forum: Microsoft: Access Project (ADP)
-
Open a stored procedure in ADP w/ Form
Nevermind, figured it out...dumb question. for all those who need the code: Private Sub Command1_Click() On Error GoTo Err_Command1_Click Dim DocName As String Dim LinkCriteria As String DocName = "DeanProcedure" DoCmd.OpenStoredProcedure DocName, acViewNormal...- cschan80
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Open a stored procedure in ADP w/ Form
I am trying to open a stored procedure in ADP using a form. There is a button that I will use to open the stored procedure and I am using the following VBA behind it. It gives me an error...saying that the stored procedure is not found. DeanProcedure is the stored procedure that i am trying...- cschan80
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Variable Type - ADP
I am currently using SQL Server with an ADP frontend, and am trying to get a form to return values to a parameter query. There is some code already in place, and it looks solid. There were just some wrong variable definitions when dimensioning them. I have pasted the problem variable...- cschan80
- Thread
- Replies: 1
- Forum: Microsoft: Access Project (ADP)
