[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