Linking date field to text field entry

Ask a Question related to Microsoft Access, Design and Development.

  1. #1

    Default Linking date field to text field entry

    Is there a way to setup a date field that will
    automatically enter the date when any information is
    entered into a field next to it?

    Trey Guest

  2. Similar Questions and Discussions

    1. Comparing current field data with last entry for field
      Hi. I have a form that is inserting sales data on a daily basis. I have a field named "RoundTOTAL" which is the total sales for the day rounded to...
    2. Linking Text Field
      Have you found any success in linking text fields? I have received some information in regards to using javascript but I am hung up due to my...
    3. Date text Field
      I have an asp form that is submitted to sql server 2000. There are three date fields. How can I allow the user to enter the date without any...
    4. Converting a text field to a date field - FM6
      I need to convert a Text field containing both auto and manually entered dates over to a Date field. The records that were autoentered move over...
    5. date in text field
      How can I include a date that is formatted in the following structure 9-July-03, and include it in a form text field? The form input code is:...
  3. #2

    Default Re: Linking date field to text field entry

    Just as an example....
    If you have field A and field B, A being the date field and named txtA,
    field B is named txtB. Use the following code added to the AfterUpdate
    event for B:

    Private Sub txtB()
    Me.txtA = Date
    End Sub

    Once you have added details to field B and pressed enter or clicked on
    another field, field A will display and record the current date.

    HTH
    Darren



    "Trey" <tgill@issch.state.in.us> wrote in message
    news:030501c34bcc$992d72d0$a301280a@phx.gbl...
    > Is there a way to setup a date field that will
    > automatically enter the date when any information is
    > entered into a field next to it?
    >

    Darren Guest

Posting Permissions

  • You may not post new threads
  • You may 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