是这样的,
Dim app As New Access.Application我现在要在vb中用access 9.0 object libray的对象与方法连接access(中有两个子表),并插入数据(表的路径为m_sLocalPath)注:要求如此,郁闷中(Excel可以,但access的我不会)
Dim app As New Access.Application我现在要在vb中用access 9.0 object libray的对象与方法连接access(中有两个子表),并插入数据(表的路径为m_sLocalPath)注:要求如此,郁闷中(Excel可以,但access的我不会)
更改一下,是要非ado的方法
我的思路是想仿照vb中对excel的操作,
比如Dim app As New Excel.Application
Dim wb As Excel.Workbook
Set wb = app.Workbooks.Open(m_sLocalPath)
wb.Worksheets(1).Cells(4, 2).Value = m_sBeginDate但access我就不会了
Private mobjAccess As New Access.Application
Private mobj As ObjectPrivate Sub Form_Load()
mobjAccess.OpenCurrentDatabase App.Path & "\db1.mdb"
Set mobj = mobjAccess.DBEngine.Workspaces(0).Databases(0).OpenRecordset("select * from Expenses")
mobj.MoveFirst
Call GetRecordset(mobj)
End SubPrivate Sub GetRecordset(recExp As Recordset) With recExp
Text1.Text = 0 + !ExpenseID
End With
End Sub
还有,楼上的那个例子我找不到,能把连接贴出来吗,谢谢
Dim app As New Access.Application
app.OpenCurrentDatabase (m_sLocalPath)
app.CurrentDb.Execute (insertsql)
app.Quit但表中始终没有数据,不知为什么
Private Sub Form_Load()
mobjAccess.OpenCurrentDatabase App.Path & "\db1.mdb"
Set mobj = mobjAccess.DBEngine.Workspaces(0).Databases(0).OpenRecordset("select * from sample")
str1 = "insert into sample(mc) values('sss')"
mobjAccess.DBEngine.Workspaces(0).Databases(0).Execute (str1)
mobj.MoveFirst
Call GetRecordset(mobj)
'mobjAccess.DBEngine.Workspaces(0).Databases(0). _
' QueryDefs("ExpForOneEmployee").Parameters("EmpToFind"). _
' Value = mvarstrEmpToQuery
' Set mobjRecSetExpense = mobjAccess.DBEngine.Workspaces(0). _
' Databases(0).QueryDefs("ExpForOneEmployee"). _
' OpenRecordset()
'mblnQueryOpen = True
End Sub