Results 1 to 3 of 3
  1. #1
    EDEd is offline Novice
    Windows XP Access 2003
    Join Date
    Oct 2010
    Posts
    9

    Adding todays date

    Folks,


    I made up a table and a sub table for the current inventory amount. In the inventory table I have two field names, "Inventory" and Inventory Date" Within a form I type in the inventory number. Is there a way to have the current date automatically inserted in to the "Inventory Date" field in the sub table?
    Thank you in advance.
    Ed

  2. #2
    kimmer is offline Competent Performer
    Windows 7 Access 2010 (version 14.0)
    Join Date
    May 2010
    Posts
    100
    set the default value to Date()

  3. #3
    EDEd is offline Novice
    Windows XP Access 2003
    Join Date
    Oct 2010
    Posts
    9
    Heck, that was easy. Thank you.

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

Similar Threads

  1. Replies: 1
    Last Post: 07-07-2010, 04:22 PM
  2. Replies: 10
    Last Post: 04-21-2010, 01:16 PM
  3. Adding 'Last Edited' Date
    By vCallNSPF in forum Forms
    Replies: 2
    Last Post: 12-16-2009, 04:36 PM
  4. Adding a Manual Date
    By JimmyT in forum Database Design
    Replies: 1
    Last Post: 04-21-2009, 06:12 AM
  5. Replies: 1
    Last Post: 12-09-2005, 10:29 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