about daily attendance acceptance

[yashumrhsn]

can anyone help me to get userid and password from access database..then it compares the userid and password and opens a new from that shows the details from the database for that user..

[jrtox]

can anyone help me to get userid and password from access database..then it compares the userid and password and opens a new from that shows the details from the database for that user..

Go read and understand to this link.
http://www.thescripts. com/forum/thread716387.ht ml

Regards
Ervin

[yashumrhsn]

Go read and understand to this link.

http://www.thescripts.com/forum/thread716387.html

Regards
Ervin

thanks a lot..from that link i got a code and successfully getting..and i have another question..after login with a correct username and password,there is a command in a new from,when user click that command it should take the attendence of that user..my frontend is vb6.0 and backend is access..

please help me,its very urgent,am doing a project for that..am waiting for your reply..

[debasisdas]

What is the logic for taking attendance ?

if u want to mark wheather the user has signed in that day or not then ,after success ful login, just insert a new entry for the database attendance table with date and login time.

[yashumrhsn]

What is the logic for taking attendance ?

if u want to mark wheather the user has signed in that day or not then ,after success ful login, just insert a new entry for the database attendance table with date and login time.

i had insert attendance table in that database with date and login time..after successful login,user should not take last days attendance only from today they can make attendance..

[yashumrhsn]

about daily attendance acceptance

hi..can anyone help me about attendance acceptance,when user login with correct username and password,in the new from user should not take last days attendance only from today they can make attendance..the re is a command button in that new from,when user click that command it should take attendance,in my database there is a attendance table with data and login time..
my frontend is vb6.0 and backend is ms access with ADODC connection..

plz help me....

[debasisdas]

Take attendance automatically after user login ,take system date and time for attendance. Do prompt the user for date.

[debasisdas]

Kindly do not post duplicate threads

Both the threads are merged for better management of the forum..

[yashumrhsn]

Take attendance automatically after user login ,take system date and time for attendance. Do prompt the user for date.

after user login,there is a command button to take an attendance,its an optional,
user can also ignore this..i want code for this..and how to do prompt the user for date..

[yashumrhsn]

Kindly do not post duplicate threads

Both the threads are merged for better management of the forum..

in my database there is a field named as attendance in the table that shows total attendance of each user..when user login successfully,th at field get automatically incremented by 1..i want query for this..please reply...

[yashumrhsn]

can anyone help me for attendance tracker..in my form there is a command and in database there is a attendance field that shows total attendance of each user, when user click that command field get automatically increment by 1 of that user..i want code for this..please help me..thanks in advance..

[jrtox]

can anyone help me for attendance tracker..in my form there is a command and in database there is a attendance field that shows total attendance of each user, when user click that command field get automatically increment by 1 of that user..i want code for this..please help me..thanks in advance..

Everytime the user Succesfully login then you must increment attendance field.
Declare a global variable that holds User Identification,

Global USERID as

Example Logic

If LogSucceful = true then

USERID = Recorset.Fields ("UserID")
Recorset.Fields ("attendance ") = Recorset.Fields ("attendance ") + 1'

End if


Now on your Command Button;
the query is

'SELECT * FROM Tablename WHERE FieldName = " & USERID & "


Regards
Phils Ervin

[yashumrhsn]

Everytime the user Succesfully login then you must increment attendance field.
Declare a global variable that holds User Identification,

Global USERID as

Example Logic

If LogSucceful = true then

USERID = Recorset.Fields ("UserID")
Recorset.Fields ("attendance ") = Recorset.Fields ("attendance ") + 1'

End if


Now on your Command Button;
the query is

'SELECT * FROM Tablename WHERE FieldName = " & USERID & "


Regards
Phils Ervin

thanks for replying me..i tried this,but am not getting..attend ance field will not get increment..ther e is no changes in that field after user successfully login..

[jrtox]

thanks for replying me..i tried this,but am not getting..attend ance field will not get increment..ther e is no changes in that field after user successfully login..

Is the Field "Attendance " is in Other Table? Or the same table, together with the Username, Password, etc?

[yashumrhsn]

Is the Field "Attendance " is in Other Table? Or the same table, together with the Username, Password, etc?

'Attendance' field is in the same table,together with the username,passwo rd..
in my database,table name is t1 and there are 3 fields Userid,Password and Attendance..