By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,162 Members | 999 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,162 IT Pros & Developers. It's quick & easy.

Weekdays only on Form/Table

P: 4
We use an Access database as a task scheduler. I thought I could include a validation rule that would make it so tasks could not be scheduled on Saturday or Sunday. I thought wrong.

Can anyone direct me on how to do this?
Dec 1 '06 #1
Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,660
You've shared so little detail with which to work - I can only say that the Weekday() function will return a number representing the day of the week.
This should help you to set up restrictions in your database to allow only what you want.
Dec 1 '06 #2

ADezii
Expert 5K+
P: 8,669
We use an Access database as a task scheduler. I thought I could include a validation rule that would make it so tasks could not be scheduled on Saturday or Sunday. I thought wrong.

Can anyone direct me on how to do this?
'Assuming that your Date Field min the underlying Table is called
'[Task_Date], in the Validation Rule Row type the following:

Weekday([Task_Date]) In (2,3,4,5,6)

'This will have the effect of only allowing Dates that do not fall on a Saturday or
'Sunday. BTW, you should also provide informative feedback in the event that
'the User prvides an invalide Date (Saturday or Sunday). This can be done
'in the Validation Row

Hope this helps you...
Dec 1 '06 #3

P: 4
Yes it did, thank you
Dec 3 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.