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

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

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

 

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

 -Ñòàòèñòèêà

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


Ðàáîòà ñ ïîëåì, äîïóñêàþùèì íåñêîëüêî çíà÷åíèé, â êîäå VBA

Âòîðíèê, 07 Àïðåëÿ 2015 ã. 10:38 + â öèòàòíèê
Óâàæàåìûå ýêñïåðòû!
 êîäå VBA íå ïîëó÷àåòñÿ ðàáîòà ñ ïîëåì, äîïóñêàþùèì íåñêîëüêî çíà÷åíèé. Ïîëå Ôàìèëèÿ òàáëèöû Æóðíàë çàäàíî êàê ïîëå ñî ñïèñêîì, äîïóñêàþùèì íåñêîëüêî çíà÷åíèé. Åñòü òàêæå ïîëå ÄàòàÎïðîñà. Íåîáõîäèìî ïîäñ÷èòàòü, ñêîëüêî ðàç êîíêðåòíàÿ ôàìèëèÿ ó÷àñòâîâàëà â îïðîñàõ çà îïðåäåëåííûé ïðîìåæóòîê âðåìåíè. Ïîêà ÿ ïðîñòî ïûòàþñü âûòÿíóòü çíà÷åíèå ïîëÿ Ôàìèëèÿ â ñòðîêîâóþ ïåðåìåííóþ è ïîëó÷àþ ñîîáùåíèå îá îøèáêå Run-time error ‘3061’. Ñëèøêîì ìàëî ïàðàìåòðîâ. Òðåáóåòñÿ 3.
×òî ÿ äåëàþ íåïðàâèëüíî?

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


 

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

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

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

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