Èñïîëüçîâàíèå ëîãèíà è ïàðîëÿ â access |
Private Sub cmdLogin_Click() Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("Ñîòðóäíèêè") With rst If IsNull(Me.cboCurrentEmployee.Value) Then MsgBox "Îøèáêà âõîäà! Âûáåðèòå ïîëüçîâàòåëÿ." Exit Sub Else: .FindFirst ("ID=" & Me.cboCurrentEmployee.Value) If .NoMatch Then MsgBox "Îøèáêà âõîäà! Î äàííîì ïîëüçîâàòåëå íåò èíôîðìàöèè â ÁÄ." Exit Sub Else: If Me.Ïîëå_äëÿ_ïàðîëÿ.Value <> .Fields("Ïàðîëü").Value Then MsgBox "Ïàðîëü íå ïðàâèëüíûé èëè íåñîîòâåòñòâóåò èìåíè ïîëüçîâàòåëÿ" Exit Sub End If If IsNull(Me.Ïîëå_äëÿ_ïàðîëÿ.Value) Then MsgBox "Âû íå ââåëè ïàðîëü!" Exit Sub End If DoCmd.Close Select Case .Fields("Äîëæíîñòü").Value 'Åñòåñòâåííî ïîëå "Äîëæíîñòü" äîëæíî áûòü â òàá. "Ïîëüçîâàòåëè" Case "Äèðåêòîð" DoCmd.OpenForm "Ïàðòíåðû" Case "Êîîðäèíàòîð ïî ïðîäàæàì" DoCmd.OpenForm "Íàêëàäíûå" Case "Ïðîñòî õîäèò çà çàðïëàòîé" DoCmd.OpenForm "Ôîðìà_äëÿ_ìåíÿ_è_áîññà" End Select End If End If End With rst.Close Set rst = Nothing End Sub
http://www.sql.ru/forum/1296553/ispolzovanie-logina-i-parolya-v-access
| Êîììåíòèðîâàòü | « Ïðåä. çàïèñü — Ê äíåâíèêó — Ñëåä. çàïèñü » | Ñòðàíèöû: [1] [Íîâûå] |