Results 1 to 9 of 9
  1. #1
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Proper case (A97 A2000)

    I came across this and thought it may be useful to our members.
    It deals with such names as McDonald, O,Brian and will convert sentences also.
    Abreviations such as IBM can also be handled.
    This version is A2000 and the next post will be A97.

    I appologise to the moderators <img src=/S/angel.gif border=0 alt=angel width=15 height=21> if I have posted in disposure but I thought the utility would be extremely useful to many.


    Thanks to r-cube for supplying this and I'm sure our members will send their thanks also.
    Attached Files Attached Files

  2. #2
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Proper case (A97 A2000)

    A97 version
    Attached Files Attached Files

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Proper case (A97 A2000)

    Hi Dave

    Nice find, thanks for sharing.

    John

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Proper case (A97 A2000)

    <P ID="edit" class=small>(Edited by charlotte on 09-Dec-02 20:12. at second glance)</P>If this something you put together, Dave? It really should have some indication of the author. This is an approach commonly referred to as "Proper Lookup" and has been around for quite awhile, but since this is an especially clear demonstration of it, it's a shame not to give credit where credit is due.

    I just notice the reference to r-cube in your initial post. Is that a username or something else? It would be best to have the credit in the demos themselves where anyone can see who wrote it.
    Charlotte

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Proper case (A97 A2000)

    The Access 97 version has the name of the author and organization in File/Database Properties.

  6. #6
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Proper case (A97 A2000)

    Points noted Charlotte.
    I don't know the Author and only had a quick look at the Demo.

    It was posted by r_cube from the Utter Access forum

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Proper case (A97 A2000)

    The techniques demonstrated in the database are an interesting expansion of the much more limited examples Microsoft gave in the NeatCd97 database (see ACC97: Neatcd97.mdb Available in Download Center. Having special cases in a table is much more flexible than putting them in the code itself.

    It's best to practice moderation in applying these functions. The Typed_Sentence function is rather slow when applied to long stretches of text. And I wouldn't want my macabre macho mackerel macaroni maceration machine to be converted to a series of Scottish clans <img src=/S/grin.gif border=0 alt=grin width=15 height=15>.

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Proper case (A97 A2000)

    Thanks, Hans. I looked *inside* the 2000 version, but I didn't think to look at its database properties so it may be there as well. My habit is to post that information in every module as well as on the initial form to make it easy to find, so using only the properties didn't occur to me.
    Charlotte

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Proper case (A97 A2000)

    Table-based is definitely the approach to use, particularly for multi-word strings(i.e., de la Vega, Smyte-White, Milwaukee-St. Paul, etc.).

    Just a warning for anyone using this approach on Windows NT pre-SP 4 with Access 97. WinNT, up through SP 3, had a funny bug that caused Access 97 to ignore any strings you put in such a table if they also happened to match a recognized file extension. I tripped over that a few years ago.
    Charlotte

Posting Permissions

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