Using a stored procedure as record source of a form - does this wo

D

Dave

I am converting to an ADP and I am trying to replace a sql statement in a
form record source with a stored procedure. I added the parameter needed by
the stored procedure to the Input Parameters. Everytime the form opens I get
an error. It is not a problem with the stored procedure because it runs fine
from SQL Mgmt console or from a VB.Net application, so this has to be yet
another peculiarity of Access. Here are the values of each property
Record Source: sp_Get_Physician_Data
Input Parameters: @PhysicianName string = g_PhysicianName

The global variable g_PhysicianName is defined as I verified that while in
debug mode right before the DoCmd.OpenForm. I have alos tried hard coding a
value in place of the global variable.

Can anyone tell me if this is really supported and if so perhaps show a
working sample/snippet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you call a stored procedure that returns a value? 3
How do you pass parameters to a stored procedure 2
Saving New record using Stored Procedure in Access 0
Making form based on stored procedure 0
Access Pass-Through To Oracle 10g Stored Procedure - Return Result 1
Problem generating report using stored procedure 1
Access ADP Form and Stored Procedure as RecordSource 0
Access ADP Form and Stored Procedure as RecordSource Options 2

Top