Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Date & time validation

Posted on 2002-04-16
6
Medium Priority
?
295 Views
Last Modified: 2008-03-17
hi!
 I am not really good in access at all, however i have a job to use an access database with delphi via ADO.

i was wondering, what exactly do i need in the validation text boks to check that we have typed in a date. and another box for time...

time() is no good... since it prints both time & date...


0
Comment
Question by:joepezt
6 Comments
 
LVL 58
ID: 6944721
It's not clear if your using Delphi just to look at the data, or are using Access for the programming.  If your using Access, you'd use the IsDate() function to return a logical to check for a valid date.

Jim.
0
 

Expert Comment

by:muzori
ID: 6944896
put in text box like this
=date()
0
 
LVL 3

Expert Comment

by:marcoszorrilla
ID: 6945263
If you use Delphi via ADO I suppose, or BDE, in both cases you must DoubleClic the TAdoTable, or Ttable and then right button of the mouse - Add all fields.

Now, if you has the little box with all the fields and the form tha you use to enter the data, select a Date or Time field and in the set the EditMask property for exaple !99/99/0000;1;_ for Date, or !90:00:00;1;_ for time.

Then you select  the fiedl and drag it and drop over the form. thats all.

Best Regards.
Marcos.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 2

Author Comment

by:joepezt
ID: 6947227
marocs: how do i put this in the validation rule in my access database?

date (!99/99/0000;1;_) ?
0
 
LVL 3

Accepted Solution

by:
marcoszorrilla earned 40 total points
ID: 6947396
Well if you wont to put this mask in Access.
you must select the field and set the properties like this form example.
Format:ShortDate ..... You select your desired format
InputMask:99/99/00;0;_ You have a list to choice

For Time is the Same, and the same properties to set.

Of Course first at all you select your table and the design mode.

Best Regards
Marcos.
0
 
LVL 2

Author Comment

by:joepezt
ID: 6947437
hehe, ok, I have been blind ;)
thanx =)
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question