get a single field value without a lot of code?

C

Chris

Hi,

Instead of using an INI file or other means of containing application
variables I have
created a appvariables table in Access 2000.

The table will only contains 1 record with 1 or more fields.

Is there a function that I can use to quickly get stick a particular field
into a dynamic variable without having to write all the open recordset and
read code?

thanks

Chris
 
F

fredg

Hi,

Instead of using an INI file or other means of containing application
variables I have
created a appvariables table in Access 2000.

The table will only contains 1 record with 1 or more fields.

Is there a function that I can use to quickly get stick a particular field
into a dynamic variable without having to write all the open recordset and
read code?

thanks

Chris
Click to expand...

The table contains just one record?
MyVariable = DLookUp("[FieldName]","TableName")
 
Top