Populate a variable from a table

[Guest]

I have a table within the database with single entry.
I would like to extract that data and populate it onto a variable declared
in a module but am having trouble referencing the field.
I'm sure that it is straightforward but......

Thanks in advance.

 

[Allen Browne]

See:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html

 

[Guest]

If you are saying the table has only one row and you want the value of a
field in a variable in your module, then this will work:

Dim VarSomeVariable as Variant

varSomeVariable = DLookup("[SOME_FIELD]", "SomeTable")

 

[Guest]

Thanks. This works fine.

If you are saying the table has only one row and you want the value of a
field in a variable in your module, then this will work:

Dim VarSomeVariable as Variant

varSomeVariable = DLookup("[SOME_FIELD]", "SomeTable")

I have a table within the database with single entry.
I would like to extract that data and populate it onto a variable declared
in a module but am having trouble referencing the field.
I'm sure that it is straightforward but......

Thanks in advance.

 

[basstbone]

AWESOME ))))) Glad I found this post
Worked for me too
Thank you all !!!

Thanks. This works fine.

If you are saying the table has only one row and you want the value of a
field in a variable in your module, then this will work:

Dim VarSomeVariable as Variant

varSomeVariable = DLookup("[SOME_FIELD]", "SomeTable")

I have a table within the database with single entry.
I would like to extract that data and populate it onto a variable declared
in a module but am having trouble referencing the field.
I'm sure that it is straightforward but......

Thanks in advance.