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

Prevent data entry after a certain time

P: 4
We use Access as a task scheduler. Right now I have it set up so that task must be scheduled tomorrow or later, however, I want to set it up so I can also prevent scheduling on a certain date after a certain time.

Example: On December 4th before 4:00PM, you can schedule as early as December 5th. On December 4th AFTER 4:00PM, you can schedule as early as December 6th.
Dec 1 '06 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,660
We use Access as a task scheduler. Right now I have it set up so that task must be scheduled tomorrow or later, however, I want to set it up so I can also prevent scheduling on a certain date after a certain time.

Example: On December 4th before 4:00PM, you can schedule as early as December 5th. On December 4th AFTER 4:00PM, you can schedule as early as December 6th.
Expand|Select|Wrap|Line Numbers
  1. Dim datSchedule As Date
  2.  
  3. datShedule=Date()+IIf(Hour(Now())<16,1,2))
Dec 1 '06 #2

Post your reply

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