[AccessD] Control Property Question

Lonnie Johnson prodevmg at yahoo.com
Sat Jun 30 19:46:30 CDT 2007


Yes, that is correct.

 
May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us




 



----- Original Message ----
From: Joe Hecht <jmhecht at earthlink.net>
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Sent: Saturday, June 30, 2007 6:22:58 PM
Subject: [AccessD] Control Property Question


I use this code to enable or disable code bases on weather an employee needs
licenses to work.



Private Sub CboJobTitle_AfterUpdate()



'If employee is not licensed diasable license controls



    If Me.CboJobTitle = "Admin" Then

    Me.cboIssueAgency.Enabled = False

    Me.txtLicExpires.Enabled = False

    Me.txtDotExpires.Enabled = False

     Else

      Me.cboIssueAgency.Enabled = True

    Me.txtLicExpires.Enabled = True

    Me.txtDotExpires.Enabled = True

     

    End If



They can be hired as admin and later promote and need the licences.



Properties stay set when you close a database and reopen them unless another
event changes them, Is that a correct statement.



You forget so much when you do not do this for a year.



Thanks



Joe Hecht

jmhecht at earthlink.net



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


       
____________________________________________________________________________________
Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.
http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow  


More information about the AccessD mailing list