• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Running a Custom Function

Once you've completed a custom function, you can use it in any Access query, report, or form. The easiest way to access the function is through the Expression Builder. After you open the Expression Builder, you can access the custom function using the Functions folder.

Run a Custom Function

Open Expression Builder from any query, report, or form.

Double-click the Functions folder.

Double-click the name of the project containing your custom function (usually the name of the current database).

Click the module containing the custom function.

Double-click the name of the custom function.

Edit the function, replacing the variable names within the parentheses with the appropriate field names or constants.

Click OK.

Test your query, form, or report to verify the values returned by the custom function.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint