Solved: Bookmark issue

[espencer]

Hello all,
I was wondering if anyone has come across this problem. I've enclosed the word document. The document has bookmarks and some users the bookmark populate once and some users they populate twice. I was wondering if its something in the user word setup or option. I've tried to change some of them and getting fustrated. If anyone has come across this I would appreciate the help.
Thanks in advance

[Anne Troy]

Okay. This will be my THIRD shot at posting a reply here...I keep getting a bad page.

1. What is populating the bookmarks? Could it be this is being done twice?
2. Otherwise, can we see a version before it's populated?

[Anne Troy]

And you have an unnecessary section break in that document.

[espencer]

Thanks for looking.
1.) The bookmarks are being populated from an oracle database. I can't see it being done twice. It's only one bookmark. I will check on this but when I run it only one value per bookmark.
2.) File enclosed before populates

[fumei]

I have looked at both files. Could you please restate the problem a bit more clearly.

1. "It's only one bookmark". Huh? there is more than one bookmark in the file. So....WHAT bookmark are you refering to?

2. what is doing what to to which bookmark? And how is it doing it?

What exactly is going on?

[espencer]

The 5 bookmarks values are showing up twice in each bookmarked area;

0.00 0.00
0.00 0.00
11,723,983.70 11,723,983.70
(646,169.02)(646,169.02)
1,206,291.61 1,206,291.61

The last line of this document is suppose to equal the amount for each column. I am wondering why certain user are getting this result will others are gettitting the right values for each bookmark;

0.00
0.00
11,723,983.70
(646,169.02)
1,206,291.61

The above values are the correct amount that should be in the bookmarks.

Thanks

[MOS MASTER]

Hi, :yes

It's more acurate to work with a ranged bookmark instead of a normal (location) bookmark.

And why don't you write to a formfield instead (Cause you already use them) They are a ranged bookmark you can write to.

Could you show us the code used to get the data from the Oracle database? Otherwise we can't help you....if we don't see it.

HTH. :moosegrin

[Anne Troy]

The bookmarks aren't there twice, but there IS a bookmark, which would be populated, AND there's values. You either need to:

a) get rid of the typed in values
b) SELECT the 0.00 and insert the bookmark (don't put the bookmark in front of it). Done correctly, you'll have brackets surrounding the 0.00 instead of an I-beam looking thing to the left of it.

[MOS MASTER]

b) SELECT the 0.00 and insert the bookmark (don't put the bookmark in front of it). Done correctly, you'll have brackets surrounding the 0.00 instead of an I-beam looking thing to the left of it.

True Anne, :yes That's why I'd say use a ranged bookmark or write to a formfield instead...

Good vibes over here! :cloud9:

[espencer]

That might be a solution for later but now this process has been good for the last couple of years and since we've switched to word 2003 only a couple of user are having this issue. I will check with the user about this. We've protected this area of the document so the user will not be able to type in it. I took the protection off to see if another solution could be found. Thanks for all the help so far. I've collected a lot of information and will try to enhance this document with suggestion given.

[MOS MASTER]

Hi, :yes

Indeed perhaps it's a good idea to watch over the users shoulder to see what's happening.

Perhaps that will shed some light on things.

Later..:whistle:

[fumei]

I don't know what is different about 2003 that would be doing this, but:

1. if the values are going in twice....then it is being written twice....duh, I guess that is obvious

2. you refer to "bookmarked area". From what I can see, this is technically incorrect. The bookmarks in the document have no range. They are locations, which is why if they get written to twice, the values are there twice. This is why Joost suggested formfields. They are ranged bookmarks, and can be written to directly.

[MOS MASTER]

I don't know what is different about 2003 that would be doing this, but:

Hi buddy, :yes

Well IMO there is no difference writing to bookmarks in 2003 so there must be a very simple explanation to this question.

And if you ask me the factor is probably the human operator here so my advice is to have a look over the shoulder of that person. :whistle:

[espencer]

After sitting with the customer, this problem never can up one time. I would like t take this time to thank everyone whom gave suggestions and make sure that this was human error and nothing else. Some customer still want you to hold their hand while working. Thanks again.

[MOS MASTER]

Glad to here you have it solved now! :yes

You're welcome. :beerchug: