Stupid question time again

sgundrum · 09-28-2005, 08:30 PM

I want to have the current time placed into a text box in a access 2003 when I click on the text box. I know how to set it up to do that, I just need to code and have been unable to figure it out. Any help is appreciated.

Stephen Gundrum

Chevy · 10-01-2005, 04:59 PM

Going from memory ....

In Design Mode, bring up the properties for that object. Under Events (?) set the On Click to '=Now()' (minus the quotes), and set the field format to hh:mm (or hh:mm:ss) ...

I think ... maybe ...

sgundrum · 10-03-2005, 07:44 AM

I already tried that and it kicked me to debug it.

Chevy · 10-04-2005, 05:27 PM

Did you see this?

sgundrum · 10-04-2005, 06:18 PM

Thanks for the link! Looking at it I found that I can use this code: Start_Time = Now(). I had to rename the form field from Start Time to Start_Time in order to get it to work, but it is doing exactly what I want to to do.

Thanks for all the help!

09-28-2005, 08:30 PM	#1 (permalink)
sgundrum Registered User Join Date: Jan 2005 Location: Nampa,ID Posts: 76 OS: XP Pro / Redhat Linux	Stupid question time again I want to have the current time placed into a text box in a access 2003 when I click on the text box. I know how to set it up to do that, I just need to code and have been unable to figure it out. Any help is appreciated. Stephen Gundrum __________________ True professionals establish excellence as their goal and never allow themselves to become complacent about their performance..

10-03-2005, 07:44 AM	#3 (permalink)
sgundrum Registered User Join Date: Jan 2005 Location: Nampa,ID Posts: 76 OS: XP Pro / Redhat Linux	I already tried that and it kicked me to debug it. __________________ True professionals establish excellence as their goal and never allow themselves to become complacent about their performance..

10-04-2005, 06:18 PM	#5 (permalink)
sgundrum Registered User Join Date: Jan 2005 Location: Nampa,ID Posts: 76 OS: XP Pro / Redhat Linux	Thanks for the link! Looking at it I found that I can use this code: Start_Time = Now(). I had to rename the form field from Start Time to Start_Time in order to get it to work, but it is doing exactly what I want to to do. Thanks for all the help! __________________ True professionals establish excellence as their goal and never allow themselves to become complacent about their performance..

10-01-2005, 04:59 PM	#2 (permalink)
Chevy Retired Join Date: Jul 2003 Location: Notlob Posts: 5,452 OS: Vista Ultimate My System	Going from memory .... In Design Mode, bring up the properties for that object. Under Events (?) set the On Click to '=Now()' (minus the quotes), and set the field format to hh:mm (or hh:mm:ss) ... I think ... maybe ...

10-04-2005, 05:27 PM	#4 (permalink)
Chevy Retired Join Date: Jul 2003 Location: Notlob Posts: 5,452 OS: Vista Ultimate My System	Did you see this?