标题:进度条问题请教
取消只看楼主
huangyz_xy
Rank: 2
等 级:论坛游民
帖 子:101
专家分:30
注 册:2016-10-2
结帖率:77.78%
已结贴  问题点数:15 回复次数:0 
进度条问题请教
我想在执行这段代码的时候加入进度条,不知道啷个玩,哪位神帮个忙?
Private Sub Cmd_Mail_Click()
   Call Find   
   SendMail Date & "备份文件", "请注意查收并保存", "D:\database.mdb" '发送邮件,文件会越来越大,所以越到后期,执行的时间就越长
 Kill "D:\database.mdb"
End Sub

Sub Find()
Dim TmpPath As String
  conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" & App.Path & "D:\database.mdb" & "';Persist Security Info=False"
  conn.Open
  If rst.State = adStateOpen Then rst.Close
       rst.Open "SELECT * FROM MSysObjects ", conn, adOpenKeyset, adLockOptimistic
          For intLoop = 0 To rst.RecordCount - 1
              If rst.Fields("database").Value <> "" Then
                 TmpPath = rst.Fields("database").Value
                 Exit For
              End If
          rst.MoveNext
          Next intLoop
 Set conn = Nothing
 Set rst = Nothing
  If TmpPath <> "" Then
     FileCopyEx TmpPath, "D:\database.mdb"
     Else
     FileCopyEx App.Path & "\datas\data.mdb", "D:\database.mdb"
 End If
End Sub
搜索更多相关主题的帖子: False 
2016-12-24 10:20



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-472853-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.664678 second(s), 8 queries.
Copyright©2004-2025, BCCN.NET, All Rights Reserved