I am trying to program a button on a form. This button opens an external
program (i use shell to do this). The problem is that the name of the
external program is stored in a table (within the database) called
"parameters". This table has only one record with a few parameters I need in
the database-application. So I need to retrieve the value of the field "path
to external program" (from the table parameters) in my code for the
click-event on the button.
Thanks in advance.

Kurt

' Declare Public constant.
Public Const EXT_PROG_PATH = "Value from your data table"

Then, you can use EXT_PROG_PATH like any other variable.

hth,
--
Cheryl Fischer
Law/Sys Associates
Houston, TX

BUTTON {*filter*}TON!!!!!   WHO CARES!!!!!!!

Re: using a value in a table field to open an external programHello,

From looking at a couple of your other replies to questions in this NewsGroup, it appears that you are concerned that the "posts" or messages in this NewsGroup are being sent to you maliciously.  Nothing could be farther from the truth.  

Perhaps you or someone who uses your computer inadvertently signed up or subscribed to this NewsGroup.  If that is the case, you will see in your Outlook Express Folders column a list of folders beginning with "microsoft.public.access ..." .  If you do not want to see message traffic from this or any other NewsGroup, simply right-click on its folder and select "Unsubscribe".

  BUTTON {*filter*}TON!!!!!   WHO CARES!!!!!!!

  > hello,
  >
  > I am trying to program a button on a form. This button opens an external
  > program (i use shell to do this). The problem is that the name of the
  > external program is stored in a table (within the database) called
  > "parameters". This table has only one record with a few parameters I need in
  > the database-application. So I need to retrieve the value of the field "path
  > to external program" (from the table parameters) in my code for the
  > click-event on the button.
  > Thanks in advance.
  >
  > Kurt
  >
  >
  >
  >

You can either use the DLookUp function or Recordset to retrieve the Table
Field Value, i.e. your required pathname to be used in your Shell code.

Check Access Help on the DLookUp function.

--
HTH
Van T. Dinh
MVP (Access)