variable fixed

[matrixindicator]

I am not familiar with static variable and I don't know that I need them for the following.

A variable can be initialised with a fixed value (eg. 1) or can get a value the first time it is used (eg from a text box).

I need a variable that maintain his last value. eg. if database is opened 10 times then give msgbox.

 

[HarleyQuinn]

I would store the value you want for the variable in the DB and set/retrieve it from there.

That will allow you to persist a value you can assign to the variable when the application isn't open.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[matrixindicator]

ok,

how to avoid that you can reset this (when its in a table ?)

 

[MajP]

you can use the custom properties collection

http://allenbrowne.com/ser-09.html