C
Clint
I posted the information below a few days ago and then I
realized that I might be able to get by with doing a
search through the RTF documents based on user criteria.
There are hundreds of these RTF docs currently saved and
I thought this might be a faster way then converting them
into records.
As an example, if the user picks "rr00f" as filter
criteria, then I could look through every doc to find the
ones that have that exact text and then either list them
with a link to open the doc or just open them. Of
course, the users will be picking many different values
to filter by, so the actual number of docs that have
their combination of values would be small.
What do you think? Is this viable? I am clueless about
the code to use to do this, but I imagine it could be
very simple.
Thanks again,
Clint
MY ORIGINAL POST:
I have a client who has about 600 RTF documents that they
want to view in an Access 2000 DB. Oddly enough, the
RTFs were generated from the very same database (output
from a report). It won't be enough to just link and open
the RTF, unless there was a way for the user to specify
sorting and filtering criteria from WITHIN the RTFs
I though there might be a way to read an RTF doc line by
line and parse out the text. Basically, the RTFs consist
of several field label names and appropriate data for
each label. Most of the docs have the same label names
and there is a colon after every label that separates the
label from the data.
I would even consider a multi-step process, like
converting to another format and then importing into
Access.
I'm probably missing a lot of detail so if I need to post
more info, just let me know. I would attach a sample RTF
if I could. Any help would be greatly appreciated.
Thanks,
Clint
realized that I might be able to get by with doing a
search through the RTF documents based on user criteria.
There are hundreds of these RTF docs currently saved and
I thought this might be a faster way then converting them
into records.
As an example, if the user picks "rr00f" as filter
criteria, then I could look through every doc to find the
ones that have that exact text and then either list them
with a link to open the doc or just open them. Of
course, the users will be picking many different values
to filter by, so the actual number of docs that have
their combination of values would be small.
What do you think? Is this viable? I am clueless about
the code to use to do this, but I imagine it could be
very simple.
Thanks again,
Clint
MY ORIGINAL POST:
I have a client who has about 600 RTF documents that they
want to view in an Access 2000 DB. Oddly enough, the
RTFs were generated from the very same database (output
from a report). It won't be enough to just link and open
the RTF, unless there was a way for the user to specify
sorting and filtering criteria from WITHIN the RTFs
I though there might be a way to read an RTF doc line by
line and parse out the text. Basically, the RTFs consist
of several field label names and appropriate data for
each label. Most of the docs have the same label names
and there is a colon after every label that separates the
label from the data.
I would even consider a multi-step process, like
converting to another format and then importing into
Access.
I'm probably missing a lot of detail so if I need to post
more info, just let me know. I would attach a sample RTF
if I could. Any help would be greatly appreciated.
Thanks,
Clint