get a single field value without a lot of code?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count text values in a Access Field 0
Question on Query Comparing 2 values 2
Using a field name as variable in a query 1
Denormalize data into one single field (by query) 2
Checking if data exists another table and, if yes, extracting a value 0
Evaluate String for Value from Table 3
Counting multiple field values in a single query/report 1
Populate a field in a query with the value of record 4

Back
Top