Ðàáîòà ñ ïîëåì, äîïóñêàþùèì íåñêîëüêî çíà÷åíèé, â êîäå VBA |
Option Compare Database Option Explicit Private Sub Êíîïêà5_Click() Dim rstDati As DAO.Recordset Dim qdfDati As QueryDef Dim temp, fam As String Const BoxTitle = "Ïåðèîä îïðîñà" Dim dbeg, dfin As Date 'ÇÀÏÐÎÑ ÄÀÒ ÍÀ×ÀËÀ È ÊÎÍÖÀ ÎÏÐÎÑÀ temp = InputBox("Ââåäèòå íà÷àëüíóþ äàòó îïðîñà ××.ÌÌ.ÃÃÃÃ", BoxTitle) dbeg = temp 'dbeg = Format(dbeg, "dd mm yyyy") temp = InputBox("Ââåäèòå êîíå÷íóþ äàòó îïðîñà ××.ÌÌ.ÃÃÃÃ", BoxTitle) dfin = temp Set qdfDati = CurrentDb.CreateQueryDef("", "PARAMETERS db DateTime, df DateTime; " _ & "SELECT tblÆÓÐÍÀË.doprosa, tblÆÓÐÍÀË.Ôàìèëèÿ FROM tblÆÓÐÍÀË " _ & "WHERE (((tblÆÓÐÍÀË.di) Between db And df));") ' ÑÎÇÄÀÍÈÅ ÂÐÅÌÅÍÍÎÃÎ ÄÈÍÀÌÈ×ÅÑÊÎÃÎ ÎÁÚÅÊÒÀ Recordset ñ êîíêðåòíûìè ïàðàìåòðàìè qdfDati.Parameters(0) = dbeg qdfDati.Parameters(1) = dfin Set rstDati = qdfDati.OpenRecordset() If rstDati.RecordCount <> 0 Then rstDati.MoveFirst fam = rstDati![Ôàìèëèÿ] MsgBox fam End If rstDati.Close End Sub
http://www.sql.ru/forum/1150963/rabota-s-polem-dopuskaushhim-neskolko-znacheniy-v-kode-vba
| Êîììåíòèðîâàòü | « Ïðåä. çàïèñü — Ê äíåâíèêó — Ñëåä. çàïèñü » | Ñòðàíèöû: [1] [Íîâûå] |