+ Reply to Thread
Results 1 to 5 of 5

Trying to search for a name with an in-punch and place an out-punch on the same line

  1. #1
    Registered User
    Join Date
    08-04-2010
    Location
    United States
    MS-Off Ver
    Office 365 for windows
    Posts
    62

    Unhappy Trying to search for a name with an in-punch and place an out-punch on the same line

    Hello. I have a form with a combo box that contains employee names.

    When I click the in and out punch buttons the punches are recorded on different lines and in different columns.

    I would really love to make it so that if a person punches in, clicking the outpunch button looks for their last in punch without an out punch and puts their outpunch on the same line as the in punch. Or some kind of solution that groups them on the same line but helps prevent or prevents someone from missing out punches altogether somehow.

    I would love it if I could somehow put these on the same line when they are recorded. >< Your help is super appreciated D:
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Trying to search for a name with an in-punch and place an out-punch on the same line

    Something like this?
    Attached Files Attached Files
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: Trying to search for a name with an in-punch and place an out-punch on the same line

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Kind regards
    Leo
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-04-2010
    Location
    United States
    MS-Off Ver
    Office 365 for windows
    Posts
    62

    Cool Re: Trying to search for a name with an in-punch and place an out-punch on the same line

    Quote Originally Posted by LeoTaxi View Post
    [CODE]
    Leo
    Thank you very much. I am not sure how the combo box code is intended to work but the code that places out punches next to ins works perfectly and I can mostly understand what it is doing. I added it and tested it and it works great thank you.
    Last edited by lOYvEpi6M87nEoIF0ul8; 03-22-2021 at 12:37 PM.

  5. #5
    Registered User
    Join Date
    08-04-2010
    Location
    United States
    MS-Off Ver
    Office 365 for windows
    Posts
    62

    Re: Trying to search for a name with an in-punch and place an out-punch on the same line

    Quote Originally Posted by dotchiejack View Post
    Something like this?
    Wow thank you so much this is super cool. I've looked at the code and it gives me some ideas about what I might be able to do in the future.

    I thought about it a lot and I would say your system and design is superior in many ways but I also think that design might be problematic for me only because I have some older folks who are not experienced using a computer at all and as simple as it is, I know my peeps and I am positive this might be confusing for them. I'll consult with a few people and see what they think.

    I do appreciate that you took the time to make something like this though. I never thought to do it that way. I actually like it because I think if someone was looking at their own photo, it would be easier to avoid making a mistake when punching in too. Its just all around better and it works properly. Looking at the code, I wasn't able to figure out how to modify it for my needs so I could not add what I needed for now from it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Punch in and Punch out Clock over days
    By Heather1 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-11-2020, 03:37 AM
  2. [SOLVED] Need help with Punch in and Punch out clock system please.
    By Grassman in forum Excel Programming / VBA / Macros
    Replies: 74
    Last Post: 02-27-2020, 02:16 AM
  3. Help with Punch Clock
    By horsefish01 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-24-2018, 08:54 AM
  4. Punch in and punch out with criteria
    By matheanil in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-25-2017, 06:04 AM
  5. [SOLVED] Punch Clock
    By domnicess in forum Excel General
    Replies: 6
    Last Post: 06-10-2014, 11:53 AM
  6. Clock in multiple punch in/punch out times Formula
    By Schnizzle74 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-24-2014, 06:15 PM
  7. Punch In and Out - Employees
    By domnicmifsud in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-01-2013, 10:15 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1