VBA
Yong-Z
这个作者很懒,什么都没留下…
展开
-
Excel +VBA +ADO+Access数据库分页显示
新建类模块PageHelperOption ExplicitDim rs As ADODB.RecordsetDim rsds As ADODB.RecordsetDim rsPage As Long '当前处于第几页Dim labelName As String'分页查询 Sub queryPageFromRS(r As ADODB.Recordset, lbName A...原创 2020-03-01 14:47:16 · 1172 阅读 · 0 评论 -
Excel +VBA +ADO+Access (CRUD)数据库操作类
Option ExplicitDim cnn As ADODB.ConnectionDim rs As New ADODB.RecordsetProperty Get excel_driver()If Val(Application.Version) < 12 Then 'Excel版本为2003及2003以下 excel_driver = "Provider=Microso...原创 2020-03-01 14:41:18 · 938 阅读 · 0 评论 -
Excel +VBA +ADO+Access数据库(登录)
Excel +VBA +Access(登录)原创 2020-03-01 13:24:47 · 1111 阅读 · 0 评论 -
Excel +VBA +ADO+Access 数据库(CRUD) 增删改查分页进销存
Excel +VBA +Access (CRUD) 增删改查分页原创 2020-03-01 13:13:21 · 1725 阅读 · 1 评论