Search results

  1. M

    Iif Then - Forcing Security for accdb

    RESOLVED!!!! Thanks so much!
  2. M

    Iif Then - Forcing Security for accdb

    General database access is not restricted for most personnel and Users are constantly added and removed through our IT group. I only want to restrict access to this one form for a group of Admins, without setting access levels for all personnel. Thanks so much for your quick reply.
  3. M

    Iif Then - Forcing Security for accdb

    Thanks so much for the quick reply, I'm new and have followup questions :) In the tblAdmin, the field is "LANID"; but the corresponding ID on the current form is "UserID". If the current form's "UserID" is listed as a "LANID" in tblAdmin, I need it to count. Could you please clarify based on...
  4. M

    Iif Then - Forcing Security for accdb

    I have buttons leading to forms that should only be accessed by Users if their ID appears in tblAdmins. How do I correctly format the bolded line: Private Sub AllRelBut_Click() On Error GoTo Err_AllRelBut_Click Dim stDocName As String Dim stLinkCriteria As String stDocName =...
Top Bottom