A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

!Undefined Bookmark in Word Form



 
 
Thread Tools Display Modes
  #1  
Old January 19th, 2007, 02:29 AM posted to microsoft.public.word.docmanagement
Northwoods
external usenet poster
 
Posts: 33
Default !Undefined Bookmark in Word Form

I am unable to figure out why I get this message on my template and my
document from template in all my formula fields before I tab through.

The formula is RoomRate*NightsStay. Once I tab to the formula the message
disappears.
The Bookmark for this formula is TotalCost and it is also used in another
formula field calculating the Tax + TotalCost. The formula works so I guess
the bookmark is OK.
RoomRate is also used in another formula field to calculate the cancellation
fee.
All 3 fields display the above message until I tab through then the results
replace the message. When I check bookmarks, all three are named bookmarks in
the "Go To" list. So I assume they are bookmarked, although the bookmark is
not part of the formula field. Should it be?
This is my first form so any help would be greatly appreciated. Already got
help on another issue. So thanks.
  #2  
Old January 20th, 2007, 02:15 AM posted to microsoft.public.word.docmanagement
zkid
external usenet poster
 
Posts: 25
Default !Undefined Bookmark in Word Form

Let's see if I'm understanding this correctly. If the formula is
RoomRate*NightsStay and it works in the end, then those two "variables" have
to be bookmarked. Have you tried setting the default value for those two
form fields to 0.00 and 0, respectively? If there is no value to begin with,
I can see how there would be an error until you fill in the amounts.

"Northwoods" wrote:

I am unable to figure out why I get this message on my template and my
document from template in all my formula fields before I tab through.

The formula is RoomRate*NightsStay. Once I tab to the formula the message
disappears.
The Bookmark for this formula is TotalCost and it is also used in another
formula field calculating the Tax + TotalCost. The formula works so I guess
the bookmark is OK.
RoomRate is also used in another formula field to calculate the cancellation
fee.
All 3 fields display the above message until I tab through then the results
replace the message. When I check bookmarks, all three are named bookmarks in
the "Go To" list. So I assume they are bookmarked, although the bookmark is
not part of the formula field. Should it be?
This is my first form so any help would be greatly appreciated. Already got
help on another issue. So thanks.

  #3  
Old January 20th, 2007, 07:28 PM posted to microsoft.public.word.docmanagement
Northwoods
external usenet poster
 
Posts: 33
Default !Undefined Bookmark in Word Form

Thank you very much! That was exactly the problem. I had a series of
underscore lines as default and once I removed them so that the first value
showed up, boom all the messages disappeared.
Much appreciated

"zkid" wrote:

Let's see if I'm understanding this correctly. If the formula is
RoomRate*NightsStay and it works in the end, then those two "variables" have
to be bookmarked. Have you tried setting the default value for those two
form fields to 0.00 and 0, respectively? If there is no value to begin with,
I can see how there would be an error until you fill in the amounts.

"Northwoods" wrote:

I am unable to figure out why I get this message on my template and my
document from template in all my formula fields before I tab through.

The formula is RoomRate*NightsStay. Once I tab to the formula the message
disappears.
The Bookmark for this formula is TotalCost and it is also used in another
formula field calculating the Tax + TotalCost. The formula works so I guess
the bookmark is OK.
RoomRate is also used in another formula field to calculate the cancellation
fee.
All 3 fields display the above message until I tab through then the results
replace the message. When I check bookmarks, all three are named bookmarks in
the "Go To" list. So I assume they are bookmarked, although the bookmark is
not part of the formula field. Should it be?
This is my first form so any help would be greatly appreciated. Already got
help on another issue. So thanks.

  #4  
Old January 20th, 2007, 08:33 PM posted to microsoft.public.word.docmanagement
zkid
external usenet poster
 
Posts: 25
Default !Undefined Bookmark in Word Form

Glad it worked out! Thanks for letting us know.

"Northwoods" wrote:

Thank you very much! That was exactly the problem. I had a series of
underscore lines as default and once I removed them so that the first value
showed up, boom all the messages disappeared.
Much appreciated

"zkid" wrote:

Let's see if I'm understanding this correctly. If the formula is
RoomRate*NightsStay and it works in the end, then those two "variables" have
to be bookmarked. Have you tried setting the default value for those two
form fields to 0.00 and 0, respectively? If there is no value to begin with,
I can see how there would be an error until you fill in the amounts.

"Northwoods" wrote:

I am unable to figure out why I get this message on my template and my
document from template in all my formula fields before I tab through.

The formula is RoomRate*NightsStay. Once I tab to the formula the message
disappears.
The Bookmark for this formula is TotalCost and it is also used in another
formula field calculating the Tax + TotalCost. The formula works so I guess
the bookmark is OK.
RoomRate is also used in another formula field to calculate the cancellation
fee.
All 3 fields display the above message until I tab through then the results
replace the message. When I check bookmarks, all three are named bookmarks in
the "Go To" list. So I assume they are bookmarked, although the bookmark is
not part of the formula field. Should it be?
This is my first form so any help would be greatly appreciated. Already got
help on another issue. So thanks.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:58 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.