R
rbm
I have a form that will be used to enter information submitted to me on Word
files (comment sheets on procedure reviews). The files do not lend
themselves to being converted to text files and imported into an access
table. I would like to be able to click a button, choose the *.doc file from
the directory, select the file and have it display in a field on this data
entry form (linked OLE field?). I could then cut text (paragraphs) from Word
and paste it into a memo field on the form. I can program the button to find
the file I want, but that's where I am stuck.
The Access form will catalog all of these comments for use later. A single
word doc (comment sheet) will have multiple comments that I will put into
individual records in the database.
Essentially, I want to have a Word document displayed on half the form and
the rest of the fields on the other half. I don't want to have to work
between MS Word and Access (i.e., tile two windows).
Hope this makes some kind of sense. The more I try to explain it the more
confused I make myself.
files (comment sheets on procedure reviews). The files do not lend
themselves to being converted to text files and imported into an access
table. I would like to be able to click a button, choose the *.doc file from
the directory, select the file and have it display in a field on this data
entry form (linked OLE field?). I could then cut text (paragraphs) from Word
and paste it into a memo field on the form. I can program the button to find
the file I want, but that's where I am stuck.
The Access form will catalog all of these comments for use later. A single
word doc (comment sheet) will have multiple comments that I will put into
individual records in the database.
Essentially, I want to have a Word document displayed on half the form and
the rest of the fields on the other half. I don't want to have to work
between MS Word and Access (i.e., tile two windows).
Hope this makes some kind of sense. The more I try to explain it the more
confused I make myself.