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

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

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

 

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

 -Ñòàòèñòèêà

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


Èñïîëüçîâàíèå ëîãèíà è ïàðîëÿ â access

Ñðåäà, 20 Èþíÿ 2018 ã. 19:08 + â öèòàòíèê
Äîáðîãî âðåìåíè ñóòîê! Áóäüòå äîáðû, ïîìîãèòå, â VBA ÿ ñîâñåì íîëü è ïîòîìó íå ìîãó ïðèêðóòèòü ê ñâîåé ÁÄ ýòîò êîä:

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


 

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

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

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

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