Results 1 to 6 of 6
  1. #1
    lolos66666 is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Mar 2011
    Posts
    3

    Enable or Disable Field in Forum

    Hello
    Please any body assidt me i have a forum for attendance database for employees with the hours attended .


    I need to let the hours field inactive if the employee is absent or on leave?

    please assist me with code or any criteria to resolve this please

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Is there a Control on the Form for "Absent/Leave"?

  3. #3
    lolos66666 is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Mar 2011
    Posts
    3
    Yes Please It is a form have a field to choose Absent or Present

    I need to let hours field active only when user choose present and dimmed when absent choosen

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Then you need a procedure that will Enable or Disable the control based on the Value in that control and call it from the OnCurrent event of the form and the AfterUpdate event of that control.

  5. #5
    lolos66666 is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Mar 2011
    Posts
    3
    Thanks very much bet give me example

    on current form = ?????

    After Update Field = ?????

    Please tell me the forlmula please or = what?

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Can you get to the Class (code) module of the form from design mode? <ALT> F11

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 02-25-2011, 10:03 AM
  2. Replies: 9
    Last Post: 12-17-2010, 11:44 AM
  3. Function to Enable/Disable Field
    By swalsh84 in forum Programming
    Replies: 5
    Last Post: 11-04-2010, 02:48 PM
  4. Replies: 3
    Last Post: 09-29-2010, 09:31 AM
  5. Replies: 5
    Last Post: 06-17-2009, 02:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums