Access Forms displaying records with mathemical formulas

[Wladdy]

Hi,

I need to create a MS Access database to manage a collection of
roughly 5,000 memos. Each memo is essentially a text, anywhere from 50
to 1,000 words, and most memos contain mathematical formulas requiring
specific formatting. Currently, the memos are scanned pictures and I
have designed an MS Access form enabling me to view each picture
according to where it is located.

I would now like to have all my pictures converted into searchable
documents (such as MS Word files) that I could easily manipulate and,
most importanlty, still view from within an MS Access database. My
general high-level question is: what is the best approach to this
problem?

1 - I currently use MS Access 2003, which to my knowledge cannot
directly handle memo fields with equations. Is is something that MS
Access 2007 could do? Should I upgrade?

2 - Assuming that I need to use Word (and its companion mathematical
editor MathType), should I save every picture as a small individual
file and link each each .doc file to an 'OLE object' field in an
Access table? If so, how can I automate the linking process? For
instance, if my main table has an 'file ID' field with no duplicates,
how can I link with each record's 'OLE object' field the corresponding
c:\[Path]\[file ID].doc file?

3 - Since some memos are over one page long, I need to be able to
verically scoll through them from within a form. However, it seems
that the Object Frame box does not have scrolling capabilities. Did I
miss something? Is there a way around this problem?

Thank you for having read my question. I appreaciate in advance all
your comments and suggestions.

W.

 

[BruceM]

I cannot provide an answer, but I notice that this question has also been
posted in microsoft.public.access. Cross-post if you must (several groups
in the address line), but avoid multi-posting (separate messages to several
groups). This link has some more thoughts on the subject:
http://www.mvps.org/access/netiquette.htm

The link contains the following, among other things:

Multiposting is bad!
You commit the crime of multi-posting your questions
by posting the same question to several different
newsgroups, one at a time.

Several folks who could answer your questions take
this as a serious misuse of newsgroups and will likely
ignore your questions.

Crossposting is ok provided you include only the relevant newsgroups.
You can cross-post a message to different
newsgroups by including the newsgroup names
separated by a semi-colon.

Obviously, this feature is easily and often abused.

Don't be too surprised if you get a email message
complaining about your cross-posted message!


The mvps.org web site contains lots of useful information about Access, so
browse around a bit while you're there.

Hi,

I need to create a MS Access database to manage a collection of
roughly 5,000 memos. Each memo is essentially a text, anywhere from 50
to 1,000 words, and most memos contain mathematical formulas requiring
specific formatting. Currently, the memos are scanned pictures and I
have designed an MS Access form enabling me to view each picture
according to where it is located.

I would now like to have all my pictures converted into searchable
documents (such as MS Word files) that I could easily manipulate and,
most importanlty, still view from within an MS Access database. My
general high-level question is: what is the best approach to this
problem?

1 - I currently use MS Access 2003, which to my knowledge cannot
directly handle memo fields with equations. Is is something that MS
Access 2007 could do? Should I upgrade?

2 - Assuming that I need to use Word (and its companion mathematical
editor MathType), should I save every picture as a small individual
file and link each each .doc file to an 'OLE object' field in an
Access table? If so, how can I automate the linking process? For
instance, if my main table has an 'file ID' field with no duplicates,
how can I link with each record's 'OLE object' field the corresponding
c:\[Path]\[file ID].doc file?

3 - Since some memos are over one page long, I need to be able to
verically scoll through them from within a form. However, it seems
that the Object Frame box does not have scrolling capabilities. Did I
miss something? Is there a way around this problem?

Thank you for having read my question. I appreaciate in advance all
your comments and suggestions.

W.