Check date for correctness against a range of dates

G

Guest

I have a combo box on my form with 26 date ranges for pay periods, such as:
12/26/05-1/8/06
1/9/06-1/22/06
1/23/06-2/5/06, etc.
The user first selects the pay period range, and then they have to enter
their time for the specific days and amt. of time spent per work order. Can I
create a module to check the individual dates that they enter against the
date range and create an error message if they pick a date that isn't in the
range they've selected?
I've never witten code before, just used basic macros. So hopefully I'll be
able to understand any answers I get. Thanks!
 
L

Larry Daugherty

You haven't really told us much about this hole you're digging.

You have to go a lot further in detailing how your date ranges are
formed and how the users inter their dates, etc.!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding most recent date for each customer - XL 2007 2
Access MS Access 2010 IIF statement to check if one date is in or out of range of two other dates (fields) 0
tally a range of dates 2
Using a Date Range to create a list of dates 12
Find within Date Range 4
DATES - Grouping sets of sequential dates 3
Checking the current date against a range of dates 6
Return All Date Ranges 1

Top