David- Set the On Click property to [Event Procedure] and then click the Build button (...) next to the property. Write the one line of code inside that procedure.
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ > -----Original Message----- > From: [email protected] > [mailto:[EMAIL PROTECTED] On Behalf Of David Rank > Sent: Sunday, July 24, 2005 10:29 AM > To: [email protected] > Subject: RE: [ms_access] Re: On Click Event Question > > > Hi Robin - > > > > So far I am receiving the error message "Can't 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 > > > > I'll 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+tra > ining&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+dat > abase&w1=Micro > soft+access+database&w2=Free+microsoft+access+database&w3=Micr osoft+access&w > 4=Microsoft+access+database+design&w5=Microsoft+access+databas > e+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=Micro > soft+access+da > tabase&w2=Free+microsoft+access+database&w3=Microsoft+access&w > 4=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=Mi crosoft+access > &w4=Microsoft+access+database+design&w5=Microsoft+access+datab > ase+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+dat > abase+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+ac cess+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 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/
