Help and Support

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

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

moderate: ????? ??????? ???????? ????? ? ???????? ??????? ??????? ????????.

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

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

??????

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

??????? ????

???? ?????? ?????? ????? ????? ??? ??????? " ???????? ??? ????? " ?? ????? ????? ???????? Northwind.mdb. ??????? ?????? ??????? ??? ????? ?????? ??????? ?? ?? ?????? ??? ?????? ????????. ???? ?????? ????? ???? SalesPct ????? ??? ???? ???? ???? ??? ???? ?? ???????. ?? ??? ??????? ???? ?? ?? ???? ??? ????? ????? ?? ?? ?????? ?????? ???? 10 % ?? ?????? ???????? ??? ????? ??? ????? ????? ???? ?????? 40 % ?? ?????? ???????? ".
  1. ???? ????? ????? ???????? Northwind.mdb.
  2. ????? ????? ???? ????? ??? ??????? " ???????? ??? ????? ".
  3. ?? ??????? ??? ???? ??? " ??? ?????? ".
  4. ?? ???? " ???/????? " ????? ???? ??? ??? ????? ?? ?????? ??????? ???????:
       Sort Order:    Ascending
       Group Header:  Yes
       Keep Together: Whole Group
  5. ?? ???? " ???/????? " ?????? ???? ??? ProductSales ??? ?????? ??????? ???????:
       Sort Order: Ascending.
  6. ???? ???? ?????? S orting ?????? .
  7. ??? ?? ??? ??? ????? ?????? ? ?? ??????? ???? ???? ??? ????? ?????? .
  8. ???? ????? ??? ????? ?? ????? ?????? ??? ?????? 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/ )

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

 

Related Support Centers