Newbie erotiseis gia tin Access

[NickTheGreek]

Exo ftiaksei enan pinaka me 3 stiles.Onoma aeroskafous,onoma kataskeuasti,xora proeleuseos.Ton pinaka auton ton emfanizo se mia forma se tabular morfi.Stin forma auti exo episis kai 3 comboboxes,analoga me tis stiles, pou emfanizoun ta analoga onomata,meso tis entolis

 

SELECT table1.country from table1 UNION select "*" as Allchoice from table1.

 

Otan epilegetai mia xora px Ellada (kai sta alla comboboxes h epilogi einai "*") meso tou macro ApplyFilter kai Where Condition:

 

[country] Like [Forms]![form1]![countrycmb] And [manufacter] Like [Forms]![form1]![manufactercmb] And [planetype] Like [Forms]![form1]![planecmb]

 

mou emfanizei ta records me xora proeuleuseos tin ellada.Auta pou thelo na matho einai:

 

1)pos mporo anti tou "*" na balo px "(All)" kai na eksakolouthei na mou ta emfanizei ola.

 

2) pos moro tin forma (tabular) na tin xoriso katheta stin mesi gia na grapso alles plirofories sto allo miso

 

3)pos ginetai me ena click sto onoma tou aeroskafous,na mou emfanizei mia deuteri forma xoris na kanei to programma editing sto textbox pou anagrafetai to onoma.An balo enabled=no tote den "pianei" to click tou mouse.An balo labels den mporo na ta sindeso me ton pinaka