Recent content by JohnMichael72

  1. J

    View users logged into database MS Access 2016

    Sir, I wanted to thank you for sharing your lockout and user monitoring code, extremely useful!! I do have a question that I am hoping you can assist me with. The lockout feature works well as long as the lockout text file is located in the same location as the frontend; however, my users copy...
  2. J

    Double Click Event To Handle Empty Field

    Requesting your assistance with something that I am sure you will find super easy; however I am struggling. I have a double click event set up on a subform field that when clicked opens another form to that record, working amazingly well. I would like to add some code that allows the user to...
  3. J

    Access Login Form with user level page direction-GUID issue

    Thank you so much!! Adding the StringFromGUID to the UserLevel worked!! Also, I was not adding {} to the "If UserLevel = ..." code before. You have helped me immensely and I thank you so much!!!!!!!! JM
  4. J

    Access Login Form with user level page direction-GUID issue

    This is the area that is the issue. Now that we are using GUID's, the "If UserLevel = 3" and "If UserLevel = 1" no longer work as the 1 and 3 used to reference the old autonumber integer values for Admin and SuperAdmin. Those values are now GUID's so I am thinking I need to be able to specify...
  5. J

    Access Login Form with user level page direction-GUID issue

    Arnelgp, Thank you very much for helping. So the issue isnt with the UserID's or password changing or anything like that. The issues rears its head with the custom page direction which is based upon the "UserLevel". There is SuperAdmin, Admin and User as three user levels. Before I converted...
  6. J

    Access Login Form with user level page direction-GUID issue

    This is the part of the code that I believe I am having issues with. 'open different form according to user level If UserLevel = Then ' for superadmin DoCmd.ShowToolbar "Ribbon", acToolbarYes DoCmd.NavigateTo...
  7. J

    Access Login Form with user level page direction-GUID issue

    Yes Sir, the UserID was converted. I changed the code at the top "Dim UserLevel, ID As Integer" to "As String" thinking that was part of the problem. I still cannot get the UserLevel part to work with the GUID's now though.
  8. J

    Access Login Form with user level page direction-GUID issue

    There definitely is, I am just having a really difficult time with the placement...the code used on the login form is pretty long and I am very much a beginner. Most of the code I found and modified to fit my database.
  9. J

    Access Login Form with user level page direction-GUID issue

    I was definitely not happy about converting to GUID's...everything works so perfectly on the old database...UGH.
  10. J

    Access Login Form with user level page direction-GUID issue

    Hello All, I am in desperate need of some assistance with modifying some code in VB. I created a database for work some time ago that has VB code written that requires the user to log in. Once they log in, depending upon the security level assigned to that user, they are taken to one of three...
Top Bottom