editing memo fields/ Edit boxes.
I need to format ie. underline,bullet points etc.. memo fields in Foxpro
to be saved and viewed, edited at a later date. Can anyone give me any pointers.
Automation with word seems a little far off at the minute !!
[223 byte] By [
neil] at [2007-11-10 12:48:11]

# 1 Re: editing memo fields/ Edit boxes.
FoxPro memo fields store plain text (or binary files). You won't get any
formatting "as is".
Take a look at the Solutions sample that ships with VFP. There's an example
of using the RichText activeX control to store RTF in a memo field.
Dan
"neil" <neilw@tpgplc.co.uk> wrote in message
news:3e22df11$1@tnews.web.dev-archive.com...
>
> I need to format ie. underline,bullet points etc.. memo fields in Foxpro
> to be saved and viewed, edited at a later date. Can anyone give me any
pointers.
> Automation with word seems a little far off at the minute !!
>
# 2 Re: editing memo fields/ Edit boxes.
Thanks Dan
So is the only way to get complex letters from vfp to use something like
automation with word etc..
"Dan Freeman" <dan@dfapam.com> wrote:
>FoxPro memo fields store plain text (or binary files). You won't get any
>formatting "as is".
>
>Take a look at the Solutions sample that ships with VFP. There's an example
>of using the RichText activeX control to store RTF in a memo field.
>
>Dan
>
>
>
>"neil" <neilw@tpgplc.co.uk> wrote in message
>news:3e22df11$1@tnews.web.dev-archive.com...
>>
>> I need to format ie. underline,bullet points etc.. memo fields in Foxpro
>> to be saved and viewed, edited at a later date. Can anyone give me any
>pointers.
>> Automation with word seems a little far off at the minute !!
>>
>
>
neil at 2007-11-11 23:52:55 >

# 3 Re: editing memo fields/ Edit boxes.
Sorry maybe i should have mentioned:
There are about 30 standard letters that the user will need to choose from.
They might need to modify the letters, take peices out etc..
Should i create 30 reports and let the user modify them ??
How could i save the modified report for future reference ??
Use Automation ?
thanx in adv
neil
"neil" <neilw@tpgplc.co.uk> wrote:
>
>Thanks Dan
>
>So is the only way to get complex letters from vfp to use something like
>automation with word etc..
>
>"Dan Freeman" <dan@dfapam.com> wrote:
>>FoxPro memo fields store plain text (or binary files). You won't get any
>>formatting "as is".
>>
>>Take a look at the Solutions sample that ships with VFP. There's an example
>>of using the RichText activeX control to store RTF in a memo field.
>>
>>Dan
>>
>>
>>
>>"neil" <neilw@tpgplc.co.uk> wrote in message
>>news:3e22df11$1@tnews.web.dev-archive.com...
>>>
>>> I need to format ie. underline,bullet points etc.. memo fields in Foxpro
>>> to be saved and viewed, edited at a later date. Can anyone give me any
>>pointers.
>>> Automation with word seems a little far off at the minute !!
>>>
>>
>>
>
neil at 2007-11-11 23:53:59 >

# 4 Re: editing memo fields/ Edit boxes.
Sorry maybe i should have mentioned:
There are about 30 standard letters that the user will need to choose from.
They might need to modify the letters, take peices out etc..
Should i create 30 reports and let the user modify them ??
How could i save the modified report for future reference ??
Use Automation ?
thanx in adv
neil
"neil" <neilw@tpgplc.co.uk> wrote:
>
>Thanks Dan
>
>So is the only way to get complex letters from vfp to use something like
>automation with word etc..
>
>"Dan Freeman" <dan@dfapam.com> wrote:
>>FoxPro memo fields store plain text (or binary files). You won't get any
>>formatting "as is".
>>
>>Take a look at the Solutions sample that ships with VFP. There's an example
>>of using the RichText activeX control to store RTF in a memo field.
>>
>>Dan
>>
>>
>>
>>"neil" <neilw@tpgplc.co.uk> wrote in message
>>news:3e22df11$1@tnews.web.dev-archive.com...
>>>
>>> I need to format ie. underline,bullet points etc.. memo fields in Foxpro
>>> to be saved and viewed, edited at a later date. Can anyone give me any
>>pointers.
>>> Automation with word seems a little far off at the minute !!
>>>
>>
>>
>
neil at 2007-11-11 23:55:04 >

