Autoforms and Access - relational DB

[Trish Smith]

Hi everyone,

I'd like some idea about how 'do-able' this is please. I've only dabbled
with VBA in Word and have a vague understanding of setting up relational
Access databases. I'm working in Office 2003.

Some time ago I tried out setting up an autoform and linking it to an Access
database as described in Dian Chapman's article
http://www.computorcompanion.com/LPMArticle.asp?ID=136 and it worked really
well. I've forgotten most of what I learnt doing this as my boss decided to
go with the paper and input to database route!!

I now have a project for which this would be perfect but I don't know if or
how the data can be sent from a Word Autoform to a database with multiple
tables.
The data will come from 50 plus training centres and will have a table
listing instructor details and then what courses they teach and other details
such as student numbers etc.

The code would have to designate Instructor_ID and then somehow link that ID
to the course.

I haven't done much working out on this yet as I really need to know whether
it is feasible (before driving myself crazy trying to figure out how the
Dian's code works) and if it is maybe some kind soul would give me some
pointers please.

Many thanks

 

[Doug Robbins - Word MVP]

It is definitely do-able and you just need to create the link to one table
and populate that with the relevant data and then create a link to the next
table and populate it with the relevant data etc.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

 

[Trish Smith]

Thank you Doug Now the fun starts!
--
Trish

It is definitely do-able and you just need to create the link to one table
and populate that with the relevant data and then create a link to the next
table and populate it with the relevant data etc.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com