newbie needs examples of creating a recordset and inserting data using it in Access 2007?
in [Help]
|
Prev: solving a "ActiveX component can't create object or return reference to this object Run Time Error 429"
Next: solving a "ActiveX component can't create object or return referenceto this object Run Time Error 429"
From: Keven Denen on 31 May 2010 23:19 On May 30, 8:28 pm, r <r...(a)r.com> wrote: > 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 You need to add a reference to ADO before you can use it. If you insist on using ADO, you need to figure out why you can't get into your references. An alternate solution might be to think about using DAO as it is native to Access. Keven
From: r on 1 Jun 2010 09:14 On 5/31/2010 11:19 PM, Keven Denen wrote: >> >> Thanks > > You need to add a reference to ADO before you can use it. If you > insist on using ADO, you need to figure out why you can't get into > your references. An alternate solution might be to think about using > DAO as it is native to Access. > > Keven Thanks, that got fixed, but now i face another error http://groups.google.com/group/comp.databases.ms-access/browse_thread/thread/867cec635e5cc78a#
From: r on 1 Jun 2010 09:17
On 6/1/2010 9:14 AM, r wrote: > On 5/31/2010 11:19 PM, Keven Denen wrote: > >>> >>> Thanks >> >> You need to add a reference to ADO before you can use it. If you >> insist on using ADO, you need to figure out why you can't get into >> your references. An alternate solution might be to think about using >> DAO as it is native to Access. >> >> Keven > Thanks, that got fixed, but now i face another error > http://groups.google.com/group/comp.databases.ms-access/browse_thread/thread/867cec635e5cc78a# > Should clarify, the error of error of "Dim cnn1 As ADODB.Connection" as User defined Type not defined" got fixed, but the error at http://groups.google.com/group/comp.databases.ms-access/browse_thread/thread/867cec635e5cc78a# is still present. |