Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Dec 2004
    Thanked 0 Times in 0 Posts

    Current date button (Access 2K)

    I want to create a command button that causes all of my date fields on my continuous form. Actually it would be good to have a command button next to each record that would insert the current date for that record, and another button at the bottom (or top) that would be used to enter the dates for all records. Is this possible?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Current date button (Access 2K)

    You don't really need a command button to enter the current date in a field. Pressing Ctrl+; (Ctrl+semicolon) will do that.

    Setting a date field to the current date is easy if you want to do it for all records in a table, but what if the user has applied a filter to the form? Do you want to update all records in the unfiltered form, or only the filtered records?

Posting Permissions

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