Results 1 to 4 of 4
  1. #1
    Wlbyfred is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    18

    Date on a form

    I am new at access, I have been able to have a date and time on my form header and even in my form, but the date in my form is always todays date and not the date the form was created....any ideas where to look

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,628
    Why is the creation date of form important? Do you really mean the creation date of a record? Did you save the 'creation' date in a field in table?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Wlbyfred is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2012
    Posts
    18
    Yes
    Wrong term here...the creation date of the record and there is a field in the table

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,628
    You have textbox ControlSource set to the field? What is the field name? Date is a reserved word and should not use reserved words as names.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Date Field in Form
    By Kirsti in forum Forms
    Replies: 2
    Last Post: 03-18-2012, 09:57 PM
  2. Date validation on form
    By accessnewbie in forum Access
    Replies: 6
    Last Post: 01-18-2011, 11:03 AM
  3. Due Date Form question
    By AcmeGearSteve in forum Access
    Replies: 10
    Last Post: 10-29-2010, 12:30 PM
  4. Replies: 1
    Last Post: 07-07-2010, 04:22 PM
  5. set date field on form to date variable
    By laavista in forum Access
    Replies: 3
    Last Post: 06-28-2010, 03:03 AM

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