Discuss "Intro to Modules / Public Functions" in the Microsoft Access forum.

The database at the bottom of this post is just a sample database that will give you an introduction on how to use and code public functions.

Often, when one mentions "module", or "public function", people tend to cringe, thinking of how complicated the database will be. In all reality public functions can be extremely simple, as per these examples.

I like to use public functions for repetitive tasks that have to be re-coded over and over. Well, instead of coding the same 2 or 3 lines over and over, I like to throw them into public functions that can be called from anywhere.

Anyhow, here is the database:

Edit: I updated the database to fix an issue with the middle initial, if null would still include the period on the full name function. Also cleaned up the functions and subs just a hair.

Attached Files

Intro2Modules.zip (65.1 KB, 8 views)