vba variable problem 1

[jay2502]

I have a variable in vba but it defults to zero when i start the database everytime how can i get the database to save it when it closes.

 

[lespaul]

you will need to store the value in a table or external text file. Write out when you close the program and read in when you start the program.

Leslie

Essential for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[jay2502]

How would I Write out and read in the variable? Just an example please

 

[maxhugen]

I use a table that I call "_system", which is stored in the front end. Its like a hash table, or the Windows Registry. Fields are:

sysGroup optional, helps group similar items.
sysItem A name to look up, eg "MySavedVariable"
sysValue The value of the item, eg "MyVariableValue"

Now you can save the value of your variable in the table, and retrieve as required.

An alternative is to save it to the Registry itself, see GetSetting and SaveSetting methods in Help.

Max Hugen
Australia