Global variable

[101287]

I have an Access Database. I would like to define a couple of global variables that I can set up to different values across the project. However, I have define the Public variable in the declaratives section but when I compile VBA some variable are Null even though I have set up the values. Can you help me with this problem? Need to define global variable across the MS access project.

Thank you for help and guidance.

Luis

 

[PHV]

Each time the project is reinitialised (compile, End instruction, ...) all global variables are resetted.
You should execute your initialisation routine.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ZmrAbdulla]

To add with PHV's note..
Public variables that are accessible throughout the project is to declared in a module as public.

________________________________________________________
Zameer Abdulla
Help to find Missing people