Get value of a Control in another running database

[Bebop]

I have a POS system, packaged with Access Runtime, running on a PC and have developed a database system to provide additional function. I have no documentation to the names of the Forms or Controls in POS. My ADDON system does link to the POS Tables and has some Tables of its own.

At the time in the POS system where the cashier checks out the customer, they need to AltTab to my ADDON system to enter some information for the customer. They remember to CustomerKey from the screen on the POS system and key it into a Form Control in my ADDON system.

I want to, from my ADDON system, read the value of the CustomerKey in POS and fill it in so the cashier does not need to remember/type it.

Is it possible to get the data from another already running Access database?

I don't know the name of the control. Is it possible to run through a list of Forms and Controls in the POS system from my ADDON system?

I do know the name of the field in the Table and expect it to be current and might have to get that?

Failing all that, is there a Collection of running Access databases? I could go through its Forms and Controls one time looking for what i want.

This should explain what I'm trying to do but, as usual, may have omitted something.

I am looking forward to your answers.
Bob

 

[Mihail]

While the question is interesting, and I expect as well an answer, a quick solve is to instruct the users to use the old Copy-Paste feature.