users usage time on form

[barisbasar]

Hi,

I have a trouble about calculating the time spent between the form open and form close. i need the both times. the time when form open: field name="dinleme_b asla" and the time when user clicks the save button: field name="dinleme_b itis". How can i get those times to the fiels.

Can you help me?

[PEB]

Hi,

I have a trouble about calculating the time spent between the form open and form close. i need the both times. the time when form open: field name="dinleme_b asla" and the time when user clicks the save button: field name="dinleme_b itis". How can i get those times to the fiels.

Can you help me?

To get the start date
write on open form event:

me![dinleme_basla]=Now()

On close form event

Me![dinleme_bitis]=Now()


Hope this helps!

[barisbasar]

To get the start date
write on open form event:

me![dinleme_basla]=Now()

On close form event

Me![dinleme_bitis]=Now()


Hope this helps!

nothing changed
no value in the table field again

[PEB]

Are you sure that those are the names of your form controls...

Note Form controls!

There is big diffeerence btwn Form control and table control?

[barisbasar]

Are you sure that those are the names of your form controls...

Note Form controls!

There is big diffeerence btwn Form control and table control?

no form control, i want that values in my table's fields. my table name is "Dinleme2" and the field names are "dinleme_ba sla" and "dinleme_bi tis"

dinleme_basla is for form open
dinleme_bitis is for when the user click the save record button

[PEB]

But when those fields should be updated?

There should have a form maybe? or at least a query?

I can't imagine that you give full access of your users to touch the tables just like this???

Take care about the security of your database!

[barisbasar]

But when those fields should be updated?

There should have a form maybe? or at least a query?

I can't imagine that you give full access of your users to touch the tables just like this???

Take care about the security of your database!

the dinleme_basla field must be updated when the user opens the form
and the dinleme_bitis field must be updated when the user closes the form

[PEB]

the dinleme_basla field must be updated when the user opens the form
and the dinleme_bitis field must be updated when the user closes the form

So you're sure that in your form you have fields like those that you mention?

And you are sure that they have as control Source property the fields from your table?

[NeoPa]

the dinleme_basla field must be updated when the user opens the form
and the dinleme_bitis field must be updated when the user closes the form

Well this is complicated because so little information has been posted.
Do you have fields on your form bound to these table fields? If so, what are their names?
If not, you should have.
Remember, we can't know anything about your problem unless you include it in the post.

[barisbasar]

So you're sure that in your form you have fields like those that you mention?

And you are sure that they have as control Source property the fields from your table?

yes that's true

[PEB]

yes that's true

A very strange behaviour! All that i can say... Can't help u more if it is really the situation like this...

Pls verify the names carefully

Names of your table,
names of the controls of your form...

Remember different things, not the same.......


Take care about it!!!!!!

[barisbasar]

yes that's true

i have table and it's name is "Dinleme2"
and two fields names are "dinleme_ba sla" and "dinleme_bi tis"
and my form name is also "Dinleme2"

all i want is :

when the user opens the form i need the time value (Longtime) to save in "dinleme_ba sla" field.
and secondly i need the time value when the user clicks the save button i want to save the time value in the field named "dinleme_bitis" .

is it clear?

[PEB]

i have table and it's name is "Dinleme2"
and two fields names are "dinleme_ba sla" and "dinleme_bi tis"
and my form name is also "Dinleme2"

all i want is :

when the user opens the form i need the time value (Longtime) to save in "dinleme_ba sla" field.
and secondly i need the time value when the user clicks the save button i want to save the time value in the field named "dinleme_bitis" .

is it clear?

And u don't mention what are you having in your form...

All controls with their names and control Sources PLS /see it from properties when the control is clicked/

Is it clear? ;)

[NeoPa]

i have table and it's name is "Dinleme2"
and two fields names are "dinleme_ba sla" and "dinleme_bi tis"
and my form name is also "Dinleme2"

all i want is :

when the user opens the form i need the time value (Longtime) to save in "dinleme_ba sla" field.
and secondly i need the time value when the user clicks the save button i want to save the time value in the field named "dinleme_bitis" .

is it clear?

It's not clear because you still have not provided all the information requested.
If we can only make up a picture in our minds of part of the question then we cannot provide a sensible answer.
We would like to provide an answer for you - help us.

[barisbasar]

It's not clear because you still have not provided all the information requested.
If we can only make up a picture in our minds of part of the question then we cannot provide a sensible answer.
We would like to provide an answer for you - help us.

it's so easy. i don't wanna have a control on my form. i wanna save the starttime(the time like "17:27:58 PM " ,when the form is opened) and the endtime(the time like "17:28:52PM " , when the form is closed) of the form.

i want to see on my table the "dinleme_ basla"(field name of the starttime time)
and "dinleme_bi tis" (field name of the endtime time)

the form named "Dinleme2". and its source is "Dinleme2" table