2015年10月14日水曜日

VBA

I made Admin form, and it can connect to other forms.
Members who have account of admin level can management schedule, member, and tasks.

When click the save bottom, check the input and then update Member table.
    Dim oRS As DAO.Recordset

    If InputCheck() = False Then
       Exit Sub
    End If

    Set oRS = CurrentDb.OpenRecordset("Member", dbOpenDynaset)

    With oRS

        .AddNew

        .Fields("First_Name").Value = Me.txtFirstName.Value
        .Fields("Last_Name").Value = Me.txtLastName.Value
        .Fields("DOB").Value = Me.txtBirth.Value
        .Fields("Phone_num").Value = Me.txtPhone.Value
        .Fields("Team_ID").Value = Me.cbTeam.Value
        .Fields("Login_ID").Value = Me.txtLoginID.Value
        .Fields("Email").Value = Me.TxtPassword.Value
        .Fields("Password").Value = Me.TxtPassword.Value
        .Fields("User_Status").Value = Me.cbStatus.Value
     
        .Update

    End With

    oRS.Close
    Set oRS = Nothing

    MsgBox Me.txtFirstName & " Compleated Register", vbOKOnly + vbInformation, "Register"

    DoCmd.Close acForm, "Member"

End Sub

I done register function, and next is task management function..

0 件のコメント:

コメントを投稿