# 5 Re: editing memo fields/ Edit boxes.
On 14 Jan 2003 01:35:29 -0800, "neil" <neilw@tpgplc.co.uk> wrote:
>
>Sorry maybe i should have mentioned:
>
>There are about 30 standard letters that the user will need to choose from.
>They might need to modify the letters, take peices out etc..
>Should i create 30 reports and let the user modify them ??
>How could i save the modified report for future reference ??
>Use Automation ?
>thanx in adv
The Report Designer is available in the runtime, so you could create
the reports and let the users modify them.
If complex formatting is called for, you probably are better off
automating Word. In that case, you should create templates for each
different document and use those to create the actual documents as
needed. You can even provide the ability to modify the templates in
your application (via Automation).
Tamar
# 6 Re: editing memo fields/ Edit boxes.
What Tamar said. <g>
This thread is a prime example of why it's better to explain what you're
trying to do, instead of how you're trying to get there.
Dan
"neil" <neilw@tpgplc.co.uk> wrote in message
news:3e23d9e1$1@tnews.web.dev-archive.com...
>
> Sorry maybe i should have mentioned:
>
> There are about 30 standard letters that the user will need to choose
from.
> They might need to modify the letters, take peices out etc..
> Should i create 30 reports and let the user modify them ??
> How could i save the modified report for future reference ??
> Use Automation ?
> thanx in adv
>
> neil
>
>
> "neil" <neilw@tpgplc.co.uk> wrote:
> >
> >Thanks Dan
> >
> >So is the only way to get complex letters from vfp to use something like
> >automation with word etc..
> >
> >"Dan Freeman" <dan@dfapam.com> wrote:
> >>FoxPro memo fields store plain text (or binary files). You won't get any
> >>formatting "as is".
> >>
> >>Take a look at the Solutions sample that ships with VFP. There's an
example
> >>of using the RichText activeX control to store RTF in a memo field.
> >>
> >>Dan
> >>
> >>
> >>
> >>"neil" <neilw@tpgplc.co.uk> wrote in message
> >>news:3e22df11$1@tnews.web.dev-archive.com...
> >>>
> >>> I need to format ie. underline,bullet points etc.. memo fields in
Foxpro
> >>> to be saved and viewed, edited at a later date. Can anyone give me any
> >>pointers.
> >>> Automation with word seems a little far off at the minute !!
> >>>
> >>
> >>
> >
>
# 7 Re: editing memo fields/ Edit boxes.
Thanx for the help Tamar, Dan !!!
There are going to be about 100 000 letters a year that need to be saved
and viewed through the system. Any pointers on the best way forward. There
will be about 5 letters per PK. 20 000 records/PK's a year. So when i go
to record 1 there will be 5 saved letters for it that i need to view. Do
i save all these letters into a path\folder for each PK and a reference in
a letters table of the path of each letter ?
(Sorry Dan i think i might have done it again <g>)
Tamar E. Granor <> wrote:
>On 14 Jan 2003 01:35:29 -0800, "neil" <neilw@tpgplc.co.uk> wrote:
>
>>
>>Sorry maybe i should have mentioned:
>>
>>There are about 30 standard letters that the user will need to choose from.
>>They might need to modify the letters, take peices out etc..
>>Should i create 30 reports and let the user modify them ??
>>How could i save the modified report for future reference ??
>>Use Automation ?
>>thanx in adv
>
>The Report Designer is available in the runtime, so you could create
>the reports and let the users modify them.
>
>If complex formatting is called for, you probably are better off
>automating Word. In that case, you should create templates for each
>different document and use those to create the actual documents as
>needed. You can even provide the ability to modify the templates in
>your application (via Automation).
>
>Tamar
neil at 2007-11-11 23:58:02 >

# 8 Re: editing memo fields/ Edit boxes.
>There are about 30 standard letters that the user will need to choose from.
>They might need to modify the letters, take peices out etc..
I would do what TAMAR said and create thirty templates in word. Set up a
directory for each user. They can do a save as and name the modified letter
what ever they want to. Give them the option to open a modified letter or
just use the template. You can have as many letters has the size of the server(or
PC) will permit you.
# 9 Re: editing memo fields/ Edit boxes.
Sounds like a viable plan to me!
If you're only storing paths to free-standing doc files, you're limited only
by diskspace. Word is REALLY good at producing doc files (duh!). And your
clients get the benefit of whatever organizational bells and whistles you
put on top of it.
What's not to like?
Dan
(Your're doing fine! <g>)
"neil" <neilw@tpgplc.co.uk> wrote in message
news:3e2449e5$1@tnews.web.dev-archive.com...
>
> Thanx for the help Tamar, Dan !!!
>
> There are going to be about 100 000 letters a year that need to be saved
> and viewed through the system. Any pointers on the best way forward. There
> will be about 5 letters per PK. 20 000 records/PK's a year. So when i go
> to record 1 there will be 5 saved letters for it that i need to view. Do
> i save all these letters into a path\folder for each PK and a reference in
> a letters table of the path of each letter ?
>
> (Sorry Dan i think i might have done it again <g>)
>
>
> Tamar E. Granor <> wrote:
> >On 14 Jan 2003 01:35:29 -0800, "neil" <neilw@tpgplc.co.uk> wrote:
> >
> >>
> >>Sorry maybe i should have mentioned:
> >>
> >>There are about 30 standard letters that the user will need to choose
from.
> >>They might need to modify the letters, take peices out etc..
> >>Should i create 30 reports and let the user modify them ??
> >>How could i save the modified report for future reference ??
> >>Use Automation ?
> >>thanx in adv
> >
> >The Report Designer is available in the runtime, so you could create
> >the reports and let the users modify them.
> >
> >If complex formatting is called for, you probably are better off
> >automating Word. In that case, you should create templates for each
> >different document and use those to create the actual documents as
> >needed. You can even provide the ability to modify the templates in
> >your application (via Automation).
> >
> >Tamar
# 10 Re: editing memo fields/ Edit boxes.
Thanx Dan !!
Been a real help.
"Dan Freeman" <dan@dfapam.com> wrote:
>Sounds like a viable plan to me!
>
>If you're only storing paths to free-standing doc files, you're limited
only
>by diskspace. Word is REALLY good at producing doc files (duh!). And your
>clients get the benefit of whatever organizational bells and whistles you
>put on top of it.
>
>What's not to like?
>
>Dan
>
>(Your're doing fine! <g>)
>
>"neil" <neilw@tpgplc.co.uk> wrote in message
>news:3e2449e5$1@tnews.web.dev-archive.com...
>>
>> Thanx for the help Tamar, Dan !!!
>>
>> There are going to be about 100 000 letters a year that need to be saved
>> and viewed through the system. Any pointers on the best way forward. There
>> will be about 5 letters per PK. 20 000 records/PK's a year. So when i
go
>> to record 1 there will be 5 saved letters for it that i need to view.
Do
>> i save all these letters into a path\folder for each PK and a reference
in
>> a letters table of the path of each letter ?
>>
>> (Sorry Dan i think i might have done it again <g>)
>>
>>
>> Tamar E. Granor <> wrote:
>> >On 14 Jan 2003 01:35:29 -0800, "neil" <neilw@tpgplc.co.uk> wrote:
>> >
>> >>
>> >>Sorry maybe i should have mentioned:
>> >>
>> >>There are about 30 standard letters that the user will need to choose
>from.
>> >>They might need to modify the letters, take peices out etc..
>> >>Should i create 30 reports and let the user modify them ??
>> >>How could i save the modified report for future reference ??
>> >>Use Automation ?
>> >>thanx in adv
>> >
>> >The Report Designer is available in the runtime, so you could create
>> >the reports and let the users modify them.
>> >
>> >If complex formatting is called for, you probably are better off
>> >automating Word. In that case, you should create templates for each
>> >different document and use those to create the actual documents as
>> >needed. You can even provide the ability to modify the templates in
>> >your application (via Automation).
>> >
>> >Tamar
>
>
neil at 2007-11-12 0:01:04 >

# 11 Re: editing memo fields/ Edit boxes.
I don't think i could let the users save the docs as i need to show on the
system what letters have been written/saved for each record.
I would have to save the letters as the relevant template name + PK no (i
think) so that i know the exact path of each document(not the user ??), so
i can show these through the system after they have been saved ???
Sorry i might not be making much sense !
"Jarrett" <jcrudisill@Yahoo.com> wrote:
>
>
>>There are about 30 standard letters that the user will need to choose from.
>>They might need to modify the letters, take peices out etc..
>
> I would do what TAMAR said and create thirty templates in word. Set up
a
>directory for each user. They can do a save as and name the modified letter
>what ever they want to. Give them the option to open a modified letter or
>just use the template. You can have as many letters has the size of the
server(or
>PC) will permit you.
>
>
neil at 2007-11-12 0:02:11 >

# 12 Re: editing memo fields/ Edit boxes.
On 15 Jan 2003 01:50:56 -0800, "neil" <neilw@tpgplc.co.uk> wrote:
>
>I don't think i could let the users save the docs as i need to show on the
>system what letters have been written/saved for each record.
>I would have to save the letters as the relevant template name + PK no (i
>think) so that i know the exact path of each document(not the user ??), so
>i can show these through the system after they have been saved ???
>Sorry i might not be making much sense !
>
You can attach code to Word that takes action when the user saves a
document. I wrote about this in the October '02 issue of FoxPro
Advisor. (It's too complex to explain in a message.)
Tamar
# 13 Re: editing memo fields/ Edit boxes.
Thanks Tamar
I have got your automation book aswell, just trying to find the best solution,
not necessarily the one with the most bells and whistles !!
am not too good at bells and whistles anyway!!
Tamar E. Granor <> wrote:
>On 15 Jan 2003 01:50:56 -0800, "neil" <neilw@tpgplc.co.uk> wrote:
>
>>
>>I don't think i could let the users save the docs as i need to show on
the
>>system what letters have been written/saved for each record.
>>I would have to save the letters as the relevant template name + PK no
(i
>>think) so that i know the exact path of each document(not the user ??),
so
>>i can show these through the system after they have been saved ???
>>Sorry i might not be making much sense !
>>
>
>You can attach code to Word that takes action when the user saves a
>document. I wrote about this in the October '02 issue of FoxPro
>Advisor. (It's too complex to explain in a message.)
>
>Tamar
neil at 2007-11-12 0:04:10 >
