Hyperlinks to stored procedures

  • Thread starter Thread starter Dennis
  • Start date Start date
D

Dennis

To create a hyperlink to an Access object like a table,
the subaddress would be "table xxx" for the table
named "xxx". What do I use to access a stored procedure in
a module?

I have tried subaddress ...
"storedprocedure xxx"
"storedprocedure mymodule!xxx"
"storedprocedure mymodule.xxx:
"function xxx"
and others.
 
Hi Dennis,

Do you mean you want to execute stored procedure in modules by code? If so,
we can try DAO, the following article provides a sample.
Note: it is in VB6 code, however, it is similar in Access.

HOWTO: Call Stored Procedures Using Data Access Objects
http://support.microsoft.com/?id=184749

Please feel free reply to the threads if you have any concerns or questions.



Sincerely,

Alick Ye, MCSD
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.



--------------------
| Content-Class: urn:content-classes:message
| From: "Dennis" <[email protected]>
| NNTP-Posting-Host: TK2MSFTNGXS01 10.40.2.125
| X-Tomcat-NG: microsoft.public.access.modulesdaovba
|
| To create a hyperlink to an Access object like a table,
| the subaddress would be "table xxx" for the table
| named "xxx". What do I use to access a stored procedure in
| a module?
|
| I have tried subaddress ...
| "storedprocedure xxx"
| "storedprocedure mymodule!xxx"
| "storedprocedure mymodule.xxx:
| "function xxx"
| and others.
|
 
Back
Top