-Ïîèñê ïî äíåâíèêó

Ïîèñê ñîîáùåíèé â rss_sql_ru_access_programming

 -Ïîäïèñêà ïî e-mail

 

 -Ïîñòîÿííûå ÷èòàòåëè

 -Ñòàòèñòèêà

Ñòàòèñòèêà LiveInternet.ru: ïîêàçàíî êîëè÷åñòâî õèòîâ è ïîñåòèòåëåé
Ñîçäàí: 16.03.2006
Çàïèñåé:
Êîììåíòàðèåâ:
Íàïèñàíî: 4


 listbox.multiselect îòçûâàåòñÿ ëèøü ïîñëåäíèé âûáðàííûé ýëåìåíò

Ñðåäà, 17 Ìàÿ 2017 ã. 16:16 + â öèòàòíèê
Äîáðîå ÷òî-òî.
Èñïîëüçóþ Access 2013 ãîäà. Åñòü ïðîáëåìà ñî ñïèñêîì. Íåîáõîäèìî îðãàíèçîâàòü ñïèñîê, âûáðàòü îòòóäà íåñêîëüêî ýëåìåíòîâ è èçìåíèòü ó íèõ îäèí ïàðàìåòð.  èòîãå ÿ âûáðàë Multiselect "ïðîñòîé" (â 2013 íåò "íåñâÿçàííîãî"). Ïîçæå ÿ ïðîáîâàë è ñâÿçàííûé, íî ðåçóëüòàòà âñ¸ ðàâíî íåò. È òàê, ïðîáëåìà: êîãäà íà÷èíàþ îáðàáàòûâàòü ñïèñîê, òî îáðàáàòûâàåòñÿ ëèøü ïîñëåäíèé âûáðàííûé ýëåìåíò, íî íå âñå âûäåëåííûå. Ïðîáîâàë èñïîëüçîâàòü öèêë For each.  èíòåðíåòå íàøåë, ÷òî â ïðåäûäóùèõ àêöåñàõ ðåæèì "Ïðîñòîé" êàê ðàç ðàáîòàë ëèøü ñ îäíèì ýëåìåíòîì ñïèñêà, è íåîáõîäèìî âûáðàòü "íåñâÿçàííûé". Íî åãî íåò! Õåëï, ëþäè.
Âîò òàêîé êîä:

Dim zay As DAO.Recordset
Set zay = CurrentDb.OpenRecordset("Zayavki", dbOpenDynaset)
Dim varItem As Variant
Dim i As Integer
   Dim lst As Access.ListBox
   Set lst = zayavki_
   If lst.ItemsSelected.Count = 0 Then
      MsgBox "bla bla bla", vbOKOnly, " Error"
      Exit Sub
   End If

For i = 0 To lst.ListCount - 1
        If lst.Selected(i) Then
            zay.FindFirst "[code] =" & Me.zayavki_Column(0)
            zay.Edit
            zay.Fields("print") = True
            zay.Update
            
        End If
  Next i

zay.Close
Set zay = Nothing
   DoCmd.OpenReport "Otvet", acViewReport

http://www.sql.ru/forum/1260352/v-listbox-multiselect-otzyvaetsya-lish-posledniy-vybrannyy-element


 

Äîáàâèòü êîììåíòàðèé:
Òåêñò êîììåíòàðèÿ: ñìàéëèêè

Ïðîâåðêà îðôîãðàôèè: (íàéòè îøèáêè)

Ïðèêðåïèòü êàðòèíêó:

 Ïåðåâîäèòü URL â ññûëêó
 Ïîäïèñàòüñÿ íà êîììåíòàðèè
 Ïîäïèñàòü êàðòèíêó