Èçìåðèòü âðåìÿ âûâîäà äàííûõ íà ôîðìå, èñïîëüçóÿ òàéìåð è Recordset |
Private Declare Function timeGetTime Lib "winmm.dll" () As Long Private Sub Form_Current() ' Åñëè äëÿ çàïèñè òåêóùåãî ñîòðóäíèêà èìååòñÿ ôîòîãðàôèÿ, ' îíà îòîáðàæàåòñÿ â ôîðìå. Åñëè óêàçàííûé ôàéë íå ñóùåñòâóåò, ' ëèáî åñëè äëÿ òåêóùåãî ñîòðóäíèêà ïîëå èìåíè ôàéëà ïóñòî, ' íàäïèñü errormsg âûâîäèò ñîîòâåòñòâóþùåå ñîîáùåíèå. Dim res As Boolean Dim fName As String Dim t As Long t = timeGetTime() path = CurrentProject.path On Error Resume Next ErrorMsg.Visible = False If Not IsNull(Me![Ôîòîãðàôèÿ]) Then res = IsRelative(Me![Ôîòîãðàôèÿ]) fName = Me![Ôîòîãðàôèÿ] If (res = True) Then fName = path & "\" & fName End If Me![Êàðòèíêà].Picture = fName Me![Êàðòèíêà].Visible = True Me.PaintPalette = Me![Êàðòèíêà].ObjectPalette If (Me![Êàðòèíêà].Picture <> fName) Then Me![Êàðòèíêà].Visible = False ErrorMsg.Caption = "Ôîòîãðàôèÿ íå íàéäåíà" ErrorMsg.Visible = True End If Else Me![Êàðòèíêà].Visible = False ErrorMsg.Caption = "Äëÿ äîáàâëåíèÿ ôîòîãðàôèè íàæìèòå êíîïêó ""Äîáàâèòü/èçìåíèòü""" ErrorMsg.Visible = True End If MsgBox "Îáðàáîòêà äàííûõ äëèëàñü " & Format$((timeGetTime() - t) / 1000, "0.000") & " ñåê." End Sub
http://www.sql.ru/forum/1134985/izmerit-vremya-vyvoda-dannyh-na-forme-ispolzuya-taymer-i-recordset
| Êîììåíòèðîâàòü | « Ïðåä. çàïèñü — Ê äíåâíèêó — Ñëåä. çàïèñü » | Ñòðàíèöû: [1] [Íîâûå] |