running access 2k;
And before anything else is said - "Yes, Virginia, I know you can NOT
use a variable to set a constant (that's why it's constant)".

BUT - my problem is - I want a constant, that I can set from a
variable (one time)!!!

When my application starts, the user is prompted to make a selection
from a list.
I want that selection to go into a global variable, and NEVER CHANGE
while the application is running. This means that if the application
encounters an unexpected error - this value is NOT lost.

If the user wants to change this value, they should have to close the
application and restart.

This is the BEHAVIOR I'm looking for.....

Is this behavior possible, and if so, how?

BTW -
I should mention, that I successfully accomplished this by actually
programatically inserting a global constant statement into a "globals
module" ! (the insertion statement, of course used a variable to
define the statement). Problem is, (no surprise), this can NOT be done
in a run-time application.... ;o)

>running access 2k;And before anything else is said - "Yes, Virginia, I know you can NOTuse a variable to set a constant (that's why it's constant)".

BUT - my problem is - I want a constant, that I can set from avariable (one time)!!!

When my application starts, the user is prompted to make a selectionfrom a list.I want that selection to go into a global variable, and NEVER CHANGEwhile the application is running. This means that if the applicationencounters an unexpected error - this value is NOT lost.

If the user wants to change this value, they should have to close theapplication and restart.

This is the BEHAVIOR I'm looking for.....

Is this behavior possible, and if so, how?

BTW -I should mention, that I successfully accomplished this by actuallyprogramatically inserting a global constant statement into a "globalsmodule" ! (the insertion statement, of course used a variable todefine the statement). Problem is, (no surprise), this can NOT be donein a run-time application.... ;o)

thoughts or discussion?

TIA!!Bob

You could create a custom property to store the value and seed it on opening the
database.

running access 2k;
And before anything else is said - "Yes, Virginia, I know you can NOT
use a variable to set a constant (that's why it's constant)".

BUT - my problem is - I want a constant, that I can set from a
variable (one time)!!!

When my application starts, the user is prompted to make a selection
from a list.
I want that selection to go into a global variable, and NEVER CHANGE
while the application is running. This means that if the application
encounters an unexpected error - this value is NOT lost.

If the user wants to change this value, they should have to close the
application and restart.

This is the BEHAVIOR I'm looking for.....

Is this behavior possible, and if so, how?

BTW -
I should mention, that I successfully accomplished this by actually
programatically inserting a global constant statement into a "globals
module" ! (the insertion statement, of course used a variable to
define the statement). Problem is, (no surprise), this can NOT be done
in a run-time application.... ;o)

running access 2k;
And before anything else is said - "Yes, Virginia, I know you can NOT
use a variable to set a constant (that's why it's constant)".

BUT - my problem is - I want a constant, that I can set from a
variable (one time)!!!

When my application starts, the user is prompted to make a selection
from a list.
I want that selection to go into a global variable, and NEVER CHANGE
while the application is running. This means that if the application
encounters an unexpected error - this value is NOT lost.

If the user wants to change this value, they should have to close the
application and restart.

This is the BEHAVIOR I'm looking for.....

Is this behavior possible, and if so, how?

BTW -
I should mention, that I successfully accomplished this by actually
programatically inserting a global constant statement into a "globals
module" ! (the insertion statement, of course used a variable to
define the statement). Problem is, (no surprise), this can NOT be done
in a run-time application.... ;o)

thoughts or discussion?

TIA!!
Bob

Why not store the value in a table? You could have 1 or more fields
that might change on a daily, weekly, monthly, yearly time period.
Create the fields you want. Add 1 record to the table. Plug in some
values as needed. Then update that one record to your hearts content.

running access 2k;
And before anything else is said - "Yes, Virginia, I know you can NOT
use a variable to set a constant (that's why it's constant)".

BUT - my problem is - I want a constant, that I can set from a
variable (one time)!!!

When my application starts, the user is prompted to make a selection
from a list.
I want that selection to go into a global variable, and NEVER CHANGE
while the application is running. This means that if the application
encounters an unexpected error - this value is NOT lost.

If the user wants to change this value, they should have to close the
application and restart.

