+ Reply to Thread
Results 1 to 6 of 6

Thread: Time Entry Form

  1. #1
    Barn Enthusiast sbenj69 is a jewel in the rough sbenj69 is a jewel in the rough sbenj69 is a jewel in the rough sbenj69 is a jewel in the rough sbenj69's Avatar
    Join Date
    Mar 2008
    Location
    The frigid northern plains
    Posts
    432
    Rep Power
    7

    Time Entry Form

    I've been scratching my head, trying to figure out new ways to get through the mundane task of entering in times.

    I've come up with about 5 different methods, 4 of which are included in this database (at the bottom of this thread).

    I always wondered how hard it would be to make an analog clock to enter in times, and now I have my answer. It's not hard, but it is time consuming.

    I also flirted around with spinners, and option groups.

    Of course I had to include the easiest method, input mask.

    In the not so distant future, I will be submitting a time-card program that will allow for time card entries, and also do calculations and reports.

    Anyhow, that's a future project, hopefully you'll enjoy this sample database. I know the coding could have been cleaned up a bunch, but, I simply ran out of time.

    Here's the database sample:
    Attached Files

  2. #2
    Moderator don94403 is a jewel in the rough don94403 is a jewel in the rough don94403 is a jewel in the rough don94403's Avatar
    Join Date
    Mar 2008
    Location
    San Mateo, CA, USA
    Posts
    313
    Blog Entries
    8
    Real Name
    Don Ravey
    Rep Power
    6

    Nice work, benji! A great comparison of methods. While the analog clock is very clever, it takes up a lot of valuable room on a form. My favorite is the spinners.

  3. #3
    Barn Enthusiast sbenj69 is a jewel in the rough sbenj69 is a jewel in the rough sbenj69 is a jewel in the rough sbenj69 is a jewel in the rough sbenj69's Avatar
    Join Date
    Mar 2008
    Location
    The frigid northern plains
    Posts
    432
    Rep Power
    7

    I agree that the analog clock takes a little bit of form space, but you could include that in a separate form and do a popup on got focus, if null, in a time field on a form.
    Last edited by sbenj69; July 14th, 2008 at 03:14 PM.

  4. #4
    Barn Newbie IanA is on a distinguished road IanA's Avatar
    Join Date
    Nov 2008
    Posts
    1
    Rep Power
    4

    Time changer

    Thanks Benji

    I needed an easy way to adjust the time part of a date-time field, so used your spinner in a pop-up form, demo attached.
    Attached Files

  5. #5
    Barn Enthusiast sbenj69 is a jewel in the rough sbenj69 is a jewel in the rough sbenj69 is a jewel in the rough sbenj69 is a jewel in the rough sbenj69's Avatar
    Join Date
    Mar 2008
    Location
    The frigid northern plains
    Posts
    432
    Rep Power
    7

    Glad I could help, and using it as a popup form is definitely nice. I also have used spinners on this module to include ways to change the date and time. Or, on the date section, you may want to look up AOG's calendar example in the database samples thread.

  6. #6
    Barn Newbie zebra is an unknown quantity at this point zebra's Avatar
    Join Date
    May 2009
    Posts
    1
    Rep Power
    3

    Create a seperate time adn date picker relating to one field

    Hi,
    I checked out your examples and they look really good but sadly I can't copy any of them, I'm thinking you might be able to help though...
    I'm making a scheduling system and I need to enter the time and date into one cell field together because that is the way the visual schedular reads it. But to make it user friendly I want users to be able to select the date and time in a pop up box that on saving will drop it into the field in the form and the table behind it.

    I'm really stuck on it any ideas? Thanks

+ Reply to Thread

Similar Threads

  1. Combo Box - Add Entry Not In List
    By AOG123 in forum Access Database Samples
    Replies: 0
    Last Post: June 6th, 2008, 10:35 AM
  2. Maintaining Form Data after forms authentication timeout
    By richyrich in forum .NET Development
    Replies: 13
    Last Post: April 17th, 2008, 02:28 AM
  3. Display Assembly File Date And Time
    By Wolffy in forum .NET Code Samples
    Replies: 0
    Last Post: April 9th, 2008, 12:57 PM
  4. Site Down Time
    By jmurrayhead in forum Announcements
    Replies: 0
    Last Post: March 30th, 2008, 10:42 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

SEO by vBSEO