Beginners question: Hyperlinks into tables in a word document

[Jono]

I have a small, simple database storing information about each of 100
potential projects that need to be reviewed as part of my organisation's
05-06 planning process. I display one project at a time in a simple form
and allow review comments and ratings to be entered against each project.

However, the actual descriptions and other details of each of the projects
are stored separately in individual tables in a single 200-page MS Word
document. One project per table.
The document is unstructured other than a page break before each tables.

What I'd like to be able to do is - if required - access the relevant table
in the word document from my form, while reviewing the project database
record.

I'm not sure of the best approach? Create Bookmarks in the word doc and add
hyperlinks into the individual records in the database??? If so, how/where
do I store the hyperlinks?

Thanks for any assistance.

Jon

 

[Albert D. Kallal]

Hum, trying to pull data out of a word processor into a database is not very
flexible, nor very easy to do.

However, the actual descriptions and other details of each of the projects
are stored separately in individual tables in a single 200-page MS Word
document. One project per table.
The document is unstructured other than a page break before each tables.

The fact of the document being unstructured makes this problem even worse.

It seems to me that a database should have been designed, and you then send
this data to the word documents as needed.

What I'd like to be able to do is - if required - access the relevant
table
in the word document from my form, while reviewing the project database
record.

There is a tables collection in ms-word, and the coding to get at it would
be
quite complex...but you can do it. Not a simply simple task, but one for a
experienced developer with a good working knowledge of the word object
library.

I'm not sure of the best approach? Create Bookmarks in the word doc and
add
hyperlinks into the individual records in the database??? If so,
how/where
do I store the hyperlinks?

Huh..where did the book marks come from? You mean you have the labor and
manpower to go through those word documents and re-arrange the data, and
setup bookmakers for those tables? We "were" talking about going from word
to ms-access here..right? (or did I miss something?). To get at the word
data
via bookmarks you would have had to put the book marks in word in the first
place.

I mean if your are trying to go from ms-access to word, then that is
certainly
doable. and fill out a form letter, it is very easy to do. To fill table
data from ms-access into word is also doable (but again takes tricky code).

So, we got:

pulling data from word into ms-access is difficult
pulling data from a un-structured word document is more difficult

sending merge (fields) from one record into a word document is
easy (it is built in feature)

sending multiple records into a single word document as a
table is difficult

sending multiple records, one record for each
merge document is easy.

I have a nice working sample template system for ms-access that allows you
to mange, create and merge data from ms-access to word. You can give this
sample "super easy word merge" a try here:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html


Do note that the above allows EASY merging of data from ms-access into a
word document....but has no provisions for merging a "table" of data from
ms-access into a table in a word document (which is quite difficult..but
can be done)..

 

[Jono]

Thanks for taking the time to look at my question, Albert.
Yes, I agree, definitely better to have put ALL the project data into a
database to begin with but, unfortunately, someone built the Word tables
before I got involved!

Anyway, I know it's clunky but I'll just add the bookmarks to the document
and put the hyperlinks in the database.
thanks anyway.
Jon