ACC2000: ??????? ???? Eval ?? ?????? ?? ????????? ???????

?????? ????????? ?????? ?????????
???? ???????: 198462 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
??????: ????? ????? ???????? ????? ? ???????? ??????? ??????? ????????.
????? ???? | ?? ????

??????

??? ??? ?????? ?????? Eval() ?? ????? ????? ?? ???????? ??????? ?? ????? ???? ???? ??????? ??????? ?????? ????????? ?? ????????? ????????.

?? ???? ??????? ?????? Eval() ?????? ??????? ?? ???? ???? ?? ????? ????? ????? ??????? ??? ????? ????????? ?? ????????? ???????? "? ??? ???? n ????? ?? ????????:
??? ??? ??????? 3061:
?????? ????? ????. n ???????.
???? Microsoft ??????? ???????? ??? ??? ?? ???? ??????? ?? ?? ?????. ??? ????? ???? ?? ????? ??? ???????? ??????? ?????? ???????? ?? ???????? ???? ????. ????? ??? ??????? ???? ?????? ?? ??? ??????? ???? ??? ????? ?? ??????? ???? ??? ????????? ?????? ?????? ?????????. ???? ??????? ????? ??? Microsoft ??? ????? ????? ???? ???? ?? ?????? ?????? ??? ??????? ?????? ????? ?????? ?? ????? ??????? ?????? ??????? ?????.

??????? ????

???? ?????? ?????? ????? ??????? ?????? Eval() ?? ????? ????? ?? ???????:
  1. ???? ????? ????? ???????? Northwind.mdb.
  2. ????? ??????? ???? ?????? ???????? ??? ?????? "??????" Orders:
       Query: QryEval
       ----------------------------------------
       Type: Select Query
    
       Field: OrderID
          Table: Orders
       Field: OrderDate
          Table: Orders
          Criteria: =Eval("Forms!FrmEval!Text0")
    					
  3. ??? ??????? QryEval ???????.
  4. ????? ????? ???? ??????? ?? ????? ??? ?? ???? ?? ??????? ?? ????? ????? "?????":
       
       Form: FrmEval
       -----------------------------
       Caption: Eval Form
    
       Text box:
          Name: Text0
       Command button:
          Name: Command0
          Caption: Run Query
          OnClick: [Event Procedure]
    					
  5. ????? ??????? OnClick ??? ????? ??? ????? ????? ??????.
    Private Sub Command0_Click()
       Dim MyDB As Database
       Dim MySet As RecordSet
       Set MyDB = CurrentDb()
       Set MySet = MyDB.OpenRecordSet("QryEval")
       MySet.MoveFirst
       MsgBox MySet!OrderID
       MySet.Close
    End Sub
    					
  6. ??? ??????? FrmEval ??? ?? ???? ?? ????? ????? "?????".
  7. ???? 4 8 94 ?? ???? ???? ?? ???? ??? ???? "????? ?????????". ???? ???? ???? ????? ???? ???? ??? "????? ?????".
??? ??? ???? ?? ???? ?????? ?? ???? ??? ??????? ???? Eval() ??????? ????? ????????? ?? ???? ???? ???? ??????? ???????:
  1. ?? ???? ??????? QryEval ?? ????? ????? "?????".
  2. ????? ?????? OrderDate ??? [???????]! [FrmEval]! [Text0].
  3. ??? ????????? ???????.
  4. ???? ????? FrmEval ?? ????? ????? "?????".
  5. ???? 4 8 94 ?? ???? ???? ?? ???? ??? ???? "????? ?????????".

    ???? ???? ????? ????? ???????:
    ??? ??? ??????? 3061:
    ?????? ????? ????. 1 ???????.

?????

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

???????

???? ???????: 198462 - ????? ??? ??????: 07/???? ??????/1435 - ??????: 2.2
????? ???
  • Microsoft Access 2000 Standard Edition
????? ??????: 
kbnosurvey kbarchive kbmt kbhowto kbprogramming KB198462 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????198462

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