Prev: Textbox code for list of post
Next: IIF Function error in Access 2003
From: Highlight between 3 fields on 16 Mar 2010 04:53
Hello

I want make code on global for whole project as this:

Dim AA As Integer

When I past it in modul under "Option Compare Database" so it be only of
this modul.
I can not change the value on any form, Ex.

Private Sub Kommand11_Click()
AA = 2
End Sub

So where I have to past
Dim AA As Integer
to make it available for the whole project?

Thanks for any comment.
From: BruceM via AccessMonster.com on 16 Mar 2010 07:36
Declare it as a public variable:

Public AA as Integer


Highlight between 3 fields wrote:
>Hello
>
>I want make code on global for whole project as this:
>
> Dim AA As Integer
>
>When I past it in modul under "Option Compare Database" so it be only of
>this modul.
>I can not change the value on any form, Ex.
>
> Private Sub Kommand11_Click()
> AA = 2
> End Sub
>
>So where I have to past
> Dim AA As Integer
>to make it available for the whole project?
>
>Thanks for any comment.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201003/1

From: Highlight between 3 fields on 16 Mar 2010 10:39
Thank you for your help.
 | 
Pages: 1
Prev: Textbox code for list of post
Next: IIF Function error in Access 2003