473,320 Members | 1,848 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

users usage time on form

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
15 1423
PEB
1,418 Expert 1GB
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
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
1,418 Expert 1GB
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
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
1,418 Expert 1GB
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
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
1,418 Expert 1GB
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
32,556 Expert Mod 16PB
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
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
1,418 Expert 1GB
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
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
1,418 Expert 1GB
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
32,556 Expert Mod 16PB
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
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
32,556 Expert Mod 16PB
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

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

Similar topics

1
by: Philip | last post by:
Hey All, I've got a Conceptual delema that hopefully someone will have some insight on. I made a GUI for 1000 fields which are stored in an array of strings to programatically retrive them and...
2
by: tomvr | last post by:
Hello I have noticed some 'weird' memory usage in a vb.net windows app The situation is as follows I have an app (heavy on images) with 2 forms (actually there are more forms and on starting...
2
by: Jarvis | last post by:
I've made a testing program to test the memory usage of some Data Forms. I create a MDI parent form with one single MDI child form, which is a Data Form generated by .NET Data Form Wizard. To...
2
by: JosR | last post by:
I have a memory problem when running a VB.Net application. The application uses a from frmMain from which another form can be opened: Private Sub OpenTheNewForm() dim frm as New frmSecondform...
3
by: Ian Taite | last post by:
Hello, I'm exploring why one of my C# .NET apps has "high" memory usage, and whether I can reduce the memory usage. I have an app that wakes up and processes text files into a database...
8
by: Adrian | last post by:
Hi I have a JS program that runs localy (under IE6 only) on a PC but it has a memory leak (probably the known MS one!) What applications are there that I could use to look at the memory usage of...
6
by: =?Utf-8?B?QWxsZW4=?= | last post by:
When minimizing Visual Basic application, working memory is greatly reduced from about 20 MB to only about 2 MB. However I want the application to start as minimized, and most of the time it will...
3
by: chrispy102 | last post by:
Hi all, I have an MDI app developed using vis studio 2005. The problem I have is that evey time I close a Child form and open another, the CPU PF Usage increments slighty. This happens every time...
2
by: rick | last post by:
Hi friends What is the best way to keep track of number of users logged into database everyday. Where does db2 store user connection information ? does it keep a log of user connections? ...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.