-

   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


: [1] []
 

:
: 

: ( )

:

  URL