A site for solving at least some of your technical problems...
A site for solving at least some of your technical problems...
To define a constant in MS-Access, use the Const keyword as in:
Private Const varname = "Some value"
The value can be a string, integer, floating point. The variable can be made public in which case it is global among all modules and forms.
The value after the equal sign must be constant at time of compilation which is why it is limited to strings, integers and floating point values.