If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
newbie needs examples of creating a recordset and inserting datausing it in Access 2007?
I have created a Access 2007 database, Test.mdb, created a table called
"mytest" and created required fields in it. Now, using VBA(Visual Basic for Applications) I want to insert data into it using a Recordset from a Word document. Can anyone please point me to a proper link where there is an example of how data is inserted using a Recordset into a Access 2007 table? I created one using resources on Web, but it is not correct. Sub TestRecordsetexample Dim cnn1 As ADODB.Connection Set cnn1 = CurrentProject.Connection Dim myRecordSet As New ADODB.Recordset myRecordSet.ActiveConnection = cnn1 myRecordSet.Open "[Test]" Dim myRecordSet As New ADODB.Recordset myRecordSet.ActiveConnection = cnn1 myRecordSet.Open “SELECT * FROM mytest” MsgBox myRecordSet.fields(0).value myRecordSet.Close cnn1.Close End Sub I get a compile time error for "Dim cnn1 As ADODB.Connection" as "User defined Type not defined" I want to choose Tools-References from the VBA Editor menu bar, but References is disabled and I cannot choose it. I guess I have to set up the connection from Word 2007(where the above code is present as a Macro) to Access 2007(where the database is) which I have not done. Any advice would be welcome on how to fix the above error and some examples of using Recordsets with Access 2007. Thanks |
Thread Tools | |
Display Modes | |
|
|