ACC2002: ???? ????? ???? ?? ????? ???? ??? ?????? ??? ????? ?? ????? Access

?????? ????????? ?????? ?????????
???? ???????: 295252 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
??????: ????? ????? ???????? ????? ? ???????? ??????? ??????? ????????.

??? ????? ??? ?????? ??? ??? ????? Microsoft Access (.adp).

????? ???? | ?? ????

?? ??? ??????

???????

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

?????

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

????

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

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

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

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

?? ???? ?? ??? ????? ??????? ????? ????_???? ?? ???? ??????? ??????. ???? ???? ???????? ??? ????? ??????? ??? ???? ????? ????? ????? ??????? "????_????" ?? ???? ??????? ?????? ????? ????? BeforeInsert ?????? ?? ??? ??? ???? ????? AfterUpdate ?????? ?????. ??? ???? ??????? ????? ?????? ???? ?????? ??????? ???????:
  1. ?????? ???? ??????? ???????? ?? ????? "????? ??? ????? ????? ????" ?????? ?? ??? ???????.
  2. ?? ???? ??????? ??????? ?? ????? ????? "?????".
  3. ?? ??????? ???? ???? ??? ????? ???? ?????? ??????? ???????.
  4. ?? ?????? ????????? ???????? ??????? ??? ?????? ???????:
    Option Compare Database
    Option Explicit
    
    Dim strRowSource As String
    
    Private Sub Form_AfterUpdate()
        Dim ctl As Access.Control
    
        'Reference the combo box control on the subform. Be sure
        'to change this code to refer to the proper control on your
        'subform.
        Set ctl = Me.Controls("Products1").Form.Controls("CategoryID")
    
        'Assign the RowSource property back to the string we stored
        'during the BeforeInsert event.
        ctl.RowSource = strRowSource
    End Sub
    
    Private Sub Form_BeforeInsert(Cancel As Integer)
        Dim ctl As Access.Control
    
        'Reference the combo box control on the subform. Be sure
        'to change this code to refer to the proper control on your
        'subform.
        Set ctl = Me.Controls("Products1").Form.Controls("CategoryID")
    
        'Store the current RowSource property and then clear it.
        strRowSource = ctl.RowSource
        ctl.RowSource = ""
    End Sub
    
    Private Sub Form_Undo(Cancel As Integer)
        Dim ctl As Access.Control
    
        'Reference the combo box control on the subform. Be sure
        'to change this code to refer to the proper control on your
        'subform.
        Set ctl = Me.Controls("Products1").Form.Controls("CategoryID")
    
        'Assign the RowSource property back to the string we stored
        'during the BeforeInsert event.
        ctl.RowSource = strRowSource
    End Sub
    					
  5. ?? ??????? ???? ???? ??? ????? ????? ??? Microsoft Access.
  6. ?? ??????? ???? ???? ??? ??? ???????. ???? ?? ???? ??????? ?????? ??????? ?????? ???? ?????? ?? ????? ????? ?????? ?? ??????? ???????.
  7. ?? ??????? ?????? ???? ??? ????? ????????. ??? ???? ?? ?? ??????? ??????? ? ?????? ???? ??? ??? ??? ?????.
  8. ??? ????? ??? ??? ???? ?? ??????? ??????? ???? ?? ??? ???? ?????.
???? ?? ????? ????? "????_?????" ?? ??????? ??????? ??? ?????? 1? ??? ??? ?? ?????? ??????? ??? ??????. ??? ??? ????? ?? ??????? ??????? ? ?????? ?? ?? ???? ????? ???? ???? ?????? ??????? ?? ?????? ??? ???? ??? ???? ?? ???? ??????? ?????? ?? ??????? ?????? ???????? ???? ????.

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ????? ??? ???????.

??????? ????

??? ????? ??? ?? ???? ???? ????? ??? ??? ??????? ??? Microsoft Access ???????? ???? ??? ??????? ?? ???? ????? ???? ?? ???? ????? ???? ?????? ?? ??????? ???? ?? ????????? ???????.

??? ???? ??????? ????? ??? ?? ??????? ??????? ??????? ???? ?????? ?????? ?? ??? ??????? ?? 10. ??? ????? ??? ???? ?? ??????? ??????? Microsoft Access ???????? ???? ??? ??????? ?? ???? ???? ??????? 11 ??? ????? ?? ?? ??? ?????? ?? ?????? ???? ?? ????????. ??? ??? ????? ?? ??????? ??????? ??? ????? ??? ?????? ????? ?? ?????? ???? ??????? ???? ?? ??????? ?? ??? ??????. ??? ???? ??? ??? ????? ???? ???? ??? ?? ???? ???? ?????? ??? ????? ???? ??? ?????? ??? ?????.

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

  1. ?????: ??? ???? ??????? ???????? ?? ??? ??????, ????? ????? ????? Access ????? NorthwindCS.adp. ?? ???? ?? ???? ???????? ?? ??? NorthwindCS.adp ?? ???? ??????? ??????? ??? ???? ?? ???????.

  2. ???? ??????? ????? NorthwindCS.adp.
  3. ????? ????? "???? ??????? ????????" ?? ???? ?????.
  4. ?? ??????? ???? ??? ??? ?????? ????? ???????? ?? ???? ??? ?????.
  5. ???? ??? ????.
  6. ?? ???? ?????? ????? ???? ? ???? ??? ????? ??????? ?? ???? ??? ?????.
  7. ?? ???? ????? ?????? ?????/????????? ? ???? ??? ?????? "??????".
  8. ????? ProductIDProductName ??????? ????_????? ??? ????? ?????? ??????? ?? ???? ??? ??????.
  9. ???? ??? "???? ????????" ?????? ??? ????? ??????? ?? ???? ??? ?????. ???? ??? ??? ????? ????? ???? ???? Products1 ?????? ?? ????? ??? ???? ????????.
  10. ?? ??????? ???? ???? ??? ??? ??????? ???? ????? ????? ????.
  11. ???? ??? ???? ???? ????_????? ?? ??????? ????? ? ??? ??? ????? ??? ?? ???? ??? ???? ????? ????.
  12. ????? ????? ???? ??????? ?????? ??? ???:
       Combo box
       -------------------------
       Name: CategoryID
       ControlSource: CategoryID
       RowSource: Categories
       ColumnCount: 2
       ColumnWidths: 0"; 1"
       BoundColumn: 1
       List Width: 1"
    					
  13. ?? ??????? ???? ???? ??? "????? ??? ???? ????????".
  14. ???? ??? ?????? ????_????? ?? ?? ??????? ????? ? ???? ??? ??? ??????.
  15. ???? ??? ???????? ??????. ??? ???????? ?????? ??? ?????? ????_????? ???? ???? ???? ????????.
  16. ?? ??????? ???? ???? ??? ??? ?? ?? ?????? ???????.
  17. ???? ????? ?????? ?? ????? ????? "?????".
  18. ?? ??????? ???? ???? ??? ????? ?????? ???? ????? ?????? ?? ???????.
  19. ???? ????? "????_?????" ?? ????? ?????? ??? ???? ???????? ?? ???????.
  20. ???? ??? ????? ???? ????? ???????? ?? ?? ?????.
  21. ?? ?????? "????? ??????" ? ???? ??????? Products1 ?? ???? ???????? ??????? ?????? ????? ???? ????.
  22. ????? ????? ??????? ?????? ??? ???:
       Subform
       ----------------------------
       Name: Products1
       LinkChildFields: CategoryID
       LinkMasterFields: CategoryID
       Top: 1.5"
       Width: 5.5"
    					
  23. ?? ??????? ???? ???? ??? ??? ???????. ???? ?? ???? ??????? ?????? ??????? ?????? ???? ?????? ?? ????? ????? ?????? ?? ??????? ???????.
  24. ?? ??????? ?????? ???? ??? ????? ????????. ??? ???? ?? ?? ??????? ??????? ? ?????? ???? ??? ??? ??? ?????.
  25. ???? ????? ??? ??? ???? ?? ??????? ???????.
???? ?? ??? ???? ?? ???? ??????? ?????? ?? ??????? ?????? ???? ???? ????????? ????? ?? ????? ?????? ?? ???? ??????.

?????

?????? ??? ??????? ??????? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
295225ACC2002: ????? ??? ????? ??? ????? ????? ??????? ?? ??? Multi-Table

???????

???? ???????: 295252 - ????? ??? ??????: 12/???? ??????/1435 - ??????: 3.0
????? ???
  • Microsoft Access 2002 Standard Edition
????? ??????: 
kbnosurvey kbarchive kbmt kbbug kbclientserver kbnofix KB295252 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????295252

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

 

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