|I logged in under a different account so while the name changed, it is still me.|
When the data bases are loading this is the message, "Your Microsoft Access database project contains a missing or broken reference to the file 'MSCAL.OCX' version 7.0. The error message comes again after 'enabling content'. As soon as you try to open a form other than the start up I end up in the VBA viewer for that form:
"Compile error: Can't find project or library"
the code is as follows:
Private Sub form_Load()
Dim userName As String
Dim dept As String
Dim role As String
userName = Environ("USERNAME")
If IsNull(DLookup("Department", "Employees", "User_Name='" & userName & "'")) = True Then
MsgBox "You are not authorized to acces this application. Contact Help Desk for authorization"
dept = DLookup("Department", "Employees", "User_Name='" & userName & "'")
role = DLookup("Role", "Employees", "User_Name='" & userName & "'")
Me.deptLbl.Caption = dept
Select Case dept
The same messages appear on all of our databases that pull in a user name/ windows id. These databases were built by interns from a local MBA program. I am not strong with VBA (yet) so please be patient.