Static Variable problem

[Soulspike]

Hello,

I am new to this forum and VBA so please bear with me. I have a fairly specific question I think but my terminoligy may be a little messed up.


I want to declare a variable to remain even if access is closed and then re-opened. I thought i could do this by declareing the variable as static, but that doesnt seem to be working. Is there another way?

Thank you for your time and patience

[lotus18]

Hello,

I am new to this forum and VBA so please bear with me. I have a fairly specific question I think but my terminoligy may be a little messed up.


I want to declare a variable to remain even if access is closed and then re-opened. I thought i could do this by declareing the variable as static, but that doesnt seem to be working. Is there another way?

Thank you for your time and patience

Can you post your code?

Rey Sean

[Soulspike]

Here it is.


I want to run the following code at start up and force a default if the variables are blank. If they are not blank I leave them alone and use the variables to set the value of some form controls later.

 
Static DefaultLoc As String
Static DefaultCust As String
 
    If DefaultCust = "" Or DefaultLoc = "" Then 'Check if customer or location if is null
                DefaultLoc = "SDC"
                DefaultCust = "Union Pacific Railroad"
 
    End If
 
 

[lotus18]

 
Dim DefaultLoc As String
Dim DefaultCust As String
 
    If DefaultCust = "" Or DefaultLoc = "" Then 'Check if customer or location if is null
                DefaultLoc = "SDC"
                DefaultCust = "Union Pacific Railroad"
 
    End If
 
 

Hey

Why don't you try to change your variable declaration to Dim instead of Static? I'm not sure about this, Static is just like a Const (constant).

Rey Sean

[Soulspike]

Well the problem is that I need the variable to hold its value when I close the application and then open it again. Currently the values go away when I close access. How can I have vb save the values somewhere that I can then retrieve them the next time I open the database?

[Killer42]

The situation is pretty much the same with most programming languages. Variables are only held in the computer's working memory. Once you exit a program, they're discarded. Generally speaking it doesn't matter what type they are.

If you want them to persist between sessions then you need to store the information somewhere and retrieve it next time your program starts. Typical places to store data between sessions would be...

• Windows registry
• A text file
• A database

There are probably more exotic options (for instance, create a DLL which holds information for you in its address space and returns it when you call it later). But these are the main ones you'll probably want to consider.

Given that you're working in Access, a database table might be the simplest, since you already know the database is there. So why not create a new table, dump your information into it before exiting, and read it back on entry?

[Soulspike]

Well I was hopeing that I was missing something I am now storing the data in a table and it seems to be working well. Thank you very much for your expertise.

[Killer42]

Well I was hopeing that I was missing something I am now storing the data in a table and it seems to be working well. Thank you very much for your expertise.

No problem. Glad to see you've got it working.