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?
15 1424 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!
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 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?
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
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!
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 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?
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.
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 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!!!!!!
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?
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? ;)
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.
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
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.
Sign in to post your reply or Sign up for a free account.
Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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?
...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |