Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / January 2007

Tip: Looking for answers? Try searching our database.

Fiedl Calculation Error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gary O - 10 Jan 2007 05:09 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.