Question: MS Access Database help!!!!!!!!!? I am designing one database in MS access with VBA form for input. There is one field in input form where i need to fill the time when customer request comes. I need to integrate this input with my system time so that automatically it will take that time... HOw to do that??? PLzz..... guide me guys.

Answer: the function to call system time in VB is \ntime()\nit will show you the exact time in 24Hr format. to get hour, minute, second separately use\n\nhour(time())\nminute(time())\nsecond(time()) \n\nto put the value in text box just follow the syntax\n<textboxname>.text = time() \nor whatever you wanna use..\nthen just use the value the time u r updating the database like any other variable value..\n best of luck...
This question from the Yahoo Q&A forum is categorized in the topic: Family & Relationships