[AccessD] Type Mismatch

Absolutely agree! Do not trust the sort order to solve your problems,
Martin. Declare everything either DAO or ADO and be done with it. No
ambiguities in your code, no problems for downstream maintenance
persons, no worries.

"If you haven't got time to do it right, where will you get the time to
do it again?"

Arthur

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Saturday, June 05, 2004 8:22 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Type Mismatch


Martin,

 If your not going to use both DAO and ADO, then you should uncheck one.
If you are going to use both, then you should start declaring everything
explicitly:

    Dim rst As DAO.Recordset
    Dim db As DAO.Database


Jim
(315) 699-3443
jimdettman at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Martin Caro
Sent: Friday, June 04, 2004 9:02 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Type Mismatch


Thanks Stuart

I didn't even consider references - I moved DAO up the list and the
error went away

Martin

----- Original Message -----
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Saturday, June 05, 2004 10:17 AM
Subject: Re: [AccessD] Type Mismatch


> On 5 Jun 2004 at 9:41, Bigpond wrote:
>
> > Hi folks
> >
> > I'm getting a Type Mismatch (13) error on the OpenRecordset line of 
> > the
following code
> >
> > Private Sub cmdTest_Click()
> >     Dim rst As Recordset
> >     Dim db As Database
> >     On Error GoTo HandleErrors
> >     Set db = CurrentDb()
> >     Set rst = db.OpenRecordset("SELECT DISTINCT ClientTypeID FROM
GBBClients")
> >     .
> >     .
> > End Sub
> >
> > I have checked the table "GBBClients" and the field "ClientTypeID" 
> > is a
number.
> > I inserted a text field called "ClientType" into the table and the
following line also give the same error.
> >
> >     Set rst = db.OpenRecordset("SELECT DISTINCT ClientType FROM
GBBClients")
> >
> > Is it so obvious that I can't see it??????
> >
>
> DAO/ADODB ? Do you have both referenced and if so, in what order. You 
> will get this error with an ADODB recordset.
>
>
>
>
>
>
> --
> Lexacorp Ltd
> http://www.lexacorp.com.pg
> Information Technology Consultancy, Software Development,System 
> Support.
>
>
>
> --
> _______________________________________________
> 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