Setting Left Join 
Author Message
 Setting Left Join

Hello everyone,

In Access 97 SR-2 I have VBA copy two tables and create a relationship
between them with CascadeUpdate and CascadeDelete enabled.  The problem
is that I need the Join Type to be Left, not Inner.  How do I accomplish
this in my module.

Thanks for any help.

Cindy Rovell



Sun, 02 Dec 2001 03:00:00 GMT  
 Setting Left Join
To make it a Left outer join, you would add 16777216 to the Attributes
bit field. For a Right outer join, you would add twice that: 33554432
I wasn't able to find this documented in the help file, so I just
fooled with some relations and checked the effect on their attributes
property.

 -- Andy

Quote:

>Hello everyone,

>In Access 97 SR-2 I have VBA copy two tables and create a relationship
>between them with CascadeUpdate and CascadeDelete enabled.  The problem
>is that I need the Join Type to be Left, not Inner.  How do I accomplish
>this in my module.

>Thanks for any help.

>Cindy Rovell



Mon, 03 Dec 2001 03:00:00 GMT  
 Setting Left Join
Thank you very much Andy!!!
Quote:

> To make it a Left outer join, you would add 16777216 to the Attributes
> bit field. For a Right outer join, you would add twice that: 33554432
> I wasn't able to find this documented in the help file, so I just
> fooled with some relations and checked the effect on their attributes
> property.

>  -- Andy


> >Hello everyone,

> >In Access 97 SR-2 I have VBA copy two tables and create a relationship
> >between them with CascadeUpdate and CascadeDelete enabled.  The problem
> >is that I need the Join Type to be Left, not Inner.  How do I accomplish
> >this in my module.

> >Thanks for any help.

> >Cindy Rovell



Mon, 03 Dec 2001 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. PRB: Left join behaves like a inner join.

2. Left Outer Join gives result set of Equal Join!

3. Left join Query error

4. Query Left Join Causes Access to crash only in Windows 2000

5. Left joins from code?

6. LEFT JOIN does not work in query

7. Deletion from LEFT JOINed tables - very basic question

8. updatable? Jet Recordset with LEFT JOIN

9. How to Left join more than two table ?

10. Deletion from LEFT JOINed tables - very basic question

11. SQL LEFT JOINS

12. LEFT JOIN QUERY

 

 
Powered by phpBB® Forum Software