, , , , . , . . " " , "hay". , . , .
. 15.20. "hay" . ?
. (. . " " 7, . "" 11 . " " 13),
, , Access. o , . .
, , , . 15.20.
, . .
1. .
2. | →
→ (Form Tools | Design → Controls → Text Box) .
3. .
4. - , , SearchText ().
. , , , . , , .
. (OpenForm), , , , Access AnimalTypes ( ). , , (GoToControl) (Control Name), Description ().
(FindRecord). (="hay") (Find What) SearchText (=SearchText). , , (=[SearchText]).
|
|
, . . , . SearchText , SearchForm, =Forms!SearchForm!SearchText.
, AnimalTypes . .
1. | →
→ (Form Tools | Design → Controls → Button) .
2. <Esc> .
3. .
4. (On Click) .
5. Search (). .
. , - SearchText Search. , .
, . (SetValue). , . , , . . ( , , . 13.) Access , (. . " Access " ).
. , (Item) , . , , . (Expression) . .
, SearchText, SearchText, a "" ( ).
, (, Clear ()). , SearchText Forms! AnimalTypes! SearchText, Access, .
|
|
, , . . ( , , .) , . (Enabled) ( , ) (Visible) ( ). .
, Access . , Access
(Text) , .
, , . . , , . . . .
(Condition). . , | → → (Macro Tools | Design → Show/Hide → Conditions).
, . , : . Access . ( .)
.
■ ( ), Access , - ;
■ , Access ;
■ , Access .
, .
: ? . :
[ProductName] = "Baloney"
ProductName "Baloney" ( ). ProductName ( ), . ProductName - , .
, . , Not. Not [ProductName] ="Baloney" , .
(=) , . " " (>) " " (<) " " (). , , :
[Price] > 49.99
Access. ( 4 7 .) , , :
|
|
Len ([FirstName]) < 3
, , , . , , .
Access , , IsNull (). , , . IsNull () , . :
IsNull ([LastName])
, LastName .
( ). IsNull () , , , .
, , , . , : And () Or ().
And , , . , FirstName, LastName :
Len([FirstName]) < 3 And Len([LastName]) < 3
Or . , FirstName LastName . , .
IsNull([FirstName]) Or IsNull([LastName])
, Not, And Or . , .