Results 1 to 4 of 4
  1. #1
    dzawicki is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    3

    date entry on input form

    I have a simple 4 line data input form thats used to imput about 100 records a day and is giving me the following problems.

    I want to use the date() function to enter the date (mm dd yy),
    The date appears on the form but dosent enter into the record.



    I have a field on the form for the source of the entry, this could be 10 or 75 entries that I would like to stay the same untill it is changed by overtyping.

    help.

    Dave Zawicki
    i

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You can put the date in your control in the CurrentEvent of your form. As for the carry over, this link should help.

  3. #3
    MAF4Fam6's Avatar
    MAF4Fam6 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Location
    Fruit Heights, Utah USA
    Posts
    140

    Post date entry on input form

    Do you have your date field bound to each record on your form and the underlying table?
    You can set the current date as the default date on your form's date field when adding new records by adding the current date function to the default value in your Table's field.
    Open Table in design view, and add the Date() function to your date field's default value.

    RC,
    Fruit Heights, Utah

  4. #4
    dzawicki is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    3
    Thanks for the help-...will try tomorrow.

    I'm an seasoned (old) fortran,assembly,isam guy and trying to learn Acess from a manual is like trying to understand a credit card agreement

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Date entry
    By kellyd in forum Access
    Replies: 3
    Last Post: 09-24-2009, 02:23 PM
  2. Help!!! user friendly forms/date entry
    By megank in forum Access
    Replies: 3
    Last Post: 03-31-2009, 09:47 AM
  3. Date Stamp On Entry of Record
    By tscholts in forum Forms
    Replies: 3
    Last Post: 04-01-2008, 07:08 PM
  4. Automatic Data Entry on a Specific Date
    By alanbrai in forum Programming
    Replies: 2
    Last Post: 11-14-2007, 05:15 PM
  5. Form Input Problem
    By alvin in forum Forms
    Replies: 2
    Last Post: 01-12-2006, 09:42 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums