Handing over a String Variable from one Access Applikation to a second Access Application

[Marcel Stoop]

Hi

Following:
- I have 1 basic Access Application
- On some events within that 1. Acc Application a 2. Acc Application will
open

I want to hand over the value of a string variable from the 1. Acc
Application to the 2. Acc Application

Is this possible, and if yes what will the code look like.

Thanks for the help

Cheers
Marcel

 

[Jeff Boyce]

Marcel

I'm guessing you're looking for a way to do this to solve some business
need/issue.

If you'll describe a bit more what having this particular ability will allow
you to do, folks here may be able to offer alternate approaches.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Mike Painter]

Hi

Following:
- I have 1 basic Access Application
- On some events within that 1. Acc Application a 2. Acc Application
will open

I want to hand over the value of a string variable from the 1. Acc
Application to the 2. Acc Application

Is this possible, and if yes what will the code look like.

http://support.microsoft.com/kb/209207
see /cmd
and then
http://msdn.microsoft.com/en-us/library/aa211469(office.11).aspx

 

[Marcel Stoop]

Hi me again

1. Application, is the normal standart applikation, which is the Frontend.
It calculates some financial figures. When this calculation results in a
value X> 100, then the second application opens with just a singel Mask with
some txt fields. In one of those fields the user has to enter this value X.

I now what this field in the second Applikation to be filled automatically
with this value X.

For this I need to hand over the Value of this 1. variable, which is value
X, to the 2. Application.

I hope this is possible.

Cheers
Marcel

 

[Jeff Boyce]

Marcel

Perhaps we are using differing definitions of the term "application"...

I can imagine a similar situation in which the data stored in one table
helps guide decisions related to data in another table.

However, if the data is already stored/recorded in one table, it is rarely a
good design to have to redundantly store that same piece of data in a second
table. If you'll provide a more specific description of your situation,
folks here may be able to offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Marcel Stoop]

Hi Jeff

It is very easy, I just want to know if it is possible to hand over the
value of a variable from one Access Frond-End to an other Access Frond-End.

Cheers Marcel

 

[Jeff Boyce]

Marcel

I don't know. I haven't done that. I haven't found it necessary to learn
how to do that.

You've focused on a "how". If you'll explain the "what", folks may be able
to offer you alternate approaches.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[BruceM]

A reply in another part of this thread may address the situation. Have you
seen that posting, and if so did you look at the articles and attempt the
method described?

 

[Marcel Stoop]

Yes I have seen that posting and I had a look at those links. Unfortunately
it will not do the trick
I have solved this problem in an other way. I create a temp. txt File in
which I write the value.
The 2. FE Access Applikation reads the value out of this txt file and
subsequenty deletes this temp txt file.

This is more or less also a "handing over of variables" from one access FE
to another access FE.

Cheers
Marcel

 

[Mike Painter]

Yes I have seen that posting and I had a look at those links.
Unfortunately it will not do the trick
I have solved this problem in an other way. I create a temp. txt File
in which I write the value.
The 2. FE Access Applikation reads the value out of this txt file and
subsequenty deletes this temp txt file.

I'm curious as to why using the cmd line argument did not work.