Detecting Status of command button in a different instance of Access

[DaveyCrockett]

Hi,

I have a question about trying to determine if a command button is clicked from another instance of access. Can this be done? Just in case you need more details I will provide below:

if Application1.form1.CommandButton1 is pressed I change the caption to "ON"
Otherwise it is set to "OFF" and not depressed. I am wondering if I can have another Access applications label represent the value. ie. Application2.form1.label1.caption = application1.form1.CommandButton1.value.

Any suggestions would help.

Thanks

 

[DaveyCrockett]

No Ideas?

 

[PHV]

Where are Application1 and Application2 coming from ?
What are you trying to do ?
What have you so far and where are you stuck ?

Feel free to read the second FAQ in my sig.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[nickspace]

Hi DaveyCrockett,
I've never tried anything like this. But you can try it to see if it helps:
1) Create a global variable in application1 that gets flagged with the value of the command button
2) Create a public function in application1 that reports this value
3) Create a reference for application1 in appliction2
4) Call the function in step2 to get the value of the variable in step1

HTH,
ND

 

[DaveyCrockett]

PHV - I am stuck in the design stage. I want to improve a process that we currently have and was thinking about trying DDE, but am hoping that something can be done in access as this is what the current application is. For some reason, many years ago, someone created this application using Access. A form from w/ in this access application MUST be CLICKED to be "ON" (toggle button to be exact). This is the object I want to obtain a state from.

Nickspace - I tried to set a reference to another access application and I don't see it in my list. Am I doing something wrong?

Thank you both for your assistance.