Results 1 to 2 of 2
  1. #1

    Help with self adjustment please

    Hey guys,
    Part of whjat I use QARun for is running internet insurance quotes using an access database. I need the quotes to run as new each time so the same name is never enterted twice. I would like QARun to self adjust the surname by one letter and write back to access. Can anyone offer some help on how to do this please.
    Thanks in advance guys

  2. #2
    Senior Member
    Join Date
    Nov 2002
    Columbus, OH, USA

    Re: Help with self adjustment please

    Use a combination of the ASC() and CHR() functions.

    Assuming you are wanting to change an existing character, say the last one, then use a Length() and FindStr() combination to get the character, convert it to ANSI using the ASC function, increase or decrease by 1 (within the number range for the characters you want to use) then use the CHR function to turn it back to a character and use a function like OverlayStr() to replace the character.
    Always remember that you are unique. Just like everybody else.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
BetaSoft Inc.
All times are GMT -8. The time now is 07:53 PM.

Copyright BetaSoft Inc.