report with log in time and log out time

suri

hi superiors

i want to print the report with login time and log out time of the user
i have created table with three fields
sno=code
logintime=time
log out time=time

i have created a new form with this fields and i have taken a one command button
while entering values into the form ,after clicking the command button it must have to effect into the table
i have written the code in command button onpush()
it was not inserting any values into the table

i have tried in on activate of the command button...but it was not entering any values into the form
i have tried the code in ,but it was not entering any values...
Form - OnActivateForm()

can any one suggest me where to write the code
thank you

mohana_cse06

If you set SourceTable property of form to table which you have created.
then whatever you have entered in form will be automatically inserted in table..no need to write any code.

Please try..

suri

thanks for giving reply mohana sir
i have tried like that
when we insert values in the form it was inserting into the table
but when we insert for next time it was overwriting
can you give any suggestion regarding this
i thought we have to write the code..to rectify this problem

mohana_cse06

When you open form next time you will see already existing data also.
why to change the same data?

create new line...

Please check table 51 - User Time Register, how it is designed..

suri

ok mohana thanks for your reply
i am sorry to delay,for giving the reply.
thanks a lot.i got it

mohana_cse06

Welcome