PDA

Click to See Complete Forum and Search --> : linking tables with code

HanneSThEGreaT
August 2nd, 2001, 04:56 PM
Hello, I'm relatively new to database programming. I've created this database with about 15 tables, I want to link one table with the rest with visual basic code OR with MS Access, but the problem with MS Access is that whatever I try doesn't seem to work...

Please Help

F. T. W.
Cimperiali
August 3rd, 2001, 03:15 AM
Is it an Access db?

Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, TCartwright, Bruno Paris
and all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.

The Rater
HanneSThEGreaT
August 3rd, 2001, 02:54 PM
Yes an Access 97 db. Can you help¿

F. T. W.
Cimperiali
August 6th, 2001, 02:14 AM
>>OR with MS Access
if you want to do it statically, go to menu Tools and select Relations. To do it dinamically, create a module and have a look at sintax of:

Dim db As Database
Set db = CurrentDb
db.CreateRelation
Hope this may help
Cesare


Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, TCartwright, Bruno Paris
and all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.

The Rater