This is the BEHAVIOR I'm looking for.....

Is this behavior possible, and if so, how?

BTW -
I should mention, that I successfully accomplished this by actually
programatically inserting a global constant statement into a "globals
module" ! (the insertion statement, of course used a variable to
define the statement). Problem is, (no surprise), this can NOT be done
in a run-time application.... ;o)

running access 2k;
And before anything else is said - "Yes, Virginia, I know you can NOT
use a variable to set a constant (that's why it's constant)".

BUT - my problem is - I want a constant, that I can set from a
variable (one time)!!!

When my application starts, the user is prompted to make a selection
from a list.
I want that selection to go into a global variable, and NEVER CHANGE
while the application is running. This means that if the application
encounters an unexpected error - this value is NOT lost.

If the user wants to change this value, they should have to close the
application and restart.

This is the BEHAVIOR I'm looking for.....

Is this behavior possible, and if so, how?

BTW -
I should mention, that I successfully accomplished this by actually
programatically inserting a global constant statement into a "globals
module" ! (the insertion statement, of course used a variable to
define the statement). Problem is, (no surprise), this can NOT be done
in a run-time application.... ;o)

thoughts or discussion?

TIA!!
Bob

You could create a custom property to store the value and seed it on opening the
database.

>>>running access 2k;And before anything else is said - "Yes, Virginia, I know you can NOTuse a variable to set a constant (that's why it's constant)".

>>>BUT - my problem is - I want a constant, that I can set from avariable (one time)!!!

>>>When my application starts, the user is prompted to make a selectionfrom a list.I want that selection to go into a global variable, and NEVER CHANGEwhile the application is running. This means that if the applicationencounters an unexpected error - this value is NOT lost.

>>>If the user wants to change this value, they should have to close theapplication and restart.

>>>This is the BEHAVIOR I'm looking for.....

>>>Is this behavior possible, and if so, how?

>>>BTW -I should mention, that I successfully accomplished this by actuallyprogramatically inserting a global constant statement into a "globalsmodule" ! (the insertion statement, of course used a variable todefine the statement). Problem is, (no surprise), this can NOT be donein a run-time application.... ;o)

>>running access 2k;And before anything else is said - "Yes, Virginia, I know you can NOTuse a variable to set a constant (that's why it's constant)".

>>BUT - my problem is - I want a constant, that I can set from avariable (one time)!!!

>>When my application starts, the user is prompted to make a selectionfrom a list.I want that selection to go into a global variable, and NEVER CHANGEwhile the application is running. This means that if the applicationencounters an unexpected error - this value is NOT lost.

>>If the user wants to change this value, they should have to close theapplication and restart.

>>This is the BEHAVIOR I'm looking for.....

>>Is this behavior possible, and if so, how?

>>BTW -I should mention, that I successfully accomplished this by actuallyprogramatically inserting a global constant statement into a "globalsmodule" ! (the insertion statement, of course used a variable todefine the statement). Problem is, (no surprise), this can NOT be donein a run-time application.... ;o)

running access 2k;
And before anything else is said - "Yes, Virginia, I know you can NOT
use a variable to set a constant (that's why it's constant)".

BUT - my problem is - I want a constant, that I can set from a
variable (one time)!!!

When my application starts, the user is prompted to make a selection
from a list.
I want that selection to go into a global variable, and NEVER CHANGE
while the application is running. This means that if the application
encounters an unexpected error - this value is NOT lost.

If the user wants to change this value, they should have to close the
application and restart.

This is the BEHAVIOR I'm looking for.....

Is this behavior possible, and if so, how?

BTW -
I should mention, that I successfully accomplished this by actually
programatically inserting a global constant statement into a "globals
module" ! (the insertion statement, of course used a variable to
define the statement). Problem is, (no surprise), this can NOT be done
in a run-time application.... ;o)

I dont know about the speed either, however you could use a splash
screen at the start of the program and just load it then - it gives
the appearance of speed because users are expecting to wait a little
at the beginning. Once it is in memory it really depends on the speed
of the computer, suffice to say its normally pretty quick these
days. :-)