Yes, I did try the Set command. It hated it.
I was missing this statement.
set m_oSearchRptF = New CSearch
N.
> What are these 2 objects? is m_oSearchRptF.DBConnection an ADO connection
> and is DE01.HDConnect a dataenvironment connection object? if so did you
> try
> Set m_oSearchRptF.DBConnection = DE01.HDConnect
> Scot Rose, MCSD
> Microsoft Visual Basic Developer Support
> Want to know more? Check out the MSDN at msdn.microsoft.com or the
> Microsoft Knowledge Base at support.microsoft.com
> This posting is provided "AS IS", with no warranties, and confers no
rights.
> --------------------
> >Subject: Re: Error 13: Type Mismatch error
> >Date: Thu, 15 Nov 2001 11:52:00 -0700
> >Lines: 101
> >X-Priority: 3
> >X-MSMail-Priority: Normal
> >X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
> >X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
> >Newsgroups: microsoft.public.vb.database
> >NNTP-Posting-Host: te-64-113-215-70.transedge.com 64.113.215.70
> >Path: cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp02
> >Xref: cppssbbsa01.microsoft.com microsoft.public.vb.database:77508
> >X-Tomcat-NG: microsoft.public.vb.database
> >This was posted a while ago so I don't know if you will see this but . .
.
> >I'm getting this error when I am using a class module that I have built.
> >One class works perfectly the other is almost a carbon copy and uses the
> >same private declarations. The one that works is {*filter*}ized code from
an
> >example and the one that doesn't is a copy with modifications in the SQL
> >sections. (I never get as far as the SQL sections before I get the
error.)
> >I have a variable declared m_oSearch as CSearch in the general section of
> >the form.
> >The variable is used in a button_click.
> > m_oSearchRptF.DBConnection = DE01.HDConnect (It is at this statement
> that
> >I receive the error message - Error 13 Type Mismatch.)
> >CSearch class module:
> >Public Property Let DBConnection(ByVal oDBConnection As ADODB.Connection)
> > Set g_oDBConnection = oDBConnection
> > Call LoadSearchConditions
> >End Property
> >I have another form that has idential code and it operates flawlessly.
It
> >doesn't matter if I start the session and run the form that errors first,
> >its' very consistent, or the one that works first. One always works and
> the
> >other always doesn't.
> >Any ideas?
> >N.
> >> DO you have the same version (Or higher) of MDAC installed on your
users
> >> machine than is on yours development box?
> >> Is DAO referenced in you project (If it were a DAO issue I would expect
> it
> >> on more than one machine)
> >> When you installed the program did you use the PDW or just copy the EXE
> to
> >> the machine?
> >> Are you sure the error is occuring on a Data Access portion of the
code?
> >> (You could get this error just as easily trying to punch a text value
> into
> >> a Numeric datatype)
> >> Make sure that the same version or Higher than your machine of the
> >> MSVBVM60.DLL resides on the users machine.
> >> Just a few things. I can think of lots more if we need to that can
cause
> >> this error, but most of them have to do with having the proper DLL's
> >> installed, so IF you used the PDW, make sure the version of MDAC you
> >> installe don your users machine is the same version as the one you are
> >> running in your development environment (If you installed MDAC 2.5 make
> >> sure to put the file you downloaded in the \\Microsoft Visual
> >> Studio\VB98\Wizards\PDWizard\Redist folder and replace the one that is
> >> there.)
> >> --------------------
> >> >Subject: Error 13: Type Mismatch error
> >> >Date: Mon, 6 Aug 2001 09:57:24 -0400
> >> >Lines: 12
> >> >X-Priority: 3
> >> >X-MSMail-Priority: Normal
> >> >X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
> >> >X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
> >> >Newsgroups: microsoft.public.vb.database
> >> >NNTP-Posting-Host: 208.60.35.41
> >> >Path:
>cppssbbsa01.microsoft.com!news-out.cwix.com!newsfeed.cwix.com!newsfeed.yose
> m
>ite.net!nntp-relay.ihug.net!ihug.co.nz!newsfeed.online.be!newsfeed01.sul.t-
> o
> >> nline.de!newsfeed00.sul.t-online.de!t-online.de!tkmsftngp01!tkmsftngp03
> >> >Xref: cppssbbsa01.microsoft.com microsoft.public.vb.database:74235
> >> >X-Tomcat-NG: microsoft.public.vb.database
> >> >I keep getting this type mismatch error on one of my users machines.
I
> >am
> >> >not sure why this is happening, but there is a page that suggests that
> >DAO
> >> >has a highre priority than Active X data abjects.
> >> > http://www.*-*-*.com/
> >> >I am not using dao anywhere that Ii know of. If anyone else has
> >> experienced
> >> >Error 13 I could use some suggestions.
> >> >Thank you,
> >> >Bill Rieger