User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 427,187 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,199 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 3159 | Replies: 2 | Solved
Reply
Join Date: Mar 2006
Posts: 2
Reputation: Robshaw236 is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
Robshaw236 Robshaw236 is offline Offline
Newbie Poster

Help Validation rule required for time PLEASE HELP

  #1  
Mar 28th, 2006
Hi i need a validation rule for MS Access so that only a time can be entered that is between 18:00 and 23:00

The validation rules must allow for the above numbers inclsuively

Please Help
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Mar 2006
Posts: 2
Reputation: Robshaw236 is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
Robshaw236 Robshaw236 is offline Offline
Newbie Poster

Re: Validation rule required for time PLEASE HELP

  #2  
Apr 6th, 2006
Just to let you know, i have figured it out for myself the validation rule isl

>= #18:00:00# And <= #23:00:00#
Reply With Quote  
Join Date: Oct 2007
Posts: 1
Reputation: dgallanger is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
dgallanger dgallanger is offline Offline
Newbie Poster

Re: Validation rule required for time PLEASE HELP

  #3  
Oct 24th, 2007
thank you for the solution, i found this thread helpful.
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb MS Access and FileMaker Pro Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the MS Access and FileMaker Pro Forum

All times are GMT -4. The time now is 10:01 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC