Load a module into memory when an MDE opens
Posted on 2011-03-08
I have a number of Variables that are constant during the use of a program that is in the form of a MDE. Right now I load them as "OnOpen in a form or report and then the program kills the set of variables each time the form closes. In some cases I open a form with all the information stored in fields, minimize it and then use me!FieldName to access the data but it seem wrong to me. On top of that the program is doing more and more and the form itself is getting slow to load as I add more to it.
At one point I used a program where you created a module called Autoexec, and it loaded all the variables / calls that you needed just like dos or novell does, that would be the best example of what I want to do in VBA.
What I would want is these to be stored as public variables so they would not be destroyed until the program closes. I just do not know how to do it, if you could point me to any documentation that would enlighten me that would be a great help.