代码:OptionCompareDatabasePrivateSubCommand0_Click()DimcnAsNewADODB.ConnectionDimrsAsNewADODB.RecordsetDimsqlAsStringSetcn=CurrentProject.ConnectionIfIsNull(w_id)AndIsNull(w_yhm)AndIsNull(w_ye)ThenMsgBox\"您确定要输出全部表单吗?\",vbOKOnly,\"提示\"Elsesql=\"select*From客户whereid=defds123w_idyhm=defds123w_yhmje=defds123w_ye\"\"\"rs.Opensql,cn,adOpenDynamic,adLockBatchOptimistic,adCmdTextIfNotrs.EOFThenList11=rsElseMsgBox\"没有记录\",vbOKOnlyvbInformation,\"提示\"w_id=\"\"EndIfEndIfrs.Closecn.CloseSetrs=NothingSetcn=NothingEndSub小弟今天刚学,可能有很多错误,劳烦大家修改下
|