Re: Passing variables between two open .mdb files

lyle wrote:
On Jul 26, 11:55 am, rlntemp-...@xxxxxxxxx wrote:
I have an application where App1.mdb calls App2.mdb when a button is
clicked on a form.
App1 has three values of interest:
1. gblPgmPath
2. frmMain1.txtSubTotalVariance
3. frmMain1.txtSubTotalVariancePct
The two txt fields are calculated realtime.

When App2 is launched from App1, App1 has frmMain1 open and stays open
even after work in App2 is completed and closed.
App1 has a value in the gblPgmPath variable and two values in text
boxes in frmMain1 that App2 needs to reference.

Over in App2, what is the syntax for referencing the "gbl" variable
and the two text boxes in frmMain1 so that I can retrieve their values
successfully?

Thanks.

Is this a different question than you asked in
"Sharing variables/objects between two open .mdb files"
posted two days ago
(http://groups.google.com/group/comp.databases.ms-access/msg/
8c46fa6e60126fcd)
?

If not, was none of the answers satisfactory?

I found yours quite satisfying.
.

Relevant Pages

  • Re: Passing variables between two open .mdb files
    ... even after work in App2 is completed and closed. ... App1 has a value in the gblPgmPath variable and two values in text ... "Sharing variables/objects between two open .mdb files" ...
    (comp.databases.ms-access)
  • Passing variables between two open .mdb files
    ... even after work in App2 is completed and closed. ... App1 has a value in the gblPgmPath variable and two values in text ... boxes in frmMain1 that App2 needs to reference. ...
    (comp.databases.ms-access)
  • Re: Passing variables between two open .mdb files
    ... even after work in App2 is completed and closed. ... App1 has a value in the gblPgmPath variable and two values in text ... Your PassedParameters table in App2.mdb has only one row otherwise you'll most likely want to limit what rows are updated by using a WHERE clause in the SQL. ...
    (comp.databases.ms-access)
  • Using a Global Mutex
    ... I have an application App1, that after doing some stuff starts App2. ... of a global section from a session other than the initial system session ...
    (microsoft.public.win2000.termserv.clients)
  • Using a Global Mutex
    ... I have an application App1, that after doing some stuff starts App2. ... of a global section from a session other than the initial system session ...
    (microsoft.public.windowsxp.customize)