???? ID: 289670 - ????? ???????: 17 ??????? 2011 - ??????: 3.0

???? ??????? ??? Access 2003 ?? Access 2002 ??? ?? ?? ?????? ????? ?? ?????????? ???? ?? ??? ???? ????

???? ?????? ???????????? ?????? ???????? KB ?? ???????? ????? ?? ??? ???? ????? ????
?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
?????? ??????This article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
Moderate: ??? ??????, ??????, ?? ?????????????? ??????? ?????? ???

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

???? Microsoft Access 2000 ??????? ?? ??? ?? ???? ??, ?????209595  (http://support.microsoft.com/kb/209595/EN-US/ ) .
???? Microsoft Access 97 ?? ??????? ?? ??? ?? ????, ?????97624  (http://support.microsoft.com/kb/97624/ ) .

?? ????? ??

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

??????

?? ???? ????? ???? ?? ?? ?? ?? ???? ?????? ????? ??? ???? ???? ?? ???, ??? ????? ????? ?????? ????? ??? ???? ???? ?? ?????? ????? ?? ?????????? ???? ?? ??? ???? ?????

???:?? ???? ????? ???? ?? ?? ?? ????? ?? ????? ?????, FrmSmp00.mdb ??? demonstrated.?? ????? ????? ??????? ???? ?? ??? ???? ???? ?? ???? ??? ???????? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
233324  (http://support.microsoft.com/kb/233324/ ) ACC2000: Microsoft Access 2000 ????? ??????? ??????? ?????? ??????? ?????? ???
????? ?? ???? ????

???? ???????

????? ?? ????? ???? ?? ????? ?????? Northwind.mdb ???????? ???? ?????? ????? ?????? ?????? ????????? ?? ???? ???? ???? ??, ?? ????? ?????? ????? ???? ?????? ????? ??? ????? ?????? ?? ??? ?????? ???????? ?? ???? ???? ???? ??:

Microsoft ???????????? ?????? ???? ???????? ?? ??? ??? ???? ??, ???? ??? ??? ?? ?????? ?? ?????????? ??? ??? ?????? ???? ?? ????.. ?????? ???????? ?????? ?? ???? ????? ???????? ?? ??? ???????? ????? ??? ?? ???? ?? ????? ???? ???.. ?? ??? ????? ?? ?? ?? ????? ?? ?? ??? ???????????? ???? ?? ?? ??????? ?? ?????? ??? ????? ????? ???????????? ?? ????? ?? ???? ???? ?? ??? ???? ?? ??? ??.. Microsoft ?????? ???????? ?? ????? ????????? ?? ???????????? ?? ?????? ??? ?????? ?? ???? ???, ??, ?? ?? ???????? ?? ???? ??????? ?????????? ?? ?????? ???? ?? ??? ???????? ??????????????? ?? ?????? ?? ???????????? ????? ?? ??? ??????? ???? ??????..
  1. ????? ??????? Northwind.mdb ??????
  2. ???? ?????? ?? ????? ?????? ????? ?? ??? ?????? ?? ?????? ???? ?? ?? ??? ??????? ?????, ?? ?? ??????? ?????? ?? ?????? ?? ??? ??? ???????
       Combo Box 1
   -------------------------------
   Name:          Categories
   RowSourceType: Table/Query
   RowSource:     Categories
   ColumnCount:   2
   ColumnWidths:  0";1"
   BoundColumn:   1
   AfterUpdate:   [Event Procedure]

   Combo Box 2
   --------------------------
   Name:          Products
   RowSourceType: Table/Query
   ColumnWidths:  2"
   Width:         2"
    ???:: ??? ?? ???? Access ????????? ??? ???RowSourceType??????/?????/StoredProc ???? ??????
  3. ?????? ?????? ????? ?? AfterUpdate ????? ????????? ???? ?? ??? ????? ??? ??????:
    Me.Products.RowSource = "SELECT ProductName FROM" & _
   " Products WHERE CategoryID = " & Me.Categories & _
   " ORDER BY ProductName"
Me.Products = Me.Products.ItemData(0)
  4. ??????? ????? ??? ?????? ?? ?????? ??????? ?? ?????? ????? ??? ?? ?? ?? ???? ?????? ?? ??? ???? ???? ?????? ????? ???, ????? ?????? ????? ?? ?????? ????? ?????? ?? ??? ???? ?????? ???????? ?? ???? ?? ??? ???
????? ?? ???? ????

???

?? ?????? ???, ????? ?????? ????? ??? ???? SQL ??? ?? ?????? ?? ??? ??? ?? SQL ??? ?? CategoryID ???? ?????? ????? ??? ????? ?????? ?? ??? ???? ?? ??? ??? ???????? ?? ????? ???

?? ???? ?????? ????? ???, ?? ?????? ????? ??AfterUpdate??? ????? ????? ?????????, ?? ????? ?????? ????? ?? ??? ???? ??RowSource???? ?? ????? ?????? ????? ??? ?????? ???????? ?? ???? ?? ???? ???? ??? ?? ????????? ?? ???? ????? ?????? ????? ?? ??????? ???? ???? ????????? ?????
????? ?? ???? ????
???? ???? ???? ??:
  • Microsoft Office Access 2003
  • Microsoft Access 2002 Standard Edition
????? ?? ???? ????
??????: 
kbprogramming kbvba kbhowto kbmt KB289670 KbMthi
????? ?? ???? ????
???? ?????? ???????????? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:289670  (http://support.microsoft.com/kb/289670/en-us/ )
????? ?? ???? ????