This VBA Statement will open a second instance of Access.
Dim RetVal
RetVal = Shell("FullPath To MSACCESS.EXE " & "FullPath To MDB
file" , 3)
Perhaps you can apply this to the condition that satisfies your
needs.
Note: "FullPath To " should be replaced with the appropriate paths
but must remain inside the quotes.
HTH,
Mitch
--- In [email protected], "lewiskidd"
<[EMAIL PROTECTED]> wrote:
> Dear All,
>
> Is there some kind person or people who can help me resolve a
> problem that I have ?
>
> Dependant upon the data entry to database 1 (resapps) I need to
> either a take no further actions (Instances of rejection) or
further
> action (Instances of acceptance) open database 2 (sholas).
>
> I was hoping that some form of vba code could perhaps be used,
there
> are two combo boxes that I feel sure hold the key to opening
> database 2 (sholas). If both the combo box offering granted or
> refused for final decision were used along with the member's combo
> box again offering granted and refused. If both selections of
> granted were made this would then invoke the vba code which in
turn
> would open the second database.
>
> Can someone please help me with this
>
>
>
> Rgds
>
>
>
> Lewis
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessVBACentral/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
