Sharing variables/objects between two open .mdb files

[rlntemp-gng]

I have a system that uses two .mdb files that are open at the same
time, App1.mdb and App2.mdb.
At the time that App2 is launched by App1, App1 remains open with a
form (and table) already loaded and showing, "frm1".

In App1, frm1 has a textbox called txtPgmPath.
App2.mdb needs the variable from txtPgmPath in Frm1/App1.

I havn't tried this before in VBA, but over in App2, is it possible to
reference the value of a control in an open form in another open .mdb
file?

Also, without the need to necessarily link other objects, is it
possible to reference another table/column or report object, et al in
a 2nd .mdb while it is open?

If someone can point me to a code sample that would be helpful.

.....thank you for the assistance.

[UrbanSpaceman]

If txtPgmPath isn't currently bound, create a table in App1 and bind it to
field PgmPath. Link to the table from App2. Then the value is right there
for use, no automation required.

<rl*********@yahoo.comwrote in message
news:11**********************@m3g2000hsh.googlegro ups.com...

>I have a system that uses two .mdb files that are open at the same
time, App1.mdb and App2.mdb.
At the time that App2 is launched by App1, App1 remains open with a
form (and table) already loaded and showing, "frm1".

In App1, frm1 has a textbox called txtPgmPath.
App2.mdb needs the variable from txtPgmPath in Frm1/App1.

I havn't tried this before in VBA, but over in App2, is it possible to
reference the value of a control in an open form in another open .mdb
file?

Also, without the need to necessarily link other objects, is it
possible to reference another table/column or report object, et al in
a 2nd .mdb while it is open?

If someone can point me to a code sample that would be helpful.

....thank you for the assistance.

[Tony Toews [MVP]]

lyle <ly************@gmail.comwrote:

>This gets the text in TextBox Text0 in Form1 in DB1 from code in DB2.

That's pretty cool. I can see that being useful for running reports out of an MDB
from an MDE.

Thanks, Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/