Hi Robin
So far I am receiving the error message Cant find the macro Me In the properties dialogue box I entered Me.txtTime = Now() I assume I must create a Macro 1st. Can you please guide me on that? Thanks again - David Ill be experimenting in the meantime. _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Robin Sent: Sunday, July 24, 2005 11:14 AM To: [email protected] Subject: [ms_access] Re: On Click Event Question Hello David, Well, you just about have it. In the OnClick event for the textbox use some code (I'll call the textbox txtTime) Me.txtTime = Now() That should do it for you. Regards Robin. --- In [email protected], "David Rank" <[EMAIL PROTECTED]> wrote: > Hi - > > > > Can anyone tell me how to create a field on an input form that would enter > current date/time with the click of the mouse? > > > > I am trying to create an easy way for time durations to be tracked. > > > > The system I am setting up uses the General Date format, but it is > cumbersome for the user to key in the date and time repeatedly. Is there a > way the user can click on the field to enter this information? > > > > I am trying to figure out how to construct an event using the NOW function > to accomplish this. > > > > Thanks - David > > > > [Non-text portions of this message have been removed] SPONSORED LINKS Microsoft <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database&w1=Microsoft+ access+database&w2=Free+microsoft+access+database&w3=Microsoft+access&w4=Mic rosoft+access+database+design&w5=Microsoft+access+database+training&w6=Ms+ac cess&c=6&s=182&.sig=hPYPsGYc-Dou8l2vK62wZA> access database Free <http://groups.yahoo.com/gads?t=ms&k=Free+microsoft+access+database&w1=Micro soft+access+database&w2=Free+microsoft+access+database&w3=Microsoft+access&w 4=Microsoft+access+database+design&w5=Microsoft+access+database+training&w6= Ms+access&c=6&s=182&.sig=AVWbL4_C-oc-wJhYxIy1JQ> microsoft access database Microsoft <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access&w1=Microsoft+access+da tabase&w2=Free+microsoft+access+database&w3=Microsoft+access&w4=Microsoft+ac cess+database+design&w5=Microsoft+access+database+training&w6=Ms+access&c=6& s=182&.sig=ZqXOcBXGxkTsD0a2Rz440w> access Microsoft <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database+design&w1=Mic rosoft+access+database&w2=Free+microsoft+access+database&w3=Microsoft+access &w4=Microsoft+access+database+design&w5=Microsoft+access+database+training&w 6=Ms+access&c=6&s=182&.sig=7Z3OPtTFgTGRYyimH8KjRw> access database design Microsoft <http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database+training&w1=M icrosoft+access+database&w2=Free+microsoft+access+database&w3=Microsoft+acce ss&w4=Microsoft+access+database+design&w5=Microsoft+access+database+training &w6=Ms+access&c=6&s=182&.sig=iBJkXpIna9fO0jJIKt08mw> access database training Ms <http://groups.yahoo.com/gads?t=ms&k=Ms+access&w1=Microsoft+access+database&; w2=Free+microsoft+access+database&w3=Microsoft+access&w4=Microsoft+access+da tabase+design&w5=Microsoft+access+database+training&w6=Ms+access&c=6&s=182&. sig=c1Aaw1_EL_gIENnELK0CbQ> access _____ YAHOO! GROUPS LINKS * Visit your group "ms_access <http://groups.yahoo.com/group/ms_access> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> * Your use of Yahoo! Groups is subject to the Yahoo! <http://docs.yahoo.com/info/terms/> Terms of Service. _____ [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
