VBA, Setting Left Join

Setting Left Join

Author	Message
C.Rovel #1 / 3	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

Andy Bar #2 / 3	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

C.Rovel #3 / 3	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

Page 1 of 1

[ 3 post ]