Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
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 June 15th, 2005, 05:21 PM
Friend of Wrox
 
Join Date: Jun 2004
Posts: 245
Thanks: 0
Thanked 0 Times in 0 Posts
Default Easy Ques -- Datetime validation for Access

Hello
I am a SQL Server user and a first time Access user. The Start_date column in Access contains invalid Datetime. Whoever designed the Access allowed users to enter the start date so I have some rows that have an invalid start date like 9/9/199.

I have 150,000 records. How can I tell which rows are invalid. I also noticed that T-SQL that use in SQL View don't always work.
Help me please.

 
Old June 16th, 2005, 09:13 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

If the Date column is Text, then you can use an input mask and Access will run its own validation rules.

You can also program validation rules on a Date column.

I am not sure how I would approach validating existing records. I could write a brute force routine that would do it, but I am sure some of the posters here will have more elegant solutions.


mmcdonal
 
Old June 16th, 2005, 01:52 PM
Friend of Wrox
 
Join Date: Jun 2004
Posts: 245
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Date Column is datetime datatype. Can someone give me a more specific answer to this problem?

Should I make the Date Column into text first? How do I do that in Access?






Similar Threads
Thread Thread Starter Forum Replies Last Post
Easy hyperlink ques with iframe bekim Javascript How-To 4 September 21st, 2005 02:45 AM





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