Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2008
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to sort 'Records' without a table (2003)

    I have a template in which the user enters real estate deeds.

    The deeds are bookmarked in the order they are inserted from autotext.

    I'm looking for the best way to sort the deeds by "filed date" (a field in each deed record), in case they are entered out of order, so the user doesn't have to delete the deeds and re-enter them.

    Should I try to add the deeds to an expandable table, instead of bookmarking them, then modify the built in sort function?

    Is there maybe a good way to copy each deed to the clipboard, then delete all the deeds and insert them in order?

    Thanks.

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 16 Times in 16 Posts

    Re: How to sort 'Records' without a table (2003)

    Assuming that this is the same template that we've discussed before, I don't see a good way to do this, the structure of the document is not very suitable for it.

    It might be better to let the user enter the information about deeds etc. in an Access database or Excel worksheet, and to use code to generate the document from this information. When this "meta-information" changes, simply ditch the existing document and generate a new document from scratch. This would be a *lot* of work, but in the end you'd have a much more flexible setup.

Posting Permissions

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