Doug Steele
dbdoug at gmail.com
Sat Apr 18 12:17:22 CDT 2009
If you look at the object browser, there is a 'Field' object for DAO, Excel, and Word. The 'Field' object for Word doesn't have the member 'Name'. If your Word library reference is ABOVE the DAO/database library reference in your reference list, then when you define a Field, it will be a Word field, not a DAO field. Try dimming field as DAO.Field and see if this fixes it. Doug Steele On Sat, Apr 18, 2009 at 8:43 AM, Rocky Smolin <rockysmolin at bchacc.com>wrote: > Another oddity. With fld Dimmed as Field, the Access 2007 compiler barfs > on > fld.Name with "Method or data member not found" when compiling the accdb. > But it will compile the mdb. Removing the reference to Word 12.0 library > eliminates the compile problem in the accdb. > > Can anyone shed any light on this one? > > MTIA > > Rocky > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin > Sent: Saturday, April 18, 2009 8:35 AM > To: 'Access Developers discussion and problem solving' > Subject: Re: [AccessD] Convert mdb to accdb Problem > > So here's what I found: it was the Microsoft Visual Basic for Applications > Extensibility 5.3 that was causing the problem. The app opens fine with > that reference removed even with the Microsoft Office 12.0 Access Database > Engine Object Library referenced. > > This is a massive application and so I'm going to let the client know > what's > up and let him test all the functions. But in general in 2007 what is lost > when you remove the VBAE 5.3 library? > > And does anyone know if the DAO library is now part of the 12.0 Access > Database Engine Object? > > Rocky > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele > Sent: Saturday, April 18, 2009 7:27 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Convert mdb to accdb Problem > > I tried this in Access 2007, and found that it works with the following > references, in order: > VBA > MS Access 12.0 Object Library > OLE Automation > MS DAO 3.6 Object Library. > > If I try to add the MS Office 12.0 Access database engine... reference, I > get the same message as you, and the message goes away if I remove the DAO > library. So they conflict. > > However, if I replace the DAO library with the Office 12.0 Access database > engine library, the code starts working again. > > Doug > > > On Fri, Apr 17, 2009 at 5:20 PM, Rocky Smolin <rockysmolin at bchacc.com > >wrote: > > > Dear List: > > > > I converted an mdb to 2007 format - accdb. When I start the accdb I > > get an error in code in the Open event of the opening form - 'type > > mismatch'. It's on the line > > > > For each prp in db.Properties > > > > > > > > prp is Dimmed as Property > > > > db is Dimmed as CurrentDb > > > > References are set to VBA, Access 12.0 Object Library, OLE Automation, > > CDO for Windows 2000 Library (legacy app, you understand) , Calendar > > Control for 2007, Visual Basic for Applications Extensibility, Word > > 12.0 Object Library, and 12.0 Access database engine Objec (oops, ran > > off the side of the References Dialog box). > > > > Am I missing a reference? > > > > MTIA > > > > Rocky Smolin > > > > Beach Access Software > > > > 858-259-4334 > > > > www.e-z-mrp.com <http://www.e-z-mrp.com/> > > > > www.bchacc.com <http://www.bchacc.com/> > > > > > > > > > > > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >