Help, using a table to store constants

I would like to make a table to store all constants. I therefore need to read each record of this table and assign the values to the
global variables?

How do I read each record of a table in code?

I did check the Internet before I came here. Your help would be appreciated.

ad

It's easy enough to read a value from a table using DLookup.
If that is unfamiliar, see:
http://members.iinet.net.au/~allenbrowne/casu-07.html

However, reading the name of a constant and then attempting to convert it to
a numeric(?) value is a different matter. You would need to use two columns:
one containing the name of the constant, and another containing the value.
You could then DLookup() the value of the constant by finding its name. By
the time you have done that, you have gone around in a circle, i.e. the
result:
MyVariable = DLookup("ValueField", "ConstantTable", _
"ConstantName = 'dbText'")
ends up the same as:
MyVariable = dbText

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ad" wrote in message
...
I would like to make a table to store all constants. I therefore need to
read each record of this table and assign the values to the
global variables?

How do I read each record of a table in code?

I did check the Internet before I came here. Your help would be
appreciated.

ad

1) Why?

2) v1 = dlookup("fieldname","tablename","intField = " & 1)
or
3) vArray = rst.GetRows(nMaxGetRows)

(david)

"ad" wrote in message ...
I would like to make a table to store all constants. I therefore need to
read each record of this table and assign the values to the
global variables?

How do I read each record of a table in code?

I did check the Internet before I came here. Your help would be
appreciated.

ad

I thought it would be easy for you guys ^_^

Thank you guys very much.

ad

"david epsom dot com dot au" david@epsomdotcomdotau wrote in message ...
1) Why?

2) v1 = dlookup("fieldname","tablename","intField = " & 1)
or
3) vArray = rst.GetRows(nMaxGetRows)

(david)

"ad" wrote in message ...
I would like to make a table to store all constants. I therefore need to
read each record of this table and assign the values to the
global variables?

How do I read each record of a table in code?

I did check the Internet before I came here. Your help would be
appreciated.

ad