|
code
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
user-defined type not definedI get the above message when trying to run my program. I checked the error in
MSDN and it said to add DAO350.DLL to the References. I did this and I still get the error. Does anyone know what else I need to do? Thanks. "Jim Robb" <JimR***@discussions.microsoft.com> wrote in message Run it in the IDE and when the error occurs it will highlight the error news:169CA363-F531-467F-BD8B-7E943FE8703A@microsoft.com... >I get the above message when trying to run my program. I checked the error >in > MSDN and it said to add DAO350.DLL to the References. I did this and I > still > get the error. Does anyone know what else I need to do? line. Then post it here if the solution isn't obvious to you. More than likely it's something you've misspelled. Are you connecting to access?? What version of access?? If newer than 97
(that is if you connecting to Access 2000 or above then you need DAO 3.6) If you have Access 2000 or above installed in your machine then you already have DAO 3.6 installed. So reference DAO 3.6 Show quoteHide quote "Jim Robb" <JimR***@discussions.microsoft.com> wrote in message news:169CA363-F531-467F-BD8B-7E943FE8703A@microsoft.com... > I get the above message when trying to run my program. I checked the error in > MSDN and it said to add DAO350.DLL to the References. I did this and I still > get the error. Does anyone know what else I need to do? > Thanks. On Thu, 13 Oct 2005 06:03:02 -0700, "Jim Robb" <JimR***@discussions.microsoft.com> wrote: ¤ I get the above message when trying to run my program. I checked the error in ¤ MSDN and it said to add DAO350.DLL to the References. I did this and I still ¤ get the error. Does anyone know what else I need to do? ¤ Thanks. Please identify the line of code where the error occurs. Paul ~~~~ Microsoft MVP (Visual Basic) This is the line of code giving the error.
Public Function CreateLookupRS() As ADODB.Recordset Show quoteHide quote "Paul Clement" wrote: > On Thu, 13 Oct 2005 06:03:02 -0700, "Jim Robb" <JimR***@discussions.microsoft.com> wrote: > > ¤ I get the above message when trying to run my program. I checked the error in > ¤ MSDN and it said to add DAO350.DLL to the References. I did this and I still > ¤ get the error. Does anyone know what else I need to do? > ¤ Thanks. > > Please identify the line of code where the error occurs. > > > Paul > ~~~~ > Microsoft MVP (Visual Basic) > You need to reference:
Microsoft ActiveX Data Objects 2.x Library Where "x" is the latest version in you development machine. This will work fine with older versions on other machines unless you used features that are only available in later versions. Remove the reference to DAO unless the compiler complains. Show quoteHide quote "Jim Robb" <JimR***@discussions.microsoft.com> wrote in message news:35FA909B-7897-46A8-B4A5-800A6C08FC1D@microsoft.com... > This is the line of code giving the error. > > Public Function CreateLookupRS() As ADODB.Recordset > > "Paul Clement" wrote: > >> On Thu, 13 Oct 2005 06:03:02 -0700, "Jim Robb" >> <JimR***@discussions.microsoft.com> wrote: >> >> ¤ I get the above message when trying to run my program. I checked the >> error in >> ¤ MSDN and it said to add DAO350.DLL to the References. I did this and I >> still >> ¤ get the error. Does anyone know what else I need to do? >> ¤ Thanks. >> >> Please identify the line of code where the error occurs. >> >> >> Paul >> ~~~~ >> Microsoft MVP (Visual Basic) >> This worked great. Thanks to all who replied.
Show quoteHide quote "Someone" wrote: > You need to reference: > > Microsoft ActiveX Data Objects 2.x Library > > Where "x" is the latest version in you development machine. This will work > fine with older versions on other machines unless you used features that are > only available in later versions. > > Remove the reference to DAO unless the compiler complains. > > > > "Jim Robb" <JimR***@discussions.microsoft.com> wrote in message > news:35FA909B-7897-46A8-B4A5-800A6C08FC1D@microsoft.com... > > This is the line of code giving the error. > > > > Public Function CreateLookupRS() As ADODB.Recordset > > > > "Paul Clement" wrote: > > > >> On Thu, 13 Oct 2005 06:03:02 -0700, "Jim Robb" > >> <JimR***@discussions.microsoft.com> wrote: > >> > >> ¤ I get the above message when trying to run my program. I checked the > >> error in > >> ¤ MSDN and it said to add DAO350.DLL to the References. I did this and I > >> still > >> ¤ get the error. Does anyone know what else I need to do? > >> ¤ Thanks. > >> > >> Please identify the line of code where the error occurs. > >> > >> > >> Paul > >> ~~~~ > >> Microsoft MVP (Visual Basic) > >> > > > 
Other interesting topics
Difference in SQL Syntax between Access and MySQL (from VB6 project using ADO)
Using shellexecute...... run time error 5 Picture Box Question Help - Single-Select with Listbox... Amber Alert Ticker on VB6 Form VB IDE Not Integrating Visual SourceSafe Problem Problem offering font selection with listview in regions other than US Determine when report printed to specific printer Can subroutine in VB6 DLL accept array variable argument??? |
|||||||||||||||||||||||
