Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Aug 2005
    Posts
    132
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date in the subform (Access 2000)

    In my subform i tried to add a field for a date for the actions with a given client.I owe this excellent form to this Forum.Unfortunately it seems to me that this is not a good idea to have a date in the subform.But somehow i have to tie up the memo with the date when this memo is issued.Which is the right way to apply a date in the subform ?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Date in the subform (Access 2000)

    You have set the Default Value property of the Date field to =Now(), so if you create a new record in the subform, the Date field will be set to the current date and time. Nothing will happen in already existing records. What exactly is your problem?

    Note: it is not a very good idea to name a field Date, since Date is also a built-in function. Better name it IssueDate or something like that.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Date in the subform (Access 2000)

    There is no problem having the date in the subform - it makes complete sense to do so.

    But , as Hans said, you need to use a different name, and , if you just want a date, set the default to =date().

    See attachment
    Regards
    John



  4. #4
    2 Star Lounger
    Join Date
    Aug 2005
    Posts
    132
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date in the subform (Access 2000)

    Thank you to you both Hans and John.it is all clear to me now.Thank you John for the excellent form.I have all my problems solved thanks to you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •