Update a variable in another Access DB?

  • Thread starter Thread starter Morgan
  • Start date Start date
M

Morgan

Hi

I have a MS Access DB that i use to process some global
variables. At a certain point in the process i would
like to open another Access DB and pass some values to
one of its forms.

So far i can open the second db ok but the problem is
then updating a control on a form in the second db.

I have tried using the DoCmd.OpenForm command in the
first database to open the form in the second db followed
by the [Forms]![Formname]![controlname] = valueabc
however it errors out because the form does not appear in
the forms collection of the first db.

I know that i can achieve a solution by writing the
valueabc out to a txt file and then have the second db
reference the text file however I am sure there must be a
way to pass a variable value between instances of Access.

Any help will be greatly appreciated.

Cheers
Morgan
 
Can I be clear?

Do you wish to modify data in another database, modify the properties
of a form object in another database or display a form from another
database?

Are you trying to run two instances of Access, each with a different
database, and have one instance influence forms in the other?

WHY precisely do you need this to happen?
 
Morgan said:
Hi

I have a MS Access DB that i use to process some global
variables. At a certain point in the process i would
like to open another Access DB and pass some values to
one of its forms.

So far i can open the second db ok but the problem is
then updating a control on a form in the second db.

I have tried using the DoCmd.OpenForm command in the
first database to open the form in the second db followed
by the [Forms]![Formname]![controlname] = valueabc
however it errors out because the form does not appear in
the forms collection of the first db.

I know that i can achieve a solution by writing the
valueabc out to a txt file and then have the second db
reference the text file however I am sure there must be a
way to pass a variable value between instances of Access.

Any help will be greatly appreciated.

Cheers
Morgan
Click to expand...
 
Back
Top