N
Niceaction
I have a form called Frm_Valuation which initially has a text box called
Txt_Ac_Num and a button called Cmd_tgt_valuation.
What I want to happen, is when a user puts a number in the text box and
presses the command button, a record is added to a linked table called Usage.
In here I have a field called Loan_ref which I can pick up from the text
box, and a field called col_tar_time which I would like to populate with the
time the button was pressed.
Once the user presses the buton - depending on some validation checks - a
further button appears called Cmd_min_valuation. I would like to insert the
time the user presses this button into a field called col_min_time.
If the user was to go back to the text box and put in a new number, I would
want a new record to be added into the table Usage.
Does anyone have any idea how to do this in vba? I am using Access 2002.
Hopefully I have explained this enough for you to understand.
Thanks
Jamie
Txt_Ac_Num and a button called Cmd_tgt_valuation.
What I want to happen, is when a user puts a number in the text box and
presses the command button, a record is added to a linked table called Usage.
In here I have a field called Loan_ref which I can pick up from the text
box, and a field called col_tar_time which I would like to populate with the
time the button was pressed.
Once the user presses the buton - depending on some validation checks - a
further button appears called Cmd_min_valuation. I would like to insert the
time the user presses this button into a field called col_min_time.
If the user was to go back to the text box and put in a new number, I would
want a new record to be added into the table Usage.
Does anyone have any idea how to do this in vba? I am using Access 2002.
Hopefully I have explained this enough for you to understand.
Thanks
Jamie