importing hyperlink with text

[Mak_kap]

Hi All,

I am working on a creating a custom manual.
I have to make a access database then thru a form I have to present the manual in Word format.
The buliding blocks for manual will have different formats like paragraph, dot point, tabular data. I am storing all these formats in a single column under 'category' field.
Now my problem is that in some cells there is a whole paragraph which I have to copy to the database. This paragraph have some image which I have to hypelink with the corresponding image and then copy it to access sumhow
This is how I m storing in excel.

""Please find attached document""


As you can see the description is only 1 cell with all text data plus a "Fig1" hypelinked with corresponding image ans "section2" hypelinked with a different page.
I dont knw how to store it in database at first and then obviously extract it to word document.
Thanks in Advance for help
Regards,


MAK

[Mak_kap]

hey..

I am a newbie...so I mite not b THAT clear on asking what I actually want...
So if Any1 has any doubts plz feel free to post...
any/all suggestions r welcome...
still I m trying to figure out by myself..wht can b done..no luck


Regards,
MAK

[thhui]

Store the images separately from the access file.
Just add a file link on the text field in the access table.

[Mak_kap]

Hey...thanks for d reply thhui..

well.. when I am importing this particular cell as text... the link metioned with the text will also be imported as text n not a link..

like if you can c the attchment..the whole paragraph is imported as text in access, but it has some links in it too(Fig.1 and Section2)..which are behaving as text when i m importing this paragraph.

As far as i know...u can import a particular cell either as text or link..not a mix of both..and that is wht my problem is...

[thhui]

Database are just an ordered structure of data stored.
You cannot put a mixture of diffferent type on it.

The output of the form or report can be a mixture by
the program code or layout manipulation.

Further, the storage of OLE typed data is not an efficient way to store data
and it cannot be easily retrieved and called if you stored the pictures or images on it.

[orange]

Why exactly do you need to use Access?
Seems to me you could use Word to do the job.

[Mak_kap]

Thanks for d reply

@thhui: I have no other option other than goin for OLE type data... n I understand its hard to store and retrieve data... thts y i m struggling here...
but d problem remains with d data I have.
I was thinking....to break the paragraph in 3 parts...like text - link - text...3 cells...this mite work...but i wanted it all together...i will try with it...
can u suggest any other alternative?


@Orange: I m basically making a database to store a manual, which changes as per the requiremnet of customer and job type.
For example...its not fixed tht all d components should come in every manual, it can change. Plus description of same component in different manuals can be different.
Hence I need access to store all data n thru form retrieve it n make a manual.

[orange]

As thhui has said, Access for storing OLE is not a great idea. Many will tell you to take a different approach.

You may want to do some research on SGML/XML which has been used for storing manuals - with different descriptions,
terms, sections for different audiences - all in the same manual. There may be programs to help you with that.

Are you going to publish these manuals (in paper format)? On DVD with search etc? PDF ( to prevent unauthorized changes; built in search)?

I could see using Access to manage parts of the process and to inventory your chapters, manuals, who has what etc,
but not for storing the manual itself. If you stay with your plan to use Access in some form, I suggest a field pointing
to a file or paragraph, section or whatever.

PS:
I just did some googling and found this. It is a very interesting read and puts a few things into perspective.
Creating a useful, maintainable manual for a user/client

I'm not connected with the site in any way and suggest you only read the page at the link.
http://www.writeabooknow.com/manuals.html

Other info here:
http://www.thefreecountry.com/progra...uthoring.shtml

[Mak_kap]

Thanks for your suggestion Orange

I have some basic idea about XML but not SGML but I will look into it n as u say it is better for manuals n all, i will use thm rather than access.

Yeah we wil publish it in paper format and DVD with search too, that actually I havent thought of as to how it will be done.

Also I m using storing different parts of manuals in Access n not d manual itself.
I m thinking of My SQL here...lets c ...wht final structure I come up with..

Thanks again for your suggestions n quick reply.

[Mak_kap]

Thanks for d links orange...
but it dosnt really define wht to do n how to do..
anyways i will stick to wht I m doing n yeah...will workout ur suggestions as well...
n just hope to get good results...

Cheerss

MAK