Re: Copy first line of a memo field to a text field


alexsg@xxxxxxxxxx wrote:
I'm setting up a resolutions database where each resolution will be
copied from Word documents and pasted into a memo field. The resolution
will be in the form:

Resolution title <cr>
Project no <cr>
Date <cr>
Meeting Type <cr>
Resolution (up to several paragraphs separated by carriage returns
etc).

eg:

Inquiry into sportsground management
35002
20/07/06
Board Meeting
"That in relation to this issue we write to xyz, etc..."

The resolutions are often quite long and their formatting complex,
which precludes converting the memo into a table first up in Word. I
also want to copy each resolution with its formatting intact because as
well as being pasted into a text field it is also pasted into an rtf
field using Leban's rich text control. Each resolution has to be copied
manually - there is a lot of other stuff in the documents from which
they will be copied, which makes it difficult to do this
programatically - so I want to make the pasting into the Access table
as painless as possible.

Once the resolution is pasted into the text field, I simply want to
select and copy the first line only (the Resolution title) and paste it
into a text field in the same table. The line itself doesn't have to be
parsed - I'm happy to take everything as far as the carriage return.
I've seen a range of possible solutions but the've all tended to trying
to do something much more complex, like splitting lines into separate
words, etc (also my programming experience is fairly limited, espcially
in Access).

Ideally I'd like to be able to do the same to the 2nd, 3rd and 4th
lines, but this is not essential - its the first line that's the most
important as I want to have a resolutions title field.

Thanks

Alex

Forgot to add that I'm doing this via a form.

Alex

.

Relevant Pages

  • Re: How do I save as .jpg photos which have been pasted into word?
    ... to separate files. ... Another way is to copy the image and paste it into a graphics program (even ... Word will help with the output's resolution. ... > I have word documents with photos pasted into them, ...
    (microsoft.public.word.drawing.graphics)
  • RE: Why does saving a word document today cause the computer to cr
    ... reinstalled, but still no resolution. ... I really am stuck. ... hey i am having the same problem. ... I am no longer able to save word documents. ...
    (microsoft.public.word.docmanagement)
  • Re: Copy first line of a memo field to a text field
    ... Should give you everything upto the 1st, Resolution title would have to ... copied from Word documents and pasted into a memo field. ... The resolutions are often quite long and their formatting complex, ... words, etc (also my programming experience is fairly limited, espcially ...
    (comp.databases.ms-access)
  • Copy first line of a memo field to a text field
    ... I'm setting up a resolutions database where each resolution will be ... copied from Word documents and pasted into a memo field. ... words, etc (also my programming experience is fairly limited, espcially ...
    (comp.databases.ms-access)
  • Re: Putting a Timestamp in a memo field on a form.
    ... Do I need to add any code to the Resolution memo field to prevent ... the users from typing over what is already there when they click the command ... "Van T. Dinh" wrote: ...
    (microsoft.public.access.queries)