![]() | |
Last updated: before December, 1998
Written by Jerry Sikes <Unisource Converting>, 1997
(C) Copyright 1997 by Jerry Sikes
Permission is granted to freely copy this script in electronic form,
or to print for personal use. It may be used in any Approach database,
but may not be distributed for profit either by itself or as part of
a collection or database.
Disclaimer: This script is provided as is without any express or
implied warranties. The author assumes no responsibility for errors or
omissions, or for damages resulting from the use of the information contained
herein, or your own version containing your desires for the usage of the
script.
This global script is attached to an open macro in Approach which forces a
second application to open with the first eveytime. It also checks to see if
the app is aready open.
Sub OpenMyDocs
Dim MyDoc As String
Dim NumDocs As Integer
Dim Docs As Variant
Dim MyOpen As String
Dim fname As String
If(CurrentApplication.Documents.IsEmpty=False) Then
NumDocs = CurrentApplication.Documents.count
For i = 0 To NumDocs-1
Print CurrentApplication.Documents(i).Name
If CurrentApplication.Documents(i).Name="Scheduling" Then
MyOpen="True"
End If
Next
End If
If MyOpen ="True" Then
CurrentApplication.Scheduling.activate
Else
Set CurrentDocument= CurrentApplication.OpenDocument("Scheduling.apr","f:\orders")
End If
CurrentApplication.By_Assignment.activate
CurrentApplication.ApplicationWindow.domenucommand(IDM_TILE_TOP_BOTTOM)
End Sub