|
3
results for
InputParameters.
|
Accessing Stored Procedure via VBA
recordsource = sql Or you can use the inputparameters property to define each
parameters. For the EXEC statement, you don't need to refresh or requery the
form after changing the record source as this is done automatically. For complex
cases, using the uniquetable and the resynccommand will help you. ...
Feb 5 by Sylvain Lafontaine
- 5 messages - 3 authors
|
remove a message
openform "p1" on error resume next p1 is a form built on that stored procedure
and when it opens it opens in hidden view and the input parameter for the p1
form is @inv_seq varchar(50)=forms!sale_frm_check!inv_seq plaese any ideas best
regards sylvain lafontaine wrote: not the code for the stored procedure, ...
Jan 18 by Sylvain Lafontaine
- 18 messages - 4 authors
|
remove a message
openform "p1" on error resume next p1 is a form built on that stored procedure
and when it opens it opens in hidden view and the input parameter for the p1
form is @inv_seq varchar(50)=forms!sale_frm_check!inv_seq sylvain lafontaine
wrote: not the code for the stored procedure, the vba code or whatever else you
are ...
Jan 18 by ashraf_al_ani via AccessMonster.com
- 18 messages - 4 authors
|
The ordering of results sorted by date is approximate.
|
|
|
