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

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

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

 

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

 -Ñòàòèñòèêà

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


Ïî÷åìó íå ðàáîòàåò DLookup???

Ïîíåäåëüíèê, 13 Îêòÿáðÿ 2014 ã. 17:34 + â öèòàòíèê
Ñóòü ïðîáëåìû: Õî÷ó ïðèñâàòûâàòü ðåéòèíã ïîïóëÿðíîñòè (èñïîëüçîâàíèÿ) òåõ èëè èíûõ ñòðîê. Ïåðåìåííîé ÒåêÑ÷åò÷èê ïðèñâàèâàåò òåê çíà÷åíèå ñ÷åò÷èêà DLookup â òàáë Ñòóäåíòû. Ïîèñê ïðîèñõîäèò ïî èìåíè. Âñå âðîäå áû òàê, íî DLookup âîçâðàùàåò íå Èíòåäæåð, à ÷òî-òî äðóãîå. Ïî÷åìó?

Âîò ñàì êîä:
If Not IsNull(Form_Ñäàë.ÔÈÎ) Then
    ÒåêÑ÷åò÷èê = DLookup("Ñ÷åò÷èê", "Ñòóäåíòû", "Èìÿ= '" & Form_Ñäàë.ÔÈÎ & "'")
    ÒåêÑ÷åò÷èê = ÒåêÑ÷åò÷èê + 1
    DoCmd.SetWarnings False
DoCmd.RunSQL "UPDATE Ñòóäåíòû SET Ñ÷åò÷èê = '" & ÒåêÑ÷åò÷èê & "' WHERE Èìÿ = " & Form_Ñäàë.ÔÈÎ & ""
Me.ÔÈÎ.Requery

http://www.sql.ru/forum/1120700/pochemu-ne-rabotaet-dlookup


 

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

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

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

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