form usage time

[barisbasar]

Hi All,

I have a problem about my form. My aim is to get total time spent on, before saving the record to the database on a form. I used the time function when the form loads and save it to the field "dinleme_basla". I want the duration time on the form until the user clicks "save record" button. And save that record to the field called "dinleme_bitis".

Can anyone help me?

[czarbjones]

Try this to display the time spent (note you'll need to change the format of the fields to short time):

Private Sub Form_Load()
[dinleme_basla].SetFocus
[dinleme_basla].Text = Now()
End Sub

Private Sub SaveRecord_Click()
TimeSpent = Now() - [dinleme_basla]
DoCmd.Close
End Sub

Cheers,
Cz

[barisbasar]

Try this to display the time spent (note you'll need to change the format of the fields to short time):

Private Sub Form_Load()
[dinleme_basla].SetFocus
[dinleme_basla].Text = Now()
End Sub

Private Sub SaveRecord_Click()
TimeSpent = Now() - [dinleme_basla]
DoCmd.Close
End Sub

Cheers,
Cz

it didn't worked
i must use long time as well

[MMcCarthy]

Try this ...

 
Private Sub Form_Current() 
   Me.[dinleme_basla] = Now()
End Sub
 

 
Private Sub SaveRecord_Click()
   TimeSpent = Format(Now() - [dinleme_basla],"Long Time")
   DoCmd.Close
End Sub
 

[PEB]

Try this ...

 
Private Sub Form_Current() 
   Me.[dinleme_basla] = Now()
End Sub
 

 
Private Sub SaveRecord_Click()
   TimeSpent = Format(Now() - [dinleme_basla],"Long Time")
   DoCmd.Close
End Sub
 

Mary he double posted!

He has 2 threads running simultannelly!

How can explain that double posting isn't good practice!

[MMcCarthy]

Mary he double posted!

He has 2 threads running simultannelly!

How can explain that double posting isn't good practice!

barisbasar,

Please note that you have posted your question twice. This will confuse and may even annoy the experts. It also makes it difficult for others searching for the answer to their question in your posts.

Please do not do this. If your post doesn't get answered, which doesn't happen very often, then just post a reply to move it up the list and it will be attended to.

Mary

[NeoPa]

The other thread is (users usage time on form).
FYI the reasons why it is requested that you do not double post are in (Please do Not Double Post). Although we appreciate that not everyone gets to see all threads, so no censure is implied here.
I will lock this thread now. Further correspondence can be carried out via the other thread.