Recent content by Trisha2014

Dear, I have calculated files in a form which is summimg the working hrs of each employées for a particular data. I am able to show the same in the form but want to add this value in the table. Is is possible to add this data from the form to the able????

Dear EternalMyrtle, One small question, Code: Me.YourControlName=Date() is also valide for Access 2000 Because for me the code didn't work in Access 2000

Dear EternalMyrtle, Thanks for your support it helps by setting the défaut values in the table level. Also sorry to mention the post in the queries section by mistake.

Dear pr2-eugin, This is not working to update the value in the date field of the form on click the Ref field. Do I missing any step in the VBA code?

Dear , Can anyone please help me to find out why the code is showing error. Private Sub Ref_Click() Me.Ref.DefaultValue = Date End Sub I want that when I click the Ref field in the form the date field in the form get populated with todays date

Dear, I have a form with a sub form. In the sub form I have a column named date. When user need to add new data in the sub form the date field will autimatically show todays date . I have added in the default value properties of the date field as Date (). But with this I am facing a problem...