using modules

[CesarAustin]

Ok. I’m sorry about this question.. I have been using access for a some time now… I can create all kinds of queries using the query design…. I can also understand the SQL behind it... I posted a question early this week about calculating business days between to dates. I found a module that I can use.. but I don’t know how to use it. Can some one direct me somewhere were I can learn how to apply the modules…. I have been searching the web and just can’t find anything I understand. Pls pls help.

 

[SydneyGeek]

Here's a quick overview.

1. Create a new module and paste the code that you found into it. You will have one or more Function procedures in the module. Save the module, but DON'T use the same name for the module as for the functions within module -- apparently Access doesn't like it. Now you'll have modMyModule, containing Function1, Function2, etc (being generic here).

2. To use the code, you call it from another routine in a module, from the event code for a button or other control, or via an expression in a query.

To call from another procedure in a standard module:
Call modMyModule.Function2

To trigger from a button:
Place the button on a form. Go to Design view, select the Properties for the button, click the Events tab. Double-click the blank line next to On Click. You'll see Event Procedure. Click the Builder (...) button and you'll be in the event modult for the form. Type
modMyModule.Function2

To use in an expression:
If your function is intended to return a calculated result, use it in a query as you would any other built-in function.

Hope that gets you started

Denis