????? ??????? ?????? StrConv ??????? ?????? ??????????? ??????? ????????? ?? Access 2002

?????? ????????? ?????? ?????????
???? ???????: 298607 - ??? ???????? ???? ????? ????? ??? ???????.
??????: ????? ????? ???????? ????? ? ???????? ??????? ??????? ????????.

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

?????? ??? ????? Microsoft Access 97 ?? ??? ???????? ???? 302499.
?????? ??? ????? Microsoft Access 2000 ?? ??? ???????? ???? 253911.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ????? ???????? ???? ????? ???? 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 "??" ????? ??????? ?? ???? ??? ??? ???? ???????.

???????

???? ???????: 298607 - ????? ??? ??????: 02/???/1425 - ??????: 3.1
????? ???
  • Microsoft Access 2002 Standard Edition
????? ??????: 
kbmt kbfunctions kbdta kbhowto KB298607 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????298607

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

 

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