By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,705 Members | 1,777 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,705 IT Pros & Developers. It's quick & easy.

users usage time on form

P: 13
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_basla" and the time when user clicks the save button: field name="dinleme_bitis". How can i get those times to the fiels.

Can you help me?
Nov 27 '06 #1
Share this Question
Share on Google+
15 Replies


PEB
Expert 100+
P: 1,418
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_basla" and the time when user clicks the save button: field name="dinleme_bitis". 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!
Nov 27 '06 #2

P: 13
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
Nov 27 '06 #3

PEB
Expert 100+
P: 1,418
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?
Nov 27 '06 #4

P: 13
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_basla" and "dinleme_bitis"

dinleme_basla is for form open
dinleme_bitis is for when the user click the save record button
Nov 27 '06 #5

PEB
Expert 100+
P: 1,418
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!
Nov 27 '06 #6

P: 13
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
Nov 27 '06 #7

PEB
Expert 100+
P: 1,418
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?
Nov 27 '06 #8

NeoPa
Expert Mod 15k+
P: 31,656
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.
Nov 27 '06 #9

P: 13
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
Nov 27 '06 #10

PEB
Expert 100+
P: 1,418
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!!!!!!
Nov 27 '06 #11

P: 13
yes that's true

i have table and it's name is "Dinleme2"
and two fields names are "dinleme_basla" and "dinleme_bitis"
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_basla" 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?
Nov 27 '06 #12

PEB
Expert 100+
P: 1,418
PEB
i have table and it's name is "Dinleme2"
and two fields names are "dinleme_basla" and "dinleme_bitis"
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_basla" 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? ;)
Nov 27 '06 #13

NeoPa
Expert Mod 15k+
P: 31,656
i have table and it's name is "Dinleme2"
and two fields names are "dinleme_basla" and "dinleme_bitis"
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_basla" 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.
Nov 27 '06 #14

P: 13
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_bitis" (field name of the endtime time)

the form named "Dinleme2". and its source is "Dinleme2" table
Nov 27 '06 #15

NeoPa
Expert Mod 15k+
P: 31,656
I'm glad it's easy for you.
It's not easy for us as we don't get the info we ask for. Without that information we can't answer your question properly.
It has been asked for a number of times now. If you decide you know better and that we don't really need the information, then perhaps you don't need our help.
Nov 27 '06 #16

Post your reply

Sign in to post your reply or Sign up for a free account.