ACC2000: ????? ??????? ???? StrConv ??????? ?????? ??????????? ??????? ?????????

?????? ????????? ?????? ?????????
???? ???????: 253911 - ??? ???????? ???? ????? ????? ??? ???????.
??????: ????? ????? ???????? ????? ? ???????? ??????? ??????? ????????.

??? ????? ??? ?????? ??? ??? ????? ?????? Microsoft Access (.mdb).

?????? ??? ????? Microsoft Access 2002 ?? ??? ???????? ???? 298607.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ????? ???????? ???? ????? ???? StrConv ????? ??????? ???? ????????? ????? ????? ?? ?????? ?? ?????? ?? ???????. ?? ????? ??? ?????? ???????? ??????? ???? ??? ?????? ??????? ??? ???????:
  • ????? "MacDonald" ??? "Macdonald."
  • ????? "van Buren" ??? "Buren Van."
  • ????? "VI Pratt James" ??? "vi James Pratt."

??????? ????

???? ??????? ?????? StrConv ????? ???? ?????? ?? ????? ???? ??? ?????? ??????? ??????? ??????? ?? ???? ????? ???? ???? ????? ?????. ???? ?????? ?? StrConv (????? ? ??????? ? ??? "?????" ?? ??????? ?????? ? "???????" ?? 1 ?? 2 ?? 3. "?????" ???? ????? ???? ????? 1? ??????? ?? 2 ? 3 ???? ????? ????? ?? ?? ???? ????? ??????.

??? ????? ?????? StrConv ?? Visual Basic for Applications ? ????? ?? ??????? ??????? 1 ?? 2 ?? 3 ? ????? ????? ??????? ??? ??????? ???????:
vbUpperCase ????? ??????? ??????? ??? ???? ?????.
vbLowerCase ????? ??????? ??????? ??? ???? ?????.
vbProperCase ????? ????? ????? ?? ?? ???? ?????? ??????? ??????? ???????? ??? ?????.
??????: ???? StrConv ????? ???? ?? ????? ???????? ??? ? ??? ???? ???? ??? ??????? ??? ??? ????? ????? ????????? ?? ????? ???? ??????.

demonstrating ???? StrConv

  1. ???? ????? Microsoft Access ?? ?? ???? ????? ?????? ????? ?????.
  2. ????? ???? ???? ?? ?????? ???????:
       Field Name: FirstName
       Data Type: Text
    
       Field Name: LastName
       Data Type: Text
    						
    ??? ?????? ???? MyNamesList.
  3. ????? ????? ????? ??????? ??? ??????:
       john chen
       joanna fuller
       becki culbert
       jeff smith
    					

??????? StrConv ?? ????????? ???????? ?? ????? "???_???????" ???? ????? ??????

  1. ????? ????? ???? ????? ??? ???? MyNamesList.
  2. ????? ????? ???? ???? ???? ????? ????? ????? LastName ???? ????? ?????? ?? ???? ????? ??????.
  3. ?? ???? ??? ???? ???? ???????? ???? ??? ????? ?? ??????? ???.
  4. ????? ????? "???_???????" ???? ???? ??? ??????? ??? ????? ????? ??????:
    Private Sub LastName_AfterUpdate()
    LastName = StrConv(LastName, vbProperCase)
    End Sub
    						
  5. ?? ??????? ???? ???? ??? ????? ????? ??? Microsoft Access.
  6. ???? ??????? ???? ??? ??????? ?? ?????? 1 ?? ????? ????? "?????" ????? ??? ????? ????? ???????. ???? ??? ??? ?????? ??? ??? ??????? ??????? ???? ???? ???? ???? ??????.

???????? StrConv ?? ???????

  1. ?? ?????? ??????? ???? ????? ??? ???? MyNamesList ?? ???? ????? ?????? ?? ???? ????? ????? ?? ???? ????? ?????????:
    FullName: = StrConv([LastName] & "," & [FirstName], 3)
  2. ????? ?????????.

    ?????? ??????? ?????? ?????? ??????? ?? ??? ????? ?? ??????? ???? ???? ?? ????? ???? ???? ????? ????? ??????.

??????? StrConv ?? ?????

  • ????? ????? ???? ???? Proper ?????????? ???????:
    ???????: SetValue
    ??????: Screen.ActiveControl
    ?????: StrConv(Screen.ActiveControl,3)
    ??????: ???? ??????? ??? ??????? ?? ????? "???_???????" ?? ???? ???? ?? ?????. ??? ????? ??? ??????? ?????.

?????

?????? ??? ???? ?? ????????? ??? ????? ?????? ?????? StrConv ?? ???? Visual Basic? ???? ??? "??????? Microsoft Visual Basic" ?? ??????? ??????? ? ???? strconv ?? ????? Office "??" ????? ??????? ?? ???? ??? ??? ???? ???????.

???????

???? ???????: 253911 - ????? ??? ??????: 10/????? ??????/1425 - ??????: 2.0
????? ???
  • Microsoft Access 2000 Standard Edition
????? ??????: 
kbmt kbhowto kbprogramming KB253911 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????253911

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com