.mdb.access数据库VBA-不引用Access对象库而使用Access的有关对象、属性和方法(先引用access对象库就是前绑定) |
时间:2025-01-20 08:52:33 来源: 作者: |
不引用Access对象库而使用Access的有关对象、属性和方法(先引用access对象库就是前绑定) 引用:microsoft access 9.0|10.0|11.0 object libraryyLa检测VBA 代码:与1-8不同处用颜色标出yLa检测VBA Public Sub1_8_1()yLa检测VBA Dim appAccess As object ‘定义Access应用程序对象变量yLa检测VBA Dim dbs As Object ‘定义数据库对象变量yLa检测VBA Dim myTbl As Object ‘定义数据表对象变量 yLa检测VBA Dim myFld As Variant ‘定义数据字段对象变量yLa检测VBA Dim myData As String ‘定义数据库名称变量yLa检测VBA Dim myTable As String ‘定义数据表名称变量yLa检测VBA yLa检测VBA ‘设置数据库名称(包括完整路径)yLa检测VBA myData = ThisWorkbook.Path & "\学生成绩管理.mdb"yLa检测VBA myTable = "期末成绩" ‘‘设置要创建的数据表名称yLa检测VBA ‘删除已存在的数据库yLa检测VBA On Error Resume NextyLa检测VBA Kill myDatayLa检测VBA On Error GoTo 0yLa检测VBA yLa检测VBA ‘创建一个新的microsoft access引用yLa检测VBA Set appAccess = createobject(“Access.application”)yLa检测VBA ‘创建一个新的Access数据库,并打开yLa检测VBA appAccess.NewCurrentDatabase myDatayLa检测VBA ‘设置当前打开的数据库变量(即返回当前在Access窗体中打开的数据库)yLa检测VBA Set dbs = appAccess.CurrentDbyLa检测VBA ‘创建数据表yLa检测VBA Set myTbl = dbs.CreateTableDef(myTable)yLa检测VBA ‘为数据表添加字段,并用append方法将这些字段添加到Fields集合里yLa检测VBA Set myFld = myTbl.CreateField("学号", 10, 10)yLa检测VBA myTbl.Fields.Append myFldyLa检测VBA Set myFld = myTbl.CreateField("姓名", 10, 6)yLa检测VBA myTbl.Fields.Append myFldyLa检测VBA Set myFld = myTbl.CreateField("性别", 10, 1)yLa检测VBA myTbl.Fields.Append myFldyLa检测VBA Set myFld = myTbl.CreateField("班级", 10, 10)yLa检测VBA myTbl.Fields.Append myFldyLa检测VBA Set myFld = myTbl.CreateField("数学", 6)yLa检测VBA myTbl.Fields.Append myFldyLa检测VBA Set myFld = myTbl.CreateField("语文", 6)yLa检测VBA myTbl.Fields.Append myFldyLa检测VBA Set myFld = myTbl.CreateField("物理", 6)yLa检测VBA myTbl.Fields.Append myFldyLa检测VBA Set myFld = myTbl.CreateField("化学", 6)yLa检测VBA myTbl.Fields.Append myFldyLa检测VBA Set myFld = myTbl.CreateField("英语", 6)yLa检测VBA myTbl.Fields.Append myFldyLa检测VBA Set myFld = myTbl.CreateField("总分", 6)yLa检测VBA myTbl.Fields.Append myFldyLa检测VBA ‘用append方法将数据表添加到tabledefs集合里yLa检测VBA dbs.TableDefs.Append myTblyLa检测VBA ‘关闭Access应用程序yLa检测VBA appAccess.QuityLa检测VBA ‘释放变量yLa检测VBA Set appAccess = NothingyLa检测VBA Set dbs = NothingyLa检测VBA Set myTbl = NothingyLa检测VBA Set myFld = NothingyLa检测VBA ‘弹出信息yLa检测VBA MsgBox "创建数据库成功!" & vbCrLf _yLa检测VBA & "数据库文件名为:" & myData & vbCrLf _yLa检测VBA & "数据表名称为:" & myTable & vbCrLf _yLa检测VBA & "保存位置:" & ThisWorkbook.Path, _yLa检测VBA vbOKOnly + vbInformation, "创建数据库"yLa检测VBA End SubyLa检测VBA yLa检测VBA |
|
|
|