Results 1 to 3 of 3
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Word fields or bookmarks (97+)

    If using a protected document with form fields is too restrictive, bookmarks are risky: if people revise their answers, they can accidentally delete bookmarks.

    If you have a structured document with all replies in table cells, you can use VBA to loop through the cells of the table(s) and extract the information you need. It shouldn't be too hard to use DAO or ADO to store this information in one or more Access tables.

  2. #2
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Word fields or bookmarks (97+)

    Hey,
    <img src=/S/cauldron.gif border=0 alt=cauldron width=20 height=20> I'm creating (enhancing actually) a template/standard document which people should use for a file evaluation procedure. As such, I could be able to process their input (> 4000 documents) afterwards through automation (e.g. checking or loading certain information into an Access database). The document is already structured with tables so that (almost) any information element is located in one table cell.
    What should I prefer to identify & 'capture' the required pieces of information: bookmarks or fields? What are the (dis)advantages of both options?

    As I would like to have it as light & simple as possible (no protection etc) and invisible for the users, I'm inclined to use bookmarks... (but I don't know of my arguments make sense).
    Further, what's the risk that a user entering his/her information should erase the bookmark/field by accident, or that information might end up 'outside' the field/bookmark? I mean: what precautions & control are needed to ensure that the content of the field/bookmark is what I expect is present & 'complete'.

    <img src=/S/bow.gif border=0 alt=bow width=15 height=15> Thanks for any suggestions & remarks!
    Hasse

    ps FYI: I already used bookmarks for merging a template with an Access query (creating individual documents instead of the 'concatenated' Word Mail Merge result), 'filling' the bookmarks with the content of a corresponding query field (by the way, I've once been talking about this in a thread with, I think, Wendell, but forgot & didn't bookmark <img src=/S/clever.gif border=0 alt=clever width=15 height=15> the number).
    But what I want to achieve now is the other way around...

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Leuven, Vlaanderen, Belgium
    Posts
    322
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Re: Word fields or bookmarks (97+)

    Hey, Hans,
    factually looping through the tables by code was also my first idea for loading the documents into a database. I just hoped to gain a bit more control using bookmarks/fields.
    But... so, unfortunately, my idea was right... and I assume there's no way to avoid your users from deleting bookmarks, is there? (Maybe I'll try it out myself in some various ways and see what turns out...)
    Eventually I realise no matter what strategy you use (looping through table cells/bookmarks/...), without protection the users will always succeed, activelly/passively creative as they can be <img src=/S/devil.gif border=0 alt=devil width=15 height=15>, to break your standard. And no matter what strategy you use, without protection <img src=/S/fanfare.gif border=0 alt=fanfare width=31 height=23> you'll have anyhow some spare time to spend for fixing them.
    Thanks for your thoughts,
    Hasse

    p.s. FYI: I've attached the current evaluation form format. As you see, there's still some cell splitting to do in the header to separate all data in there. Then, I should be able to process the most important information (and if I find an easy solution for the fact that authors can add more than one argument to one criterium, I could process even all of it...).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •