Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 27th, 2009, 12:36 PM
Friend of Wrox
 
Join Date: Jun 2005
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default Display Future Date

Hi All Agin
I need when users select display date that they cannot select a date in the past only current date or some date in the future

Regards
__________________
Brendan Bartley
 
Old January 29th, 2009, 04:10 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

How are you doing data validation? What type of control are they using to select a date?

You can do table level data validation and make a date earlier than Date() invalid, or check their input with code and reset the date, etc.
__________________
mmcdonal

Look it up at: http://wrox.books24x7.com
 
Old January 30th, 2009, 05:59 AM
Friend of Wrox
 
Join Date: Jun 2005
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am using a calendar control
__________________
Brendan Bartley
 
Old January 30th, 2009, 08:54 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

On the date field in your table that the date picker is bound to (I assume) add this validation rule:

>=Date()

Then add an error message in the validation text line.

That is the simplest way to do it since it doesn't matter what type of control you use to take in the date in that case.

Did that help?
__________________
mmcdonal

Look it up at: http://wrox.books24x7.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
Validating future date skev Infopath 0 October 2nd, 2007 04:17 AM
Display Table by Date werD420 Classic ASP Databases 9 January 31st, 2005 05:26 PM
How to Validate a Date for present and Future Cute Designer J2EE 1 November 9th, 2004 10:45 PM
Future Date Validation Cute Designer Classic ASP Basics 10 October 26th, 2004 05:58 AM
Date didn't display in pdf chinhow Crystal Reports 4 April 13th, 2004 03:29 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.