HELP PLEASE!!! ACCESS AND VB 
Author Message
 HELP PLEASE!!! ACCESS AND VB

Firstly thanks to all the people who have helpled me out in this NG before.

I am currently trying to join 4 tables an getting them to show in one form.

Here is what i have coded.

Private Sub form_load()

    'define database and recordset
    Dim qryclass As String
    Dim qdfclass As QueryDef

    'Define the query string, the querydef, and the recordsets in code.
    qryclass = "select * from tblTeacher, tblClass, tblVenue, tblCourse"
    qryclass = qryclass + " Where tblClass.courseid = tblCourse.courseid and
tblClass.venuecode = tblVenue.venuecode and tblClass.Teacherid =
tblTeacher.Teacherid"
    Set qdfclass = dbBrimbank.CreateQueryDef("", qryclass)
    Set rstClass = qdfclass.OpenRecordset(dbOpenDynaset, dbInconsistent)
    Displaydata

End Sub

with this code I get an error saying
                "RUN TIME ERROR '3615'"
                TYPE MISMATCH IN JOIN EXPRESSION

When I try and join 3 tables using this code i have no problems. I only have
troubles when i try and join 4.

ARHGHHHHH HELP

Thanks in advance.



Tue, 23 Apr 2002 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Help Please ! Access + ASP + VB Script

2. Need Help Please with Access, VB and Crystal Report

3. PLEASE HELP(LOGGING IN TO SECURE ACCESS DATABASE FROM VB)

4. DBF file access from VB - Help Please

5. Having problems with SIMPLE query in VB 6 and Access XP, Please Help

6. Please help with Seek / Msflex / vb / access problem

7. PLEASE HELP(LOGGING IN TO SECURE ACCESS DATABASE FROM VB)

8. VB and Access query PLEASE HELP

9. VB/Access 97 report help please

10. Please help with msflexgrid / vb / access - seek problem

11. please help with msflexgrid / access / vb seek problem

12. HELP required with VB and Access - PLEASE!!


 
Powered by phpBB® Forum Software