在一个窗口中设计了一个按钮,使用到"SetLabel"函数,但总是提示错误,之后就关闭了"易表"文件,这个问题是时好时坏,公式写得没有问题,如果不修改的话运行正常,但在编辑时即使未做修改也不能保存,只有取消才能回到"易表"文件.我统计过,一个按钮只要有"SetLabel"函数,就可能发生类似的问题,很奇怪!
有回复请往我的邮箱中发个邮件提示,谢谢.
公式如下:FilterFor("日期"," = ",[日期],"箱号"," = ",[箱号]) And SetLabel("XH",Sumfor(Gridname,"数量","箱号","=",[箱号],0,0,1)) And SetLabel("XF",Sumfor(Gridname,"复出","箱号","=",[箱号],0,0,1)) And SetLabel("XP",Sumfor(Gridname,"无挂牌","箱号","=",[箱号],0,0,1)) And SetLabel("XT",Sumfor(Gridname,"数量","箱号","=",[箱号],0,0,1) +Sumfor(Gridname,"复出","箱号","=",[箱号],0,0,1) ) And Do(112) And FilterFor("日期"," = ",[日期]) And SetLabel("ZJ",Sumfor(Gridname,"数量",0,0,1)) And SetLabel("ZF",Sumfor(Gridname,"复出",0,0,1)) And SetLabel("ZP",Sumfor(Gridname,"无挂牌",0,0,1)) And SetLabel("ZT",Sumfor(Gridname,"数量",0,0,1) + Sumfor(Gridname,"复出",0,0,1)) And LOCKROW(ROW) And DO(100) And UnLockRow(Row) And SetLabel("JH","") And SetLabel("CH","") And SetLabel("JHYS","") And SetLabel("BCP","") And SetLabel("CCP","") And SetLabel("SCNL","") And SetLabel("LY","") And SetLabel("GHNL","")