Open Access from an Access program that is currently running

[destinman via AccessMonster.com]

Is possible to open another Access program from an Access program that is
currently running ? I know you can run two separate Access programs at the
same time if opened from Desktop options. I also know that the command
button options do not allow you to do this. Is there some VBA coding that
could be entered into a command button "Click" event that would allow you to
do this ?

 

[Keith Wilby]

Is possible to open another Access program from an Access program that is
currently running ? I know you can run two separate Access programs at
the
same time if opened from Desktop options. I also know that the command
button options do not allow you to do this. Is there some VBA coding that
could be entered into a command button "Click" event that would allow you
to
do this ?

What are you trying to achieve?

Keith.
www.keithwilby.com

 

[destinman via AccessMonster.com]

I have written a program that I am selling to Chambers of Commerce. It does
their billing, records payments, provides a variety of collection tools, a
myriad of reports, a member contact data function and various email options.
I called on a Chamber that is consolidated in with a Industrial Dev Found and
Main Street Assn. They are interested in a program that can easily handle
the above functions for all three organizations. What I am interested in
doing is setting up a Member Data only application ( only have to enter a
Member once )and linking it to separate applications for each organization.
I figure this way I would only have to change query parameters for various
functions in each separate program to run all the features provided. If I
tried to write one big progam I think I would have to create a separate
query ( 2 more ) for each function provided in the original program . I
would like for the user, once they have opened the Member Data application,
to be able to open up the program needed from a menu in the Member Data
application.

I may not have explained this clearly, but any guidance you could give me

Is possible to open another Access program from an Access program that is
currently running ? I know you can run two separate Access programs at

[quoted text clipped - 4 lines]

to
do this ?

What are you trying to achieve?

Keith.
www.keithwilby.com