Constant Variables

[Moonshine]

I have a number of Const Variables in my database, ranging from strings to integers. However, when im testing, if i hit a code error that isnt caught by my error trapping, it will clear all of the Public and Private Consts.

is there anyway i can get it to keep the values, until they are cleared by my code?

 

[Summerwind]

Hmmm! Something wrong here????????

I use Public Constants in quite a few apps (Such as the path to mt data file) and they never change during debugging - or at all.

Are you sure you mean constants?

 

[Moonshine]

Ahhh, dammit i just noticed what i have done.

I have just put Public strTitle, and not Public Const strTitle!! I need to wake up i think

Ta for pointing it out inadvertantly!

 

[Moonshine]

Ok, again ignore my previous comment, here are the Public Variables i have, the last one is the Only Const currently. The ones above that are the ones that have values depending on where you are in teh forms, these are the ones i need ot keep.

Public intClient As Integer
Public strClientName As String
Public intVisitDet As Integer
Public intCompNameID As Integer
Public strFormOpen As String
Public strClientAdd As String
Public strAgency As String

Public Const strTitle = "HH1 2005 - HC Sample Week Visits"