Variables from Table

[Suthee]

Hi All--

I have a form that pulls from a table. I want to have several system
variables that the user can change such as a desired path, client filter,
name filter, etc.

Basically, I want to take the value in each of these separate fields (values
are stored in the table) and be able to call them from VBA.

Is there a way to do that?


Also I have four linked SQL tables. I setup an ODBC DSN connection to these
tables. Is there a way, when my database opens, to create a DSN-Less
connection to the SQL database I am using? Perhaps when the main menu
loads? That way I won't have to set this up on 60 PCs.

Thanks for any help!

 

[Suthee]

I should add that I want to be able to call these variables from queries as
well.

 

[Duane Hookom]

For the DSN-Less connections, see Doug Steele's page
http://www.accessmvp.com/djsteele/DSNLessLinks.html.

You can pull individual values from a table in code using DLookup(). For
instance

strCompany=DLookup("defValue","tblDefaults","defVariable='Company Name'")

 

[Suthee]

Thank you. The DLookup worked perfectly. I had seen that before, and I am
glad I understand its purpose now.