How to call a procedure from a module in Access 2010..???

kbsudhir

Sudhir
Local time
Tomorrow, 02:38
Joined
Dec 27, 2007
Messages
20
Hi All,

I have create procedure called "Test" in Access 2010. I want to call this procedure in a button click & also when the form loads.

But the problem is Access 2010 is only allowing me to select from the existing list of macros which is available by default. :mad::mad:

I have created a web database.


Please let me know to overcome this.

Regards
Sudhir
 
Sudhir, Have you considered using VBA instead of Macros?? To call procedure using Macros, you have to use the "RunCode"..

attachment.php
 

Attachments

  • macro.png
    macro.png
    4.8 KB · Views: 905
... note the procedure has to be a Function not a Sub to call it via the RunCode macro option.
 
Hi,

Thanks pr2-eugin & nanscombe.

But, I am not getting Runcode option in the list of macros.


Please guide.

Regards
Sudhir
 
I have created a web database.

If you want to call and use code, you can't use WEB-forms, only in client-forms is code availible, sorry

JR
 

Users who are viewing this thread

Back
Top Bottom