HOw to add a module to code (1 Viewer)

[wgma]

I was given a module from a member of this forum. Now I need to know how to add that module to my project and how to use it.

The module checks to see if the links to the BE are in tact. I was thinking that I should put it in a splash screen so that once the app starts the links will be checked once and that is it.

How do i do this?

Thanks.

 

[Banana]

In VBE, File-> Import Module

 

[boblarson]

I was given a module from a member of this forum. Now I need to know how to add that module to my project and how to use it.

1. Create a new module (go to the modules area-same place as the tables, queries, forms, reports, macros, etc.)

2. Name it something OTHER than the function you are trying to use.

3. Copy all of the code into the VBA window for that new module.

4. Save it (remembering step 2)

The module checks to see if the links to the BE are in tact. I was thinking that I should put it in a splash screen so that once the app starts the links will be checked once and that is it.

Nope -
5. Call it from an AutoExec macro (create a new macro and save it with the name AutoExec and then in the Actions select RunCode and put in the function name that you want to run (the name of the relink function)