RowSource ïîëÿ ñî ñïèñêîì ïðè ïåðåõîäå íà ADP
|
|
Âîñêðåñåíüå, 17 Àâãóñòà 2014 ã. 22:35
+ â öèòàòíèê
Äîáðûé äåíü!
Óâàæàåìûå ôîðóì÷àíå, ïðîøó ïîìî÷ü. Òðåòèé äåíü ìó÷àþñü - íè÷åãî íå âûõîäèò((
 Access (.accdb) áûëà òàáëè÷íàÿ ïîä÷èíåííàÿ ôîðìà, íà íåé-combobox. Èñòî÷íèê ñòðîê - äàííûå èç òàáëèöû
ID NAME
1 Èâàíîâ
2 Ïåòðîâ
3 Ñèäîðîâ
SELECT ID, NAME
FROM NAMES;
Ñî âðåìåíåì âîçíèêëà íåîáõîäèìîñòü îãðàíè÷èòü ñïèñîê ôàìèëèé. Äëÿ ýòîãî ÿ ïîñòàâèëà íà çàãðóçêó ôîðìû:
Private Sub Form_Load()
Me.ÏîëåÑîÑïèñêîì1.RowSource = "SELECT NAMES.ID, NAMES.NAME FROM NAMES where ID in(1,2)"
End Sub
Ïðè ïåðåõîäå íà ADP âîçíèêëà ïðîáëåìà: â ðàíåå âíåñåííûõ çàïèñÿõ íå îòîáðàæàþòñÿ ïîëÿ ñ ID=3, Ñèäîðîâ, õîòÿ â Access âñå ðàáîòàëî, çàïèñè ñ ID=3 áûëè âèäíû íà ôîðìå. Èçâèíèòå çà, âîçìîæíî, ãëóïûé âîïðîñ. Î÷åíü æäó ïîìîùè. Çàðàíåå ñïàñèáî!!!
http://www.sql.ru/forum/1111143/rowsource-polya-so-spiskom-pri-perehode-na-adp
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-