Professional Web Applications Themes

Autofill current date in field on form - Microsoft Access

Need a field to autofill the current date on a form. The user will be filling in one field with a control number and the date field will be the current date. Cant't get it to autofill with the current date. continued...

  1. #1

    Default Autofill current date in field on form

    Need a field to autofill the current date on a form. The
    user will be filling in one field with a control number
    and the date field will be the current date. Cant't get
    it to autofill with the current date.
    LLR Guest

  2. #2

    Default RE: Autofill current date in field on form

    Set the default value to date()

    Ex: =(Date)
    - - Dean
    >-----Original Message-----
    >Need a field to autofill the current date on a form.
    The
    >user will be filling in one field with a control number
    >and the date field will be the current date. Cant't get
    >it to autofill with the current date.
    >.
    >
    Dean Guest

  3. #3

    Default Re: Autofill current date in field on form

    : Need a field to autofill the current date on a form. The
    : user will be filling in one field with a control number
    : and the date field will be the current date. Cant't get
    : it to autofill with the current date.

    I am assuming that this form is data entry only, and the
    form is not being used to edit existing records. I am using
    the field name of Control_Number for what the user enters &
    Date_Entered for the date, format as short date. I would
    use something similiar to this:

    Private Sub Control_Number_Exit(Cancel As Integer)
    Date_Entered = Format(Now, "mm/dd/yyyy")
    End Sub


    Mike Mueller Guest

Similar Threads

  1. Get current date/time? Use them in hidden field?
    By EvolvedDSM in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: May 10th, 07:10 AM
  2. Autofill date field
    By Dasman@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 1
    Last Post: December 1st, 09:10 PM
  3. adding current date into Access using DW form
    By Thinking Man in forum Macromedia Dynamic HTML
    Replies: 2
    Last Post: January 29th, 06:09 PM
  4. Date calculations from FORM field
    By Dan K. in forum Coldfusion - Advanced Techniques
    Replies: 1
    Last Post: July 27th, 01:33 PM
  5. date & time in form field
    By dthatsme in forum Coldfusion - Getting Started
    Replies: 4
    Last Post: March 11th, 06:18 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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139