W
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.
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.