B
Bill
I am using the GBL_Access_Level script (Gobals) and I am getting the error of:
error Ambiguous name detected: set_access
On the following sub:
Private Sub Form_Open(Cancel As Integer)
Dim ntlogin As String
Init_Globals ' initialize the global variables
ntlogin = Environ("Username") ' get the username of person logged into
computer
GBL_Access_Level = Nz(DLookup("Access_Level", "L_Users", "UserName='" &
ntlogin & "'"), "None") ' lookup the access level in our users table
set_access (GBL_Access_Level) ' call the function to set the security on
the tabs and forms
It verifies using the script:
Option Compare Database
Global GBL_Access_Level As String
Public Function Init_Globals()
GBL_Access_Level = "None"
End Function
Public Function Get_Global(gbl_parm)
Select Case gbl_parm
Case "GBL_Access_Level"
Get_Global = GBL_Access_Level
End Select
End Function
Somehow I started getting an error when I added a new user level. I've
added and changed user levels in the past with no problems, but something I'm
doing now is giving me a major headache!!! Now when it verifies user, I get
this error and I cant figure out why. Any help is MUCH appreciated.
Thank you,
Bill
error Ambiguous name detected: set_access
On the following sub:
Private Sub Form_Open(Cancel As Integer)
Dim ntlogin As String
Init_Globals ' initialize the global variables
ntlogin = Environ("Username") ' get the username of person logged into
computer
GBL_Access_Level = Nz(DLookup("Access_Level", "L_Users", "UserName='" &
ntlogin & "'"), "None") ' lookup the access level in our users table
set_access (GBL_Access_Level) ' call the function to set the security on
the tabs and forms
It verifies using the script:
Option Compare Database
Global GBL_Access_Level As String
Public Function Init_Globals()
GBL_Access_Level = "None"
End Function
Public Function Get_Global(gbl_parm)
Select Case gbl_parm
Case "GBL_Access_Level"
Get_Global = GBL_Access_Level
End Select
End Function
Somehow I started getting an error when I added a new user level. I've
added and changed user levels in the past with no problems, but something I'm
doing now is giving me a major headache!!! Now when it verifies user, I get
this error and I cant figure out why. Any help is MUCH appreciated.
Thank you,
Bill