ACC2000: ????? ????? ?????? ??????? ?????? ??????

?????? ????????? ?????? ?????????
???? ???????: 209576 - ??? ???????? ???? ????? ????? ??? ???????.
???????: ????? ????? ????? ???????? ??? ????? ????????? ???????? ??????.

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

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

?? ??? ??????

??????

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

??????? ????

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

?? ?????? ?????? ???? ???? ??????? ?????? ????? ????? ?????? ?? ???? ?????? ?????? ???? ??????? ?????? ?????? ????? ???????? ?? ?????? "??????". ??? ????? ??? ??? ?? ???? ??????? ?????? ????? ??? ????? ???? ??????? ?????? ?????? ???? ????? ???????? ??? ???? ?????.
  1. ???? ????? ????? ???????? Northwind.mdb.
  2. ????? ????????? ?????? ???????? ??? ???? ?????? ?? ?? ???? ????????? ??? qryCategoriesList.

    ?? ??? ??????????? ??? ??????
    ???:????_?????CategoryName
    ??????:????????
    ?????: ??????
    ?????:<checked><checked>
    ????????:  
    Or:  
  3. ????? ????????? ?????? ???????? ??? ?????? "??????" ?? ?? ???? ????????? ??? qryProductsList.

    ?? ??? ??????????? ??? ??????
    ???:ProductID??? ??????????_?????
    ??????:????????????????????????
    ?????: ????????????
    ?????:<checked><checked><checked>
    ????????:  IIF(IsNull([Forms]![frmSelector]![cboCategorySelect]) [CategoryID],[Forms]![frmSelector]![cboCategorySelect])
    Or:   

    ??????: ?????? IIF() ???? ?????????? ?????? ?????? ?? ??? ??? ???? ??????? ?????? ????? ?????. ?? ???? ????? ???? ??????? ?????? ????????? ?????? CategoryIDs ???? ?????? "??????" ??????? ?? ???? ?????? ???? ???????? ?? ???? ??????? ?????? ??????. ??? ?? ??? ???? ?????? ????? ????_????? ???? ???? ??? ??????? ???? ???????? ????????? ?????? ?? ???????? ??? ?????.
  4. ????? ????? ???? ?? ????? ????? "?????" ???? ?? ????? ??? ?? ???? ?? ?? ???????.
  5. ?? ??????? ??? ???? ??? ?????.
  6. ?? ???? ????? ???? ??? ????? ??????? ??? ?? ???? ??? ???? ???????? ????? ??????.
  7. ???? ??? ????? ????? ???? ???????? ???? ??? ???? ?? ???? ??? ?????.
  8. ???? ???????? ???????? ???????:
    Me!cboProductSelect.Requery
  9. ????? ?????? ??????? ?????? ????? ??? ??? ?? ?? ???? ??????? ?? frmSelector:
       Combo Box 1:
       -------------------------------
       Name: cboCategorySelect
       RowSourceType: Table/Query
       RowSource: qryCategoriesList
       ColumnCount: 2
       ColumnWidths: 0";1"
       BoundColumn: 1
       
       Combo Box 2:
       -------------------------------
       Name: cboProductSelect
       RowSourceType: Table/Query
       RowSource: qryProductsList
       ColumnCount: 3
       ColumnWidths: 0";1";0"
       BoundColumn: 1
    					
  10. ???? ??? ?????? ?????? ??? ???? ??????? ?????? ????? ?????? cboCategorySelect ??? ?? ???? ??? ?????.
  11. ?? ???? "?????" ? ???? ??? ????? ??????? ??? ?? ???? ??? ?? ?????? ??? ???????.
  12. ???? ??? ???? ????? ????? ???? ???????? ???? ??? ???? ?? ???? ??? ?????.
  13. ???? ???????? ???????? ???????:
    Me!cboProductSelect.Requery
    Me!cboProductSelect.SetFocus
    					
  14. ???? ??????? ?? ????? ????? "?????" ?? ?? ?????? ??? ?? ???? ??????? ?????? ?????. ???? ?? ???? ??????? ?????? ?????? ??? ???????? ???? ????? ??? ?????. ??????: ?? ??? ???? ?????? ??? ?????? ?? ???? ??????? ?????? ????? ???? ??????? ?????? ?????? ?????? ????? ?????? ?? ?????? ???????? ???? ???? ??????.

?????

?????? ??? ???? ?? ????????? ??? ?????? ??????? ?????? ???? ??? ??????? Microsoft Access ??????? ??????? ? ???? ?????? ??????? ??????: ???? ?????? ????? ?? "????? Office" ?? "????? ???????" ? ? ?? ???? ??? ??? ???? ???????? ???? ?? ???????.

?????? ??? ???? ?? ????????? ??? ????? ????? ????????? ?? ????? ?????? ???????? ?? ????? ???? ??? ??????? Microsoft Access ?? ??????? ??????? ? ???? ??????? ??????? ?? ????? Office "??" ????? ??????? ?? ???? ??? ??? ???? ???????? ???? ?? ???????.

?????? ??? ??????? ?????? ??? ????? ????? ??? ??????? ??? ?????? Access 2000 ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
235359ACC2000: ????? ????? ?? ???? ????????? ?? ????? Access
?????? ??? ??????? ?????? ??? ????? ????? ??? ??????? ????????? ??????? ?? Access ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
98660ACC: ????? ????? ?????? ??????? ?????? ??????

???????

???? ???????: 209576 - ????? ??? ??????: 28/????? ??????/1425 - ??????: 1.1
????? ???
  • Microsoft Access 2000 Standard Edition
????? ??????: 
kbmt kbhowto KB209576 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????209576

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

 

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