Search results

Sir, in the table field the durationdays is a calculated type and it has a expression builder of this.. IIf(IsNull([evlrecved]),[ddat]-[evldteisued],[evlrecved]-[evldteisued]) the "daat" is the current date field. If I will remove the ddat-current date the code for durationdys will become...

Sir, There still have a problem in database... after I opened today.. in the form, the textcurrent date is today date.. but the table & query which the txtduration days is connected is not updated. still in the record is yesterday date.. I want also in the record in query the date should become...

thank you it working now... thank you so much.. & more power!

ahh.. you mean I can make a calcuation direct from the form? or in the form properties of txtcurrent date.. I can make the default value as =Date()

and also the records from the field is connected to my reports of my database... therefore its very important to me that the field of current date should become a system current date everytime I open my database... please help me coz I need it to my work as HR Secretary... I make a database for...

ahh.. but I make a expression code in the table in the field of duration days that connected to the current date. If I don't make the the field of a txtcurrent date, a current date, the calculation of duration days will become error..

yes.! exactly! I make a database from table, query up to Forms. I want the the fields from table to become a system current date everytime I Open my database.. the field in the table are connected in the forms via query. all field in the tables, I make a text field in my forms.. this is the...

yes.! exactly! I make a database from table, query up to Forms. I want the the fields from table to become a system current date everytime I Open my database.. the field in the table are connected in the forms via query. all field in the tables, I make a text field in my forms.. this is the...

Hi! I have a problem in my Database system. The title of my Database is Employee Evaluation. This is my problem.. I already make the default value the txtbox a current system date. but for the next day.. the txtbox for all record should become a current system date. but only the for the new...