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 are:
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 - 10 Jan 2007 18:37 GMT
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/AlbertKallal/msaccess/msaccess.html

Signature
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
>I am gettiing a "Field Calculation Error" when using the following field
>code:
[quoted text clipped - 38 lines]
>
> Gary O