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 ?

news:6260dc596c7ac@uwe...
What are you trying to achieve?

Keith.
www.keithwilby.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
on this would be appreciated.


Keith Wilby wrote:

self-signing certificate
Security - Is my way secure enough?
Zipping file
RE: ade to adp - utility available to help protect source code
Read only for staff
Lost mdw files
Clear Password through VBA
Workgroup Security/Electronic Signature (PW *after* logon)
Password , limit the number of trys, is it possible ???
workgroup information file & passwords