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

Darren DICK d.dick at uws.edu.au
Wed Sep 8 00:57:21 CDT 2004


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





More information about the AccessD mailing list