Office中国论坛/Access中国论坛

标题: 求助语句问题 [打印本页]

作者: lingjiang 时间: 2005-8-20 20:38
标题: 求助语句问题
如何才能完整显示下列各表删除提示???我只能显示其中一个旅游系选修课报名表!!DoCmd.RunSQL "delete from [中文系选修课报名表]"

DoCmd.RunSQL "delete from [音乐小教班选修课报名表]"

DoCmd.RunSQL "delete from [艺术系选修课报名表]"

DoCmd.RunSQL "delete from [外语系选修课报名表]"

DoCmd.RunSQL "delete from [旅游系选修课报名表]"

DoCmd.RunSQL "delete from [经济与数学系选修课报名表]"

DoCmd.RunSQL "delete from [建筑与土木工程系选修课报名表]"

DoCmd.RunSQL "delete from [计算机与信息工程系选修课报名表]"

DoCmd.RunSQL "delete from [化学与环境工程系选修课报名表]"

DoCmd.RunSQL "delete from [电子工程系选修课报名表]"

[attach]12571[/attach]

作者: secowu 时间: 2005-8-20 21:04
DoCmd.RunSQL "delete from [音乐小教班选修课报名表]"

DoCmd.RunSQL "delete from [艺术系选修课报名表]"

DoCmd.RunSQL "delete from [外语系选修课报名表]"

DoCmd.RunSQL "delete from [旅游系选修课报名表]"

DoCmd.RunSQL "delete from [经济与数学系选修课报名表]"

DoCmd.RunSQL "delete from [建筑与土木工程系选修课报名表]"

DoCmd.RunSQL "delete from [计算机与信息工程系选修课报名表]"

DoCmd.RunSQL "delete from [化学与环境工程系选修课报名表]"

DoCmd.RunSQL "delete from [电子工程系选修课报名表]"＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝语句错了，得加上*DoCmd.RunSQL "delete  *  from [音乐小教班选修课报名表]"

DoCmd.RunSQL "delete  *  from [艺术系选修课报名表]"

DoCmd.RunSQL "delete  * from [外语系选修课报名表]"

DoCmd.RunSQL "delete  *  from [旅游系选修课报名表]"

DoCmd.RunSQL "delete  *  from [经济与数学系选修课报名表]"

DoCmd.RunSQL "delete from [建筑与土木工程系选修课报名表]"

DoCmd.RunSQL "delete from [计算机与信息工程系选修课报名表]"

DoCmd.RunSQL "delete from [化学与环境工程系选修课报名表]"

DoCmd.RunSQL "delete from [电子工程系选修课报名表]"========================>>>>

docmd.setwar....

作者: secowu 时间: 2005-8-20 21:06
用自己的提醒语句更好玩先禁止MS的提醒来个DoCMD.SetW...然后MsgBox "".....

作者: lingjiang 时间: 2005-8-21 02:35
和这一样DoCmd.RunSQL "delete from [音乐小教班选修课报名表]"

DoCmd.RunSQL "delete from [艺术系选修课报名表]"

DoCmd.RunSQL "delete from [外语系选修课报名表]"

DoCmd.RunSQL "delete from [旅游系选修课报名表]"

DoCmd.RunSQL "delete from [经济与数学系选修课报名表]"

DoCmd.RunSQL "delete from [建筑与土木工程系选修课报名表]"

DoCmd.RunSQL "delete from [计算机与信息工程系选修课报名表]"

DoCmd.RunSQL "delete from [化学与环境工程系选修课报名表]"

DoCmd.RunSQL "delete from [电子工程系选修课报名表]"[em05][em05][em05][em05][em05]

作者: hi-wzj 时间: 2005-8-21 02:50
如果仅是执行删除查询的话,在每执行一个删除查询前都会提示的

欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/)