howto - "modularize design" of front-end application ??

david@epsomdotcomdotau wrote in message
...

So code in your library does not normally open forms
or reports in your CurrentDB -- If you want that, perhaps
you would use a Add-In instead of a library.

Have a look at my earlier reply in this thread for an example of code to
open a form from a referenced library database in the current one.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Yes, the add-in would only be used as a library to open
a form from the CurrentDB.

If you want code from the CurrentDB to open a form
from the library, you would use a reference.

(david)

"Arvin Meyer [MVP]" wrote in message
...
david@epsomdotcomdotau wrote in message
...

So code in your library does not normally open forms
or reports in your CurrentDB -- If you want that, perhaps
you would use a Add-In instead of a library.

Have a look at my earlier reply in this thread for an example of code to
open a form from a referenced library database in the current one.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

On Oct 8, 9:29 am, "Arvin Meyer [MVP]" wrote:
Here's an example. Three of the 12 databases required the contractors form
which had tons of code in it for validation. Instead of trying to maintain
that form in 3 places, I put it in a CodeDB which I referenced on all 3
databases. A module maintained code to open the form:

Public Sub OpenContractors()
On Error GoTo Err_Handler
DoCmd.OpenForm "frmContractors"
Err_Handler:
ErrorSub
End Sub

You'll find the error handling code at my website:

http://www.datastrat.com/Code/Error.txt

Now in each of the 3 databases, a button had the following code:

Public Sub cmdContractors_Click()
' Code from CodeDB.mde
OpenContractors
End Sub

Simple, easy.
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com

Wonderful!
TYVM, Arvin!
appreciate the info!
Bob