[Gary O]

I am gettiing a "Field Calculation Error" when using the following field code:

{set VacatePara ""}{ask Vacate "Is the tenant vacating the premises?"
\*Firstcap}{ask{if{Vacate}="Yes" "VacatePara"}"Amend 'Vacating' Paragaraph if
neccesary - otherwise press OK?" \d "This is to notify you that the tenant
named below has vacated the unit (address and effective date below) and the
Co-operative would like the AGL account transferred into its name."}{ref
VacatePara} {set StartPara ""}{ask Start "Is the tenant vacating the
premises?" \*Firstcap}{ask{if{Start}="Yes" "StartPara"}"Amend 'Starting'
Paragaraph if neccesary - otherwise press OK?" \d "This is to notify you that
the tenant named below has vacated the unit (address and effective date
below) and the Co-operative would like the AGL account transferred into its
name."}{ref StartPara}

My problems a

1 - What other code do I need to add to stop the error.
2 - If I don't have Word open and run the merge from Access, the Menu
toolbar does not display which means I can't print off the merged document.
3 - How do I automatically get the merge document to display full screen,
currently even if I have Word open with another document, when the merge is
completed, all Word windows are resized to a smaller size.
4 - How do I make the popup ASK box larger so that all the default text can
be seen rather than having to use the scroll bar.

I hope I have described my problems clearly enough. If not, please let me
know and I will try and elaborate.

Once again, thank you all in anticipation of being able to resolve my
problems.

Regards

Gary O

[Doug Robbins - Word MVP]

I would do the asking in Access. I would suggest that you take a look at
fellow MVP Albert Kallal's "MergeSingleWord"
utility at:

http://www.members.shaw.ca/AlbertKal.../msaccess.html


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Gary O" wrote in message
news
I am gettiing a "Field Calculation Error" when using the following field
code:

{set VacatePara ""}{ask Vacate "Is the tenant vacating the premises?"
\*Firstcap}{ask{if{Vacate}="Yes" "VacatePara"}"Amend 'Vacating' Paragaraph
if
neccesary - otherwise press OK?" \d "This is to notify you that the tenant
named below has vacated the unit (address and effective date below) and
the
Co-operative would like the AGL account transferred into its name."}{ref
VacatePara} {set StartPara ""}{ask Start "Is the tenant vacating the
premises?" \*Firstcap}{ask{if{Start}="Yes" "StartPara"}"Amend 'Starting'
Paragaraph if neccesary - otherwise press OK?" \d "This is to notify you
that
the tenant named below has vacated the unit (address and effective date
below) and the Co-operative would like the AGL account transferred into
its
name."}{ref StartPara}

My problems a

1 - What other code do I need to add to stop the error.
2 - If I don't have Word open and run the merge from Access, the Menu
toolbar does not display which means I can't print off the merged
document.
3 - How do I automatically get the merge document to display full screen,
currently even if I have Word open with another document, when the merge
is
completed, all Word windows are resized to a smaller size.
4 - How do I make the popup ASK box larger so that all the default text
can
be seen rather than having to use the scroll bar.

I hope I have described my problems clearly enough. If not, please let me
know and I will try and elaborate.

Once again, thank you all in anticipation of being able to resolve my
problems.

Regards

Gary O

[Gary O]

"Doug Robbins - Word MVP" wrote:

I would do the asking in Access. I would suggest that you take a look at
fellow MVP Albert Kallal's "MergeSingleWord"
utility at:

http://www.members.shaw.ca/AlbertKal.../msaccess.html


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Gary O" wrote in message
news
I am gettiing a "Field Calculation Error" when using the following field
code:

{set VacatePara ""}{ask Vacate "Is the tenant vacating the premises?"
\*Firstcap}{ask{if{Vacate}="Yes" "VacatePara"}"Amend 'Vacating' Paragaraph
if
neccesary - otherwise press OK?" \d "This is to notify you that the tenant
named below has vacated the unit (address and effective date below) and
the
Co-operative would like the AGL account transferred into its name."}{ref
VacatePara} {set StartPara ""}{ask Start "Is the tenant vacating the
premises?" \*Firstcap}{ask{if{Start}="Yes" "StartPara"}"Amend 'Starting'
Paragaraph if neccesary - otherwise press OK?" \d "This is to notify you
that
the tenant named below has vacated the unit (address and effective date
below) and the Co-operative would like the AGL account transferred into
its
name."}{ref StartPara}

My problems a

1 - What other code do I need to add to stop the error.
2 - If I don't have Word open and run the merge from Access, the Menu
toolbar does not display which means I can't print off the merged
document.
3 - How do I automatically get the merge document to display full screen,
currently even if I have Word open with another document, when the merge
is
completed, all Word windows are resized to a smaller size.
4 - How do I make the popup ASK box larger so that all the default text
can
be seen rather than having to use the scroll bar.

I hope I have described my problems clearly enough. If not, please let me
know and I will try and elaborate.

Once again, thank you all in anticipation of being able to resolve my
problems.

Regards

Gary O





Doug,

I am using that utility and am getting the above problems whilst using it.

Does anyone have any further suggestions?

Regards

Gary O

[Doug Robbins - Word MVP]

Did you really look at that article. The method there is nothing like what
you posted using Fields.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Gary O" wrote in message
...
"Doug Robbins - Word MVP" wrote:

I would do the asking in Access. I would suggest that you take a look at
fellow MVP Albert Kallal's "MergeSingleWord"
utility at:

http://www.members.shaw.ca/AlbertKal.../msaccess.html


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Gary O" wrote in message
news
I am gettiing a "Field Calculation Error" when using the following field
code:

{set VacatePara ""}{ask Vacate "Is the tenant vacating the premises?"
\*Firstcap}{ask{if{Vacate}="Yes" "VacatePara"}"Amend 'Vacating'
Paragaraph
if
neccesary - otherwise press OK?" \d "This is to notify you that the
tenant
named below has vacated the unit (address and effective date below) and
the
Co-operative would like the AGL account transferred into its
name."}{ref
VacatePara} {set StartPara ""}{ask Start "Is the tenant vacating the
premises?" \*Firstcap}{ask{if{Start}="Yes" "StartPara"}"Amend
'Starting'
Paragaraph if neccesary - otherwise press OK?" \d "This is to notify
you
that
the tenant named below has vacated the unit (address and effective date
below) and the Co-operative would like the AGL account transferred into
its
name."}{ref StartPara}

My problems a

1 - What other code do I need to add to stop the error.
2 - If I don't have Word open and run the merge from Access, the Menu
toolbar does not display which means I can't print off the merged
document.
3 - How do I automatically get the merge document to display full
screen,
currently even if I have Word open with another document, when the
merge
is
completed, all Word windows are resized to a smaller size.
4 - How do I make the popup ASK box larger so that all the default text
can
be seen rather than having to use the scroll bar.

I hope I have described my problems clearly enough. If not, please let
me
know and I will try and elaborate.

Once again, thank you all in anticipation of being able to resolve my
problems.

Regards

Gary O





Doug,

I am using that utility and am getting the above problems whilst using it.

Does anyone have any further suggestions?

Regards

Gary O

[Gary O]

Doug,

The code extract does not use any field from the access database. All the
merge fields from access are exporting to word correctlt (I assume) as I have
used the macros to create numerous merge documents.

I don't know how the macro code has anything to do with the last 3 questions
I asked for assistance with, namely:

1 - how to ensure the main toolbar displays when the merge is run WITHOUT
Word being open - currently it runs but there is no way to save or print the
merge document.

2 - how to open the merged document at full screen rather than what it is
which is smaller than 600x800.

3 - how to resize the ASK popup box.

Thanks for any assistance.

Regards

Gary O

2 -

"Doug Robbins - Word MVP" wrote:

Did you really look at that article. The method there is nothing like what
you posted using Fields.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Gary O" wrote in message
...
"Doug Robbins - Word MVP" wrote:

I would do the asking in Access. I would suggest that you take a look at
fellow MVP Albert Kallal's "MergeSingleWord"
utility at:

http://www.members.shaw.ca/AlbertKal.../msaccess.html


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Gary O" wrote in message
news I am gettiing a "Field Calculation Error" when using the following field
code:

{set VacatePara ""}{ask Vacate "Is the tenant vacating the premises?"
\*Firstcap}{ask{if{Vacate}="Yes" "VacatePara"}"Amend 'Vacating'
Paragaraph
if
neccesary - otherwise press OK?" \d "This is to notify you that the
tenant
named below has vacated the unit (address and effective date below) and
the
Co-operative would like the AGL account transferred into its
name."}{ref
VacatePara} {set StartPara ""}{ask Start "Is the tenant vacating the
premises?" \*Firstcap}{ask{if{Start}="Yes" "StartPara"}"Amend
'Starting'
Paragaraph if neccesary - otherwise press OK?" \d "This is to notify
you
that
the tenant named below has vacated the unit (address and effective date
below) and the Co-operative would like the AGL account transferred into
its
name."}{ref StartPara}

My problems a

1 - What other code do I need to add to stop the error.
2 - If I don't have Word open and run the merge from Access, the Menu
toolbar does not display which means I can't print off the merged
document.
3 - How do I automatically get the merge document to display full
screen,
currently even if I have Word open with another document, when the
merge
is
completed, all Word windows are resized to a smaller size.
4 - How do I make the popup ASK box larger so that all the default text
can
be seen rather than having to use the scroll bar.

I hope I have described my problems clearly enough. If not, please let
me
know and I will try and elaborate.

Once again, thank you all in anticipation of being able to resolve my
problems.

Regards

Gary O





Doug,

I am using that utility and am getting the above problems whilst using it.

Does anyone have any further suggestions?

Regards

Gary O

[Doug Robbins - Word MVP]

In response to your third question, my suggestion is that you use a form in
Access for the input of the information that is being entered into the Ask
pop up.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Gary O" wrote in message
news
Doug,

The code extract does not use any field from the access database. All the
merge fields from access are exporting to word correctlt (I assume) as I
have
used the macros to create numerous merge documents.

I don't know how the macro code has anything to do with the last 3
questions
I asked for assistance with, namely:

1 - how to ensure the main toolbar displays when the merge is run WITHOUT
Word being open - currently it runs but there is no way to save or print
the
merge document.

2 - how to open the merged document at full screen rather than what it is
which is smaller than 600x800.

3 - how to resize the ASK popup box.

Thanks for any assistance.

Regards

Gary O

2 -

"Doug Robbins - Word MVP" wrote:

Did you really look at that article. The method there is nothing like
what
you posted using Fields.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Gary O" wrote in message
...
"Doug Robbins - Word MVP" wrote:

I would do the asking in Access. I would suggest that you take a look
at
fellow MVP Albert Kallal's "MergeSingleWord"
utility at:

http://www.members.shaw.ca/AlbertKal.../msaccess.html


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Gary O" wrote in message
news I am gettiing a "Field Calculation Error" when using the following
field
code:

{set VacatePara ""}{ask Vacate "Is the tenant vacating the
premises?"
\*Firstcap}{ask{if{Vacate}="Yes" "VacatePara"}"Amend 'Vacating'
Paragaraph
if
neccesary - otherwise press OK?" \d "This is to notify you that the
tenant
named below has vacated the unit (address and effective date below)
and
the
Co-operative would like the AGL account transferred into its
name."}{ref
VacatePara} {set StartPara ""}{ask Start "Is the tenant vacating the
premises?" \*Firstcap}{ask{if{Start}="Yes" "StartPara"}"Amend
'Starting'
Paragaraph if neccesary - otherwise press OK?" \d "This is to notify
you
that
the tenant named below has vacated the unit (address and effective
date
below) and the Co-operative would like the AGL account transferred
into
its
name."}{ref StartPara}

My problems a

1 - What other code do I need to add to stop the error.
2 - If I don't have Word open and run the merge from Access, the
Menu
toolbar does not display which means I can't print off the merged
document.
3 - How do I automatically get the merge document to display full
screen,
currently even if I have Word open with another document, when the
merge
is
completed, all Word windows are resized to a smaller size.
4 - How do I make the popup ASK box larger so that all the default
text
can
be seen rather than having to use the scroll bar.

I hope I have described my problems clearly enough. If not, please
let
me
know and I will try and elaborate.

Once again, thank you all in anticipation of being able to resolve
my
problems.

Regards

Gary O





Doug,

I am using that utility and am getting the above problems whilst using
it.

Does anyone have any further suggestions?

Regards

Gary O

[macropod]

Hi Gary,

You have some bugs in your field coding. Try:

{set VacatePara ""}
{ask Vacate "Is the tenant vacating the premises?" \*Firstcap}
{if{Vacate}= "Y*" {ask VacatePara "Amend 'Vacating' Paragaraph if neccesary -
otherwise press OK?" \d "This is to notify you that the tenant named below has
vacated the unit (address and effective date below) and the Co-operative would
like the AGL account transferred into its name."}}
{ref VacatePara}

Be careful to keep the spacing indicated in '}= "Y*" {'.

As for changing the size of the ASK field, you can't.

To ensure the fields all update together, try wrapping the lot in a QUOTE
field.

Cheers

--
macropod
[MVP - Microsoft Word]


"Gary O" wrote in message
news | Doug,
|
| The code extract does not use any field from the access database. All the
| merge fields from access are exporting to word correctlt (I assume) as I
have
| used the macros to create numerous merge documents.
|
| I don't know how the macro code has anything to do with the last 3 questions
| I asked for assistance with, namely:
|
| 1 - how to ensure the main toolbar displays when the merge is run WITHOUT
| Word being open - currently it runs but there is no way to save or print the
| merge document.
|
| 2 - how to open the merged document at full screen rather than what it is
| which is smaller than 600x800.
|
| 3 - how to resize the ASK popup box.
|
| Thanks for any assistance.
|
| Regards
|
| Gary O
|
| 2 -
|
| "Doug Robbins - Word MVP" wrote:
|
| Did you really look at that article. The method there is nothing like
what
| you posted using Fields.
|
| --
| Hope this helps.
|
| Please reply to the newsgroup unless you wish to avail yourself of my
| services on a paid consulting basis.
|
| Doug Robbins - Word MVP
|
| "Gary O" wrote in message
| ...
| "Doug Robbins - Word MVP" wrote:
|
| I would do the asking in Access. I would suggest that you take a look
at
| fellow MVP Albert Kallal's "MergeSingleWord"
| utility at:
|
| http://www.members.shaw.ca/AlbertKal.../msaccess.html
|
|
| --
| Hope this helps.
|
| Please reply to the newsgroup unless you wish to avail yourself of my
| services on a paid consulting basis.
|
| Doug Robbins - Word MVP
|
| "Gary O" wrote in message
| news | I am gettiing a "Field Calculation Error" when using the following
field
| code:
|
| {set VacatePara ""}{ask Vacate "Is the tenant vacating the premises?"
| \*Firstcap}{ask{if{Vacate}="Yes" "VacatePara"}"Amend 'Vacating'
| Paragaraph
| if
| neccesary - otherwise press OK?" \d "This is to notify you that the
| tenant
| named below has vacated the unit (address and effective date below)
and
| the
| Co-operative would like the AGL account transferred into its
| name."}{ref
| VacatePara} {set StartPara ""}{ask Start "Is the tenant vacating the
| premises?" \*Firstcap}{ask{if{Start}="Yes" "StartPara"}"Amend
| 'Starting'
| Paragaraph if neccesary - otherwise press OK?" \d "This is to notify
| you
| that
| the tenant named below has vacated the unit (address and effective
date
| below) and the Co-operative would like the AGL account transferred
into
| its
| name."}{ref StartPara}
|
| My problems a
|
| 1 - What other code do I need to add to stop the error.
| 2 - If I don't have Word open and run the merge from Access, the Menu
| toolbar does not display which means I can't print off the merged
| document.
| 3 - How do I automatically get the merge document to display full
| screen,
| currently even if I have Word open with another document, when the
| merge
| is
| completed, all Word windows are resized to a smaller size.
| 4 - How do I make the popup ASK box larger so that all the default
text
| can
| be seen rather than having to use the scroll bar.
|
| I hope I have described my problems clearly enough. If not, please
let
| me
| know and I will try and elaborate.
|
| Once again, thank you all in anticipation of being able to resolve my
| problems.
|
| Regards
|
| Gary O
|
|
|
|
|
| Doug,
|
| I am using that utility and am getting the above problems whilst using
it.
|
| Does anyone have any further suggestions?
|
| Regards
|
| Gary O
|
|
|