How To Create A Count Timer

[jothis]

Hi Friends

I Have A Program That Include Login Page And I Want Add A Login Count That Means If A user Logined i have A field In My Database Named count And Here I want To Add Count eg::if aru is logined first time iwant to add count as 0000000001,Then He logined Again Then The Next Count is 0000000002 Next is 0000000003

Any One Can Help Me?

Jothis
:sign0085:

 

[klaus]

Just after aru has loged in, you must read his counter value in the database, add 1 and write the new value back to the database.

This could be done in the LoginCheck routine.

Best regards.

 

[jothis]

But How is possible Like 0000000001

But How is possible Like 0000000001,0000000002
0000000010 and 0000000100

Is It Possible
Help me
jothis
:sign0085:

 

[klaus]

After reading the value from the database, add 1 or any other number to the value and write it back with : Format(Value,"D10")

Attached a small demo program.

Best regards.

 

[jothis]

But I want to add a string in fornt of it

thank you for helping me klaus

But I Want To Add A String in front of it LIKE LOGIN0000000001 Is It Possible?

Please Help me
I attached My code here
jothis
:sign0085:

 

[klaus]

Yes, it is possible.
From the database you get LOGIN0000000001 in the variable LoginVal
Then
LoginCounter=SubString(LoginVal,5,StrLength(LoginVal)-5) ' removes the 5 first characters to get the count number
LoginCounter=LoginCounter+1 ' adds 1
LoginVal="LOGIN"&Format(LoginCounter,"D10") ' modifies the counter text



Attached one solution.

Best regards.

 

[jothis]

Thankyou klaus

Thankyou for helping me klaus