Re: Variables from Table

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


--
Duane Hookom
MS Access MVP

"Suthee" <sutheegtr@xxxxxxxxx> wrote in message
news:QvednQl11Pov3mfZnZ2dnUVZ_o-dnZ2d@xxxxxxxxxxxxxx
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!



.

Relevant Pages

  • Re: Variables from Table
    ... variables that the user can change such as a desired path, client filter, ... Also I have four linked SQL tables. ... I setup an ODBC DSN connection to ... Is there a way, when my database opens, to create a ...
    (microsoft.public.access.modulesdaovba)
  • Re: Variables from Table
    ... variables that the user can change such as a desired path, client filter, ... Also I have four linked SQL tables. ... I setup an ODBC DSN connection to ... Is there a way, when my database opens, to create a ...
    (microsoft.public.access.modulesdaovba)
  • Variables from Table
    ... variables that the user can change such as a desired path, client filter, ... Also I have four linked SQL tables. ... I setup an ODBC DSN connection to these ... Is there a way, when my database opens, to create a DSN-Less ...
    (microsoft.public.access.modulesdaovba)