keyongtech


  keyongtech > access.* > access.formscoding > 05/2009

 #1  
04-30-09, 10:31 PM
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
 #2  
04-30-09, 11:28 PM
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


"Marcel Stoop" <marcel.stoop> wrote in message
news:1196
[..]
 #3  
05-01-09, 12:22 AM
Mike Painter
Marcel Stoop wrote:
> 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.


[url down]
see /cmd
and then
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
 #4  
05-01-09, 07:30 AM
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" <nonsense> schrieb im Newsbeitrag
news:3872
[..]
 #5  
05-01-09, 07:44 PM
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" <marcel.stoop> wrote in message
news:5652
[..]
 #6  
05-01-09, 10:41 PM
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" <nonsense> schrieb im Newsbeitrag
news:1492
[..]
 #7  
05-01-09, 11:48 PM
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

"Marcel Stoop" <marcel.stoop> wrote in message
news:1492
[..]
 #8  
05-04-09, 12:05 PM
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" <marcel.stoop> wrote in message
news:1492
[..]
 #9  
05-04-09, 10:04 PM
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



"BruceM" <bamoob_at_yawhodotcalm.not> schrieb im Newsbeitrag
news:1716
[..]
 #10  
05-05-09, 08:28 PM
Mike Painter
Marcel Stoop wrote:
> 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.
Similar Threads
Use String variable to access field

Hi, I have a Schedules with 5 fields, Monday, Tuesday, Wed, etc I want to write a VB subroutine to access the specified field depending on a variable. So if I have a...

Can't access Application variable in TWebModule...

Where is the Application variable when using (File: New: Web Server Application) TWebModule app? I see it in the .dpr ------------------------------------- library...

How do you access an application variable from a class?

Hi, If I try to access an application variable from a class I get the error 'Name Application is not declared'. Is ther any (fairly simple) way of getting round this or do...

How to access application scope variable in Struts Action Class

Hi , I am building one application where I have to store some of the common information in the application scope of the web application. Now Can anybody tell me how to access...

How can I pass a Word VBA variable to an ACCESS Query SQL string?

Hi I want to use the contents of a variable in a Word VBA module as a criterion to filter records in an Access database. A SQL string however does not accept...


All times are GMT. The time now is 01:15 AM. | Privacy Policy