How to link a combobox value to two single events

[Clod_13]

Hi guys,
I explain briefly what is my task,
When the user selects a different name from the list, I would like to link it automatically with the current Date() . I want to do it for every single name of the field so that in case I need, it would be possible to track for how many days that particular name of the list has been clicked.
I explain it better…
My DB aims to monitor some procedures that have 3 status, these are:
On Working,
Expired
Revoked

Given the above I would like to track when every single procedure starts is “on working” and when it ends it. I want to automatically link every name of the combobox with an event that update a field of a table that monitor the beginning and to another that monitor the end (when another status is selected). After that my aim would be to calculate the diff between the two in order to have a number of the days that every single procedure is stuck into a single status.
Do you think is something feasible?
I hope to have explain it well…
If you need I can try to explain it better


Is there a way, in access db or in its VBA, to capture the two columns of data from the combo box so that can monitor them?

 

[Clod_13]

Hey guys this is the most similar stuff I found on the internet, also this guy had troubles in monitoring the date of the combobox change :
http: //stackoverflow.com/questions/17625009/take-the-current-value-of-a-list-combo-box-and-date-field-and-copy-to-another-ta

 

[Clod_13]

nobody can help me?

 

[BlueIshDan]

Please try to explain this a little better.

Are you trying to:

start a timer @ an event.
stop that timer @ an event.
Capture the time inbetween

OR

Change status @ an event
Revert status back @ an event

Kind of confused with what you are asking.

 

[Clod_13]

First of all really thanks for your reply and sorry for my bad explanation, anyway
Yes it is similar to the first case you listed…
I try to explain you better
I have a combobox with 4 status , these are the status of some working procedures and are_
Updated
In process

Revoked
Expired

Basically every procedure that expires has to be updated, but we have to monitor how long does it takes this "in process" status, so I would like to start a timer when I select the status “In process”, and I want to stop it when the status goes to “updated”-
Afterwards I would like to capture the time between the 2 dates in order to calculate statistic of how many days each procedure’s update lasts.
i hope it is clearer now...
thank you a lot
Clod

 

[Clod_13]

basically i need to monitor when a single status begins and when it ends...

 

[BlueIshDan]

What table are you using and what are its fields.

Will these events all be triggered by the changing of the value of the combo box?

 

[Clod_13]

Up to now I have just one table in which i've inserted two new columns that are (date of beginning "in process"--> this is triggered by an automatic event that on click put the date()) and the second column is date of ending "In process" (which unfortunately I don't know how to trigger)

However i know that this system of columns is so weak, first of all because this comand is activadet for every single voice of the combobox, and I wanto to be triggered just when is selected "In process", and also i would like to put all these information into another table but I don't know how to do...

 

[BlueIshDan]

I believe you should have something like this:

[AUTONUMBER] ID, [TEXT] task_name, [TEXT] state, [DATE] start, [DATE] end

Simplify your explanation of your process.
Tell me who is doing what step by step.

 

[Clod_13]

Ok so i will be more detailed:
-ID- personal number of each firms that we work with
-Name- Name of the Firm
-Status of the procedure- (the combobox I told you before with the 4 status: Updated(when a firm is renovated with us)
In process(druing the procedure of renovation, it last a few weeks usually)
Revoked (for some of them we decide to revoke them)
Expired- Every procedure which date has expired and has to be renovated or revoked)
-Owner of the procedure (who is in charge of renovating the procedure)
-Date of Start (i want it to be filled just when the combobox field "In process" is activated)
-Date of end (I want it to be updated when the combobox field "in Process" is changed)


_________________________________________________________
Step by step
I have many firms that are organized in this DB and we offer them a service just for some months, afterwards i have to decide wheter to renovate them again or to revoke them...
Now, the problem is that i need to monitor how long does it take to renovate each procedure of each company, so I need to record the date when each procedure status is being "in process" and when it ends... in order to calculate for each firms how effective is our procedure renovation and how long does it take.

 

[BlueIshDan]

How is your current form setup.
Are you using your navigation buttons to sift through your clients or are you using a more customized form to do this?

 

[Clod_13]

I used a very plan structure... i move from one to each other through a mask and some navigation arrows.
I've added a botton to search the ID , and field for any note or description... but a simple structure...
The combobox fields are linked to a table... nothing more
tell me if I do need to make it more complex, i would change everything if necessary..

 

[Cronk]

I'll join in to offer what I can.

Normally, something is opened, under consideration, and a conclusion (decision) is reached.

During the consideration period, several things can change.

Consider an application for approval which requires OK from several areas. Relevant dates are "ApplicationReceived", "DateApprovalArea1Received", "DateApprovalAreaReceived",....,"DecisionDate".

So when you say your combo has the following options
Updated, In process, Revoked, Expired
I see
Updated => record the date when something was changed
InProcess => current status (not a date)
Revoked, Expired => Date

Have you logically defined your system?

 

[Clod_13]

thanks for your reply Cronk,
Ok i'll enclose you an immage of the mask,
as you can see the purple part is the one of the anagraphic values, there is the ID then the name of the firm and then the money, in the Blue part there is the status of the procedure that consist in
Scad-- which means expired- with these we have to decide wethere to renovate them or not.
A Scad-- which means that the firm has been already renovated
In lavoraz-- which means that it is on going the renovation process, this lasts around 1 months and there are many actors that are involved in this renovation process
revoked--- we decide non to renovate an expired.

the problem is,
I want to automatically insert the date when the combobox field "in lavoraz" is clicked, and i want to automatically insert another date when that field changes into something else such as "a Scadere". in these way having the date of beginning and the date of end I can track and monitor how long does it take for us to complete the all process of renovation...

 

[Clod_13]

I cant isnert any immage.. don't know why