Results 1 to 3 of 3
  1. #1
    Chekotah is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    Mar 2014
    Posts
    32

    Need help PLease!!! Need assistance in going from log in to specific menu


    Good Morning,

    On the data base I am creating. I am trying to get it to go from the log on screen to the Form or Menu to for the employee to choose task. these are based off of employee ID and whether they have User rights or Admin rights. Please advise any help. thanks in advance

  2. #2
    Chekotah is offline Advanced Beginner
    Windows 7 64bit Access 2003
    Join Date
    Mar 2014
    Posts
    32
    In regard to the above here is the code that I have. Code does not do anything. It will not give me the error message nor will it move to the menu screen.

    Private Sub Login_Click()
    On Error GoTo Err_Log_in_Click
    Dim varEvent As Variant
    Dim stDocName As String

    varEvent = DLookup("[User_Type_Code]", "[ID_PW_Check]")

    If Not IsNull(varEvent) Then

    stDocName = "EditActivity" & varEvent
    DoCmd.OpenForm Menu
    Else
    MsgBox "User name not found or password is incorrect", vbInformation, "Warning"
    End If
    Exit_Login_Click:
    Exit Sub

    Err_Login_Click:
    MsgBox Err.Description
    Resume Exit_Login_Click
    End Sub

  3. #3
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Have you tried step debugging?

    You could add some message boxes or debug.print here and there to see what code is firing?

    I would start with

    varEvent = DLookup("[User_Type_Code]", "[ID_PW_Check]")
    msgbox varevent

Please reply to this thread with any new information or opinions.

Similar Threads

  1. VBA assistance
    By Kwbrown in forum Programming
    Replies: 3
    Last Post: 03-15-2014, 03:09 PM
  2. Replies: 34
    Last Post: 03-03-2014, 09:24 AM
  3. Qry Assistance Please
    By buck in forum Access
    Replies: 8
    Last Post: 12-31-2013, 08:52 AM
  4. Menu with multiple sub menu's
    By Simtech76 in forum Forms
    Replies: 1
    Last Post: 04-30-2013, 02:30 PM
  5. Replies: 0
    Last Post: 09-25-2012, 09:16 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums