Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2007
    Posts
    6

    Command button for time & date


    I am looking to add START DATE, COMPLETION DATE, START TIME, & FINISH TIME buttons to an existing form, so that when you press the START DATE button it would insert the current date into the field; when you press the START TIME-the current time is inserted and so on. Is this possible? :?

  2. #2
    jya is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Sep 2007
    Location
    Chicagoland
    Posts
    109
    Yes

    On your start date button's onclick event,

    Me!startdatetextfieldname = Date()

    On your start time button's onclick event,

    Me!starttimetextfieldname = Time()

  3. #3
    Join Date
    Dec 2007
    Posts
    6
    Quote Originally Posted by jya
    Yes

    On your start date button's onclick event,

    Me!startdatetextfieldname = Date()

    On your start time button's onclick event,

    Me!starttimetextfieldname = Time()

    I tried this and it doesn't work; a couple others suggested the same thing. Is there any other way to do this?

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

Similar Threads

  1. Duplicate command button
    By brettg in forum Database Design
    Replies: 1
    Last Post: 08-04-2008, 04:16 AM
  2. Command button code
    By lfolger in forum Forms
    Replies: 3
    Last Post: 03-25-2008, 04:26 PM
  3. Access Date/Time....I need a "generic" date.
    By beastmaster in forum Access
    Replies: 2
    Last Post: 12-29-2005, 12:55 PM
  4. command button to filter a subform issue -
    By countdrako in forum Forms
    Replies: 1
    Last Post: 12-09-2005, 11:58 PM
  5. Open a linked subform with a command button
    By flablueeyedblond in forum Forms
    Replies: 0
    Last Post: 11-18-2005, 01:18 PM

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