以为解决了,当i运行至10时,还是出现错误
我的代码是这样的:
For i = 1 To DateDiff("d", Me.开始日期, Me.结束日期)
DoCmd.RunSQL "insert into Tb_日历(日期,星期) values('" & Me.开始日期 & "'+'" & i & "' ,WeekdayName(weekday('" & Me.开始日期 & "'+'" & i & "')))"
Next
[attach]47509[/attach]作者: sgrshh29 时间: 2011-12-2 09:21
dim i as date
For i = Me.开始日期 to Me.结束日期
DoCmd.RunSQL "insert into Tb_日历(日期,星期) values(i ,WeekdayName(weekday(i))"
Next 作者: pq318 时间: 2011-12-2 09:27
access的数据排列是1,11,101,2,21,201这样来的,比较烦,另外,到了十进位到个位数的,我是用Formate函数解决,各位大侠要是有好的方法请赐教作者: kent_73 时间: 2011-12-2 09:34
sgrshh29 发表于 2011-12-2 09:21
dim i as date
For i = Me.开始日期 to Me.结束日期
DoCmd.RunSQL "insert into Tb_日历(日期,星期) valu ...