Alpha Video Training
Results 1 to 3 of 3

Thread: Help with Date Problem

  1. #1
    Barry Potter
    Guest

    Default Help with Date Problem

    Hi
    Is there a way to make an operator key in the current
    year in a date field. I've looked in Validation but c'ant
    see anything
    Any help appreciated
    Barry

  2. #2
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,310

    Default RE: Help with Date Problem


    Barry,

    If most data entry involves current transactions, it's easy to insert the current date as the default expression for your date field. This is done through field rules for the table.

    It's also possible to 'validate' the entry as the cursor leaves the field, so that a message could be popped up to alert the user that they failed to enter a valid year. This would be done by attaching a script to the OnDepart event for the field on your form.

    -- tom

  3. #3
    Barry Potter
    Guest

    Default RE: Help with Date Problem

    Tom
    It's almost never the current date but I will give your other suggestion a go
    Thanks
    Barry

Similar Threads

  1. Date Problem
    By B Philip Gerber in forum Alpha Five Version 5
    Replies: 5
    Last Post: 04-15-2004, 01:46 PM
  2. New Date Problem
    By Nip Lewis in forum Alpha Five Version 4
    Replies: 5
    Last Post: 11-19-2002, 08:52 AM
  3. Date problem, Please help
    By jay kirschner in forum Alpha Four Version 6 and Prior
    Replies: 10
    Last Post: 05-10-2002, 03:06 PM
  4. Date problem, please help
    By jay kirschner in forum Alpha Four Versions 7 and 8
    Replies: 1
    Last Post: 05-09-2002, 01:42 PM
  5. Date Problem
    By Phil Rolf in forum Alpha Five Version 4
    Replies: 1
    Last Post: 04-04-2001, 01:38 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •