akaii | Hello,
Je ne vois pas ce que j'ai qui manque a la ligne "status = rsEventText.FindFirst["EventText"]" du code ci-dessous, je recois une erreur "Expected End of statement"
Code :
- IDNumber= rs("IndividualNdx" )
- requeteInAndOut = "SELECT RptEvents.EventTypeNdx, RptEvents.DateTime, RptEvents.DeviceName, " &_
- "RptEventTypes.EventText, RptEvents.IndividualNdx FROM RptEventTypes " &_
- "INNER JOIN RptEvents ON RptEventTypes.EventTypeId = RptEvents.EventTypeNdx " &_
- "WHERE (((RptEvents.IndividualNdx)='" & IDNumber & "')) order BY RptEvents.DateTime desc"
- 'msgbox requeteInAndOut, vbok, "test"
- set rsEventText = cn.Execute (requeteInAndOut)
- 'msgbox rsEventText("EventText" ) & " " & rs("FirstName" ), vbok, "test"
- Dim status
- status = rsEventText.FindFirst["EventText"]
- If status = "Reader Entry" Then
- status = "1"
- msgbox status,vbok,"test"
- Else if status = "Reader Exit" Then
- status = "0"
- msgbox status,vbok,"test"
- End if
- End if
|
Si quelqu'un peu aider...
Merci d'avance Message édité par akaii le 03-02-2009 à 23:21:56
|