???? ???????: 208356 - ????? ??? ??????: 19/?????/1427 - ??????: 1.2

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

??? ??????? ???? ??? ?????? ??? ???? ?????? ???? ?? ??????? ???? ??? ????
????? ????View Machine Translation Disclaimer
??? ???????? ???? ????? ????? ??? ???????.
??????: ????? ????? ???????? ????? ? ???????? ??????? ??????? ????????.

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

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

??????

???? ??? ??????? ??? ????? ??? ?? ???? ??? ????? ??????? ????? ?? ????? ??? ????? ???????? ???? ???? ??? ????? sliding.
???? ??? ??????

??????? ????

???? ?????? ?????? ?????? ????? ????? ??? ??????? "???????? ??? ?????" ?? ????? ????? ???????? Northwind.mdb. ??????? ?????? ??????? ??? ????? ?????? ??????? ?? ?? ?????? ??? ?????? ????????. ??????? ????? ???? SalesPct ?????? ??? ??? ?? ???? ???? ???? ?? ???? ?? ???????. ?? ??? ??????? ???? ?? ???? ??? ????? ????? ?? ?? ?????? ?????? 10 % ?? ?????? ???????? ?? ????? ??? ????? ????? ???? ?????? 40 % ?? ?????? ????????.
  1. ???? ????? ????? ???????? Northwind.mdb.
  2. ????? ????? ???? ????? ??? ??????? "???????? ??? ?????".
  3. ?? ??????? ???? ???? ??? ??? ??????.
  4. ?? ??? ?? ???/????? ???? ??? CategoryName ?????? ??????? ???????: 
       Sort Order:    Ascending
   Group Header:  Yes
   Keep Together: Whole Group
  5. ?? ???? ???/????? ??????? ???? ??? ProductSales ?? ????? ??????? ???????: 
       Sort Order: Ascending.
  6. ???? ???? ?????? S orting ??????.
  7. ??? ?? ??? ??? ????? ?????? ? ?? ??????? ???? ???? ??? ????? ??????.
  8. ???? ????? CategoryName ?? ????? ?????? ??? ?????? CategoryName ??? ???????.
  9. ???? ????? ProductName ?????? ProductSales ?? ????? ?????? ??? ???? ???????? ?? ???????. ?????? ????? ???? ????? ??? ??? ??? ??? ??????? ????.
  10. ????? ???? ???? ???? ?? ??? ???? ????? CategoryName ?????? ??????? ???????: 
       Name: Total
   ControlSource: =Sum([ProductSales])
  11. ????? ???? ???? ???? ?? ??? ???? ???????? ???? ??? ???? ProductName ?????? ProductSales. ????? ??????? ???????: 
       Name:          Pcnt
   ControlSource: =[ProductSales]/[Total]
   Format:        Percent
   DecimalPlaces: Auto
  12. ????? ???? ???? ??? ??? ???? ????????. ??? ?????? ??? ???? ?????? Pcnt ??? ????? ???? ????? ???? ??????. ????? ??????? ???????: 
       Name:        RedLine
   Visible:     No
   BorderColor: 255
   BorderWidth: 2 pt
  13. ?? ??????? ???? ???? ??? ?????. ?? ?????? ????? ?????? ??? ???? Declarations ?????? ??????? ????????? ???????? ???????: 
    Dim SalesPct as Single
  14. ????? ?????? ??????? ????????? ????????.
  15. ????? ??????? ???_??????? ????? ??? CategoryName ??? ????? ????? ??????: 
    Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)
   SalesPct = 0.1
End Sub
  16. ????? ??????? ???_??????? ???? ???????? ??? ????? ????? ??????: 
    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
   If Me![Pcnt] >= SalesPct Then
      Me![RedLine].Visible = True
      Select Case SalesPct
         Case 0.1
            SalesPct = 0.4
         Case 0.4
            SalesPct = 999
      End Select
   Else
      Me![RedLine].Visible = False
   End If
End Sub
  17. ??? ??????? ???? rptProductSales ????? ?? "?????? ??? ???????". ???? ??? ?? ?? ?????? ??? ???? ?? ???? ?? ??????? ??? ??? ???????? ????? ??? ???? ????? Pcnt ???? ?? ?? ????? 10 % ????? ?? ??? ???? ??? Pcnt ????? ???? ?? ?? ????? 40 %.
???? ??? ??????

?????

????? ?? ????????? ??? ????? ???????? ???? ??? ??????? Microsoft Access ?? ??????? ??????? ? ???? "???" ?? "????? Office" ?? ????? ??????? ?? ???? ??? ??? ???? ???????? ???? ?? ???????.
???? ??? ??????
????? ???
  • Microsoft Access 2000 Standard Edition
???? ??? ??????
????? ??????: 
kbmt kbinfo kbprogramming KB208356 KbMtar
???? ??? ??????
????? ????????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????208356  (http://support.microsoft.com/kb/208356/en-us/ )
???? ??? ??????
 

Get Help Now

Contact a support professional by E-mail, Online, or Phone

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