• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need help in creating Login- Logout time tracking macro

Status
Not open for further replies.
1st test) Same same - three times wrong and ...
Screen Shot 2016-01-26 at 19.31.33.png
? ActiveWorkbook.Close SaveChanges:=FALSE ? works with me better ?
2nd test) I can still go WithOut Login to open file, not ask Login ... just in!
after that everything is possible to do ...
>> This Do Not Work As You Think (or Want) <<
 
@vletm: As you said,

1. Scroll the 1st left row as top as possible: In the excel - Database sheet, i scrolled 1st left row to H2 Row and clicked M1 (Clean) the same issue.
Also i tried to scroll the 1st left row as top as possible ie., to the row H1 still the same issue.

Since the 1st left row as top as possible will be H1 or H2 and it doesnt works.

Also i Unhide the columns and tried by scrolling 1st left row A1 or A2 and it doesnt works.
 
@vletm, Still the same issue, it would be better if you mention the Row/column number as Choose H1 and then click clean (M1)..., something like that..,
 
This is the One time activity., so i need to remove those tested data at the beginning.., since we use to use new sheet each month. Even i dont need to delete each time. Just I need a sheet without saved Data in database sheet.
 
@Aswinraj
Screen Shot 2016-01-27 at 11.12.54.png
Did You tried to read my instruction?
ReRead #53:
Activate any cell from row 100! You wanted row number!
Did You scroll Excel-sheet window as I told?
Scroll window as activated cell is still possible to see

1) Open that file -> goto 'Datasheet'
2) Scroll view as You have same kind of view as above.
There is Cell[i23]-active.
3) activate Cell[i24], one cell below.
4) Scroll view as Cell[i23] cannot see any more, it hides above.
5) Click 'clear'-text
ALL DATA ABOVE CELL[i23] WILL CLEAR ( rows from 2 to 22 )
If You cannot do this, please, ask any of Your team to do this.
 
@vletm, After when i clear the data from database and when i again Login - the time is saved in Database Sheet and again when i Logout - the time is not saved in Database sheet.
Note: Dont say that you havent Logout properly, and i tested several times even when i press Logout it was not saving the time in Database sheet and Logout Button is still appearing.

Attached the same file for your reference.
Coding Password - Iwillnottellyou
Sheet Protection - Aswin-02
 

Attachments

  • AMS Sheet (2).xlsm
    72.1 KB · Views: 134
@Aswinraj - coding password don't match
but, change next code's the last line ( 3 to 2 )
Code:
Sub Press_LOGOUT()
    Sheets("Home").Shapes("Btn_LOG OUT").Visible = False
    y_max = Sheets("Database").Cells(Rows.Count, 1).End(xlUp).Row
    chk_name = Sheets("Home").Range("K8")
    For y = 2 To y_max
 
Hi ,

Its good site with all detailed explanation, i have same kind of requirement.

1 . the home screen should be same.
2. i should be able to add & delete users name and emp id.
3. need data base with date, employee name login time and logout time next total average working hours of the employee

please can anyone help me with this requirment

Thanks in advance.
 
if 1) is Okay
2) should also be Okay
3) What do You mean with term 'total average working hours of the employee'?
if average then it should know give clear idea, how many parts/days would like to get average? and how would like to see those averages?
 
Thanks for the quick reply.
about my third point, data base should look something like below ,its should calculate daily login hours of the employee.
upload_2017-1-25_16-18-23.png

and to add & delete users admin only should have access
i don't want other sheets like previously you have created with break,category.

1)simple i need home screen as usual
2) able to add user id and password
3) data base which gives daily report of login hours as mentioned above and one admin login to add users that sheet should not have access to other users.

please let me know if you need any further clarification.

request you to upload the excel.


Thanks in advance.
 
one more clarification user may login and logout multiple times in a day , so u can mention the total average working hours in the same data base sheet like below.

upload_2017-1-25_16-36-14.png
 
... then You would need something like this file.
Just need to 'click' own name and
it tracks 'are You IN or OUT'...
There can get many kind of list too...
 

Attachments

  • TimeCtrl_2.xlsb
    71.2 KB · Views: 90
What kind of restrictions?
Both file are Excel-file ... ?
Do You really need/want to write every time 'login names' and 'passwords'?
Do You would like to track working times or what?
 
Hi,

As i am a spoc i need to maintain login hours of my team , on Jan 12 ,2016 with lines you have replied @Aswinraj ### - done! in the same file you can make changes. in that i need only home sheet, sheet2 with only F,G columns where i can add users name and there id's and data base sheet for record purpose. sheet 2 have restrictions as admin only(read, write,edit) users should not have access to it . user should have access to home screen and data base screen (read) access.

i am going to save this file in server so everyone will access this file once they come to office.

Thanks
 
SPOC ... https://en.wikipedia.org/wiki/SPOC
...and cannot answer questions?
1) Why cannot use same file as 'Aswinraj'? or just double login/out?
2) '... can make changes' - are You really ready to test..test..test?
This is not 'just delete something'!
This won't take just few minutes to do 'changes'.
3) Are You sure that I have the latest version of that file? I'm not!
4) 'server' ... are You sure that this file has made for 'shared'?
I need clear answers what would You like to get?
 
spoc - i am the single point of contact in my team

1 . i tried to use the same file but i am not able to add users.when i enter user id and names of multiple users and tried to check after column F6 I getting wrong names displayed in the home sheet.
2.i am ready to do testing.
3.i am not sure if u have the latest version, if it's ok with you, you can use same file downloading from this site.
4.we have our own server for project purpose, so we can use it saving in server.

Thanks...
 
1) No answers to my questions!
But You noticed that there are 'rules' how and what should do.
2) Good if You're ready for testing ... but it just needs time!
3) If no latest version then there are still 'challenges' which have to change before could modify ... maybe You have ever tried to do this kind of case?
4) Please try to read somewhere about 'shared files'.
'Shared file' have to make 'correct way from the beginning' and
I know that file has not made for that kind of use.
Only one user can use it in same time!
No matter what kind of server ... You have.
>> What someone would like to get?
>> If 'only' those Your named sheets ... what would do after login?
>> Why need to make login/out if 'just' want to track hours?
>> I need to know clear what would I try to do before use hours
... and after that I just noticed ... dreams.
 
Start TimeEnd TimeTime TakenComments if any
upload_2017-3-23_12-12-3.png
Login
Break 1
Break 2
Break 3
Login HrsReset
Production Hrs
Break

HI please help to create a login tracker, Above is the xample, I need the Emp ID on top, the moment you click on login and email to be sent to me, and the login timer should start, same goes for break, after you click on login, the button should turn to logout, below it should give me the login login hours, Production hours will be total login - Break, when I click reset it should give me the data in the next sheet
 
@Sabby Johny
Have You tried to 'Search' from 'Chandoo'?
There are few 'almost' ready for You.
If You cannot find, then ask again with really clear ideas.
 
Status
Not open for further replies.
Back
Top