Hi All,
I went to this web site
http://www.blueclaw-db.com/microsoft...s_security.htm
which has some VBA code about -- Access Database Security Alternative
(Security without Work Group Administrator). I found it quite useful so that I create what should be needed(form and table) for the this VBA to run.
However, as soon as it ran to the second line of the code,

Private Sub Form_Open(Cancel As Integer)
    'initialize global variables
    Call set_globals
    'Hide tabs
    ....

I had this 'Compile error - Sub or Function not defined' come up. As I don't know much about VBA, I don't know how to fixed it.
Please help me :( Please

Thank you very much

That is calling a subroutine most likely. The subroutine was left out of the code that was posted. I did a search on the page and couldn't find it. So unless you can come up with that code, your solution won't work.

Later in the code another sub is called and the code is provided, so maybe the poster left out the code by accident. You will need to contact them directly.

HTH

mmcdonal

I emailed him and has fixed the webpage. But now I got another complie error on
'set welcome to include users name or invalid logon if bad logon
Me.TabCtl0.Pages.Item(0).Caption = "Welcome " & Nz(DLookup("USername", "L_Employees", "employee_id=" & get_global"Employee_ID")), "Invalid Login")

Anyone please kindly help me again...