Date field validation rule?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want the employees to be able to choose from a combo list of weekly end
dates (always a Thursday) to charge their time to. Lookup wizard is not
available on date/time fields. If I change the field to text, then I cannot
run a query based on date range. This field has to be one where the
employee's only option is to choose the week ending date, thus a limit to
list thing, because they are not capable of being consistent.
Is there any way to create a validation rule / macro / anything that will
allow this?
 
You don't need to use the Lookup wizard to build a combobox. I assume that
you have a table with a list of the valid end dates. In your form, based the
rowsource of your combobox on this table.

Barry
 
Create a table of Thursdays and base the combo box on it. Limit to List. For
the criteria in a query based on the 'Thursdays' table make it something like
Date() - 14 so that they can pick a date in the past.
Click to expand...

Easy way to make a lot of Thursdays: Open Excel and type in 5/25/2006 in
cell A1. In cell A2 type in =A1+7 . Click on A2 and do a copy of the cell.
Click on A3 and drag down for as long as you think you'll need the list of
Thursdays. A600 got me up to the year 2017. Save the worksheet. In Access
import this spreadsheet into a table.
 
Back
Top