Is Public Variable declaration way any semiliar in Access to?

[pedie]

Hi, I tried tried it like this and seems to work, but dont want to get into any problem latter...so please confirm if 'm declaring this in the right way....


Thanks alot!

[/FONT]
[FONT=Courier New]Option Compare Database
Dim AccessX As Boolean
Public Function VarialbeX()
Dim mycri As String
mycri = 1[/FONT]
[FONT=Courier New]
If mycri = 2 Then
AccessX = True
Else
AccessX = False
End If
End Function
Sub TestmyFunction()
MsgBox AccessX
End Sub

 

[boblarson]

If you want to use the variable in all modules use:

Public AccessX As Boolean

and normally to use within the specific module you use

Private AccessX As Boolean


The word DIM should only really be used INSIDE a procedure.

 

[pedie]

If you want to use the variable in all modules use:

Public AccessX As Boolean

and normally to use within the specific module you use

Private AccessX As Boolean


The word DIM should only really be used INSIDE a procedure.

Bob, thanks for quick reply...
Actually i want to triger this code when the database is opened and want to be able to use this variabe from anycodes within the databse untill the database it closed.

I want to loop thought the table and if usename is found then set accessx to true and permit the users to specefic forms etc..

'm i getting this right and how do i make this function to triger when database startup form is trigered...?