Hello Friends,
I was wondering if anyone has experienced weird behavior in opening a Pan X database? This does not just happen on one Mac. You open the database in the normal way and you momentarily see the Data Entry form and then immediately closes.
Does a form open after the data sheet closes or does the entire database close? Do you have a .Initialize procedure which opens the sheet or a form?
Thank you for your reply. Judging by the response, this must not be a problem for anyone else.
This is a very complicated database that I have converted from Pan 6. It contains many veriables.
Below is the “.Initialize” statement.
Please let me know if you might see something that could trigger this intermittent behavior.
;This macro will initialize variables
Permanent «Late Letter»,«Letter #1»,«Letter #2»,«Letter #3»,«Letter #4»,«Letter #5»,«Letter #6»,«Letter #7»,«Letter #8»,«Letter #9»,«Letter #10»
;OpenFile “SGCS Teachers Lookup.18_19”
;OpenFile “SGCS Teachers Lookup.19_20”
;OpenFile “SGCS Family Info.18_19”
;OpenFile “SGCS Family Info.19_20”
GLOBAL Month,Grade,Sort,Format,EnvLab,Mon,SelTeach,Sel,SelAll,No.Families,Include,DoNot,«enroll11»,«Months»,«All»,«ReportDate7»,«ReportDate8»,«ReportDate9»,«ReportDate10»,«ReportDate11»,«ReportDate12»,«ReportDate13»,«ReportDate14»,«ReportDate15»,«ReportDate16»,«ReportDate17»,«ReportDate18»,«ReportDate19»,«ReportDate20»,VIP
GLOBAL «enroll1»,«enroll2»,«enroll3»,«DiscountSelect»,Sex,List2,List3,List4,List5,List6,List7,List8,List9,List10,List11,List12,List13,List14,List15,List16,List17,List18,List19,List20,List21,Pick,ID,Year,SelLab,PIP,Menu,ReportDate,«PIP Sort»,«Regis»,«Year»,«List Name»,«List2018-19»,«List2019-20»
«enroll11»=""
«enroll1»=""
«enroll2»=""
«enroll3»=""
List2=""
List3=""
List4=""
List5=""
List6=""
List7=""
List8=""
List9=""
List10=""
List11=""
List12=""
List13=""
List17=""
List18=""
List19=""
List20=""
List21=""
Grade=“K”
Sort=""
Format=“Format.1”
EnvLab=""
Mon=""
SelTeach=""
SelAll=""
Include=""
Pick=""
ID=""
Year=""
SelLab=""
PIP=""
VIP=""
Menu=""
Regis=""
«PIP Sort»=""
ReportDate=""
«List Name»=""
«Year»=""
«List2018-19»=""
«List2019-20»=""
«ReportDate20»=“2019/2020”
«Year»=“2019/2020”
;CloseWindow
makesecret
setactivedatabase “SGCS Family Info.19_20”
Openform “Data Entry”
SuperObject “List2019-20”,“FillList”
Call .FillList
SelectAll
GoForm “Data Entry”
Field “Account ID”