How do I create a new module?
I've tried so many things and no matter what I type in the module, it's wrong.

Assume I haven't tried anything (be detailed), I just need to know what I'm
missing.

On Thu, 19 Jul 2007 12:38:02 -0700, KISSnACDC <(E-Mail Removed)> wrote:

>How do I create a new module?
>I've tried so many things and no matter what I type in the module, it's wrong.

Do you mean a Standard Module? You can create one from the database window (the one with the listing of the Tables,
Forms, etc) by clicking Modules, then New ... this will create a new Standard Module named Module1. You can rename it,
of course.

From there you'd add your Subs and Functions. A Sub or Function always has a Header and Footer:

Sub MySub()
<your code here>
End Sub

Function MyFunction(SomeInputValue As String) As Boolean
<your code here>
End Function

You can also add Constants and such at the beginning, in the General Declarations section:

Private mflgDirty As Boolean

Const conIsNew As Long = 1

Unlike a Class module, you don't need to do anything special to call a Sub or Function from a Module, you simply do
this:

If MyFunction("Tommy Boy") Then
MsgBox "Right On!!"
End If

>
>Assume I haven't tried anything (be detailed), I just need to know what I'm
>missing.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com