+ Reply to Thread
Results 1 to 3 of 3

Bypassing Time Validation Routine

  1. #1
    Forum Contributor
    Join Date
    06-15-2009
    Location
    Ontario, canada
    MS-Off Ver
    Office 365
    Posts
    371

    Bypassing Time Validation Routine

    I have a userform in which the user selects an individual's name from a combobox (ce_name), and then enters the start (ce_start) and end (ce_end) times in two proceeding textboxes. These two time values are checked then to see whether they are valid times. (custom function onExit)

    Please Login or Register  to view this content.
    The problem I'm having is bypassing the time validation check when the user selects "Not staffed" from the combobox. If the user selects "Not staffed", I have the time start and time stop defaulting to an "X". Well ... you can see the problem. Although I want an "X" in this scenario, the validation check disallows it.

    Please Login or Register  to view this content.
    What might you suggest I need to add to provide a bypass when ce_name = "Not staffed", or ce_start / ce_end equal "X"?

    Thank you in advance.

    Jenn

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Bypassing Time Validation Routine

    maybe
    Please Login or Register  to view this content.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Forum Contributor
    Join Date
    06-15-2009
    Location
    Ontario, canada
    MS-Off Ver
    Office 365
    Posts
    371

    Re: Bypassing Time Validation Routine

    Really? I obviously never thought things could be that easy.
    Thanks Joseph!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1