[AccessD] A2K: Used to work - now it errors SOLVED

If you are referencing both DAO and ADO in the same database, couldn't you
just add ADODB or DAO to your dimensions?
Dim dbs as DAO.Database

JR

-----Original Message-----
From: Darren DICK [mailto:d.dick at uws.edu.au]
Sent: Wednesday, September 08, 2004 2:30 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] A2K: Used to work - now it errors SOLVED

Moved DAO above ADO in the ref list now it works <sigh>
Now time to go and see what ADO stuff fails :-((

Thanks y'all

DD




-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK
Sent: Wednesday, 8 September 2004 3:57 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] A2K: Used to work - now it errors


Hello all
This used to work now I get Run Time Error 13 - Type Mismatch Then the
debugger yellows out the "Set rst" line

Any suggestions
Dao 3.6 is referenced


Dim dbs As Database
rst As Recordset
iBookingID As Integer

    Set dbs = CurrentDb
    iBookingID = [Forms]![frmBookings].[BookingID]
   
===> this line fails    Set rst = dbs.OpenRecordset("SELECT
[People].[PersonID] FROM People INNER JOIN BookingPeople ON
BookingPeople.PersonID = People.PersonID WHERE not isnull([EmailAddress])
and BookingID = " & iBookingID & ";", dbOpenDynaset)

Many thanks in advance

Have a great day

Darren


--
_______________________________________________
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



This electronic transmission is strictly confidential to TNCO, Inc. and
intended solely for the addressee. It may contain information which is
covered by legal, professional, or other privileges. If you are not the
intended addressee, or someone authorized by the intended addressee to
receive transmissions on behalf of the addressee, you must not retain,
disclose in any form, copy, or take any action in reliance on this
transmission. If you have received this transmission in error, please notify
the sender as soon as possible and destroy this message. While TNCO, Inc.
uses virus protection, the recipient should check this email and any
attachments for the presence of viruses. TNCO, Inc. accepts no liability for
any damage caused by any virus transmitted by this email.