Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011

    Unanswered: Date Validation Based on Calendar Quarter

    I am using Access 2007 with a SQL Server back-end. I have a combobox with 'Q1, Q2, Q3, Q4' and a textbox to enter a date. Is there a way to restrict the mm/dd according to what Quarter is selected? For example, if I choose Q1 then I am only allowed to enter a date from 01/01/xx to 04/01/xx.

    Thank you all very much for your help!

  2. #2
    Join Date
    Oct 2009
    sure - you've almost written the code in your post !....

    so the question is where is best to put that criteria....maybe in the AfterUpdate or perhaps BeforeUpdate event of the date field.....and have a msgbox to pop up if the date enter is not valid.
    www CahabaData com

Posting Permissions

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