Hello Dave, I guess I think people can read my mind. I want to put the date and time in= a record and have not change so when I go back to it I know what I did on= that date. I mostly will use this to know when I sent an invoice. Thanks Marty *********** REPLY SEPARATOR *********** On 4/7/2007 at 4:14 PM David Smart wrote: >> How do I do that? > >?? > >Well, the Default Value for a field is set up in the table design view. > >There are functions for Date (), Time () and Now (). Now () is date and >time. Just use the expression builder in the Default Value area. > >Regards, Dave S > >----- Original Message ----- >From: "Aerial Photography Directory" ><Webmaster@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> >To: <mso@xxxxxxxxxxxxx> >Sent: Saturday, April 07, 2007 11:46 AM >Subject: [mso] Re: Hot Keys MS access 2002 > > >> Hello Dave, WOW that is a fantastic idea. How do I do that? >> >> Marty >> >> *********** REPLY SEPARATOR *********** >> >> On 4/7/2007 at 11:27 AM David Smart wrote: >> >>>I assume you mean CURRENT date and time? Probably in a new record? >>> >>>Why not just default the field to the current date and time when the >>>record >>>is created? >>> >>>Regards, Dave S >>> >>>----- Original Message ----- >>>From: "Aerial Photography Directory" >>><Webmaster@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> >>>To: <mso@xxxxxxxxxxxxx> >>>Sent: Saturday, April 07, 2007 1:43 AM >>>Subject: [mso] Hot Keys MS access 2002 >>> >>> >>>> Is there something I can do to put the both date and time in a record >>>with >>>> few key strokes? >>>> Marty >>>> >>>> >>>> ************************************************************* >>>> You are receiving this mail because you subscribed to= mso@xxxxxxxxxxxxx >>>or >>>> MicrosoftOffice@xxxxxxxxxxxxxxxx >>>> >>>> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx >>>> >>>> To Unsubscribe from this group, visit the group's homepage and use the >>>> dropdown menu at the top. This will allow you to unsubscribe your >>>> email=3D >> >>>> address or change your email settings to digest or vacation (no mail). >>>> //www.freelists.org/webpage/mso >>>> >>>> If you are using Outlook and you see a lot of unnecessary code in your >>>> email messages, read these instructions that explain why and how to= fix >>>> it: >>>> http://personal-computer-tutor.com/abc3/v28/greg28.htm >>>> ************************************************************* >>> >>>************************************************************* >>>You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx >or >>>MicrosoftOffice@xxxxxxxxxxxxxxxx >>> >>>To send mail to the group, simply address it to mso@xxxxxxxxxxxxx >>> >>>To Unsubscribe from this group, visit the group's homepage and use the >>>dropdown menu at the top. This will allow you to unsubscribe your email >>>address or change your email settings to digest or vacation (no mail). >>>//www.freelists.org/webpage/mso >>> >>>If you are using Outlook and you see a lot of unnecessary code in your >>>email messages, read these instructions that explain why and how to= fix=3D >> it: >>>http://personal-computer-tutor.com/abc3/v28/greg28.htm >>>************************************************************* >> >> >> Roger Bondy 405-447-6743 Open 24-7-365 >> Jason Bondy Pictures blog >> http://www.radio51.blogspot.com/ >> >> Roger Bondy Alternative Thinking Philosophy >> http://www.rogerbondy.net/ >> >> >> ************************************************************* >> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx >or >> MicrosoftOffice@xxxxxxxxxxxxxxxx >> >> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx >> >> To Unsubscribe from this group, visit the group's homepage and use the >> dropdown menu at the top. This will allow you to unsubscribe your email= >> address or change your email settings to digest or vacation (no mail). >> //www.freelists.org/webpage/mso >> >> If you are using Outlook and you see a lot of unnecessary code in your >> email messages, read these instructions that explain why and how to fix >> it: >> http://personal-computer-tutor.com/abc3/v28/greg28.htm >> ************************************************************* > >************************************************************* >You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or >MicrosoftOffice@xxxxxxxxxxxxxxxx > >To send mail to the group, simply address it to mso@xxxxxxxxxxxxx > >To Unsubscribe from this group, visit the group's homepage and use the >dropdown menu at the top. This will allow you to unsubscribe your email >address or change your email settings to digest or vacation (no mail). >//www.freelists.org/webpage/mso > >If you are using Outlook and you see a lot of unnecessary code in your >email messages, read these instructions that explain why and how to fix= it: >http://personal-computer-tutor.com/abc3/v28/greg28.htm >************************************************************* Roger Bondy 405-447-6743 Open 24-7-365 Jason Bondy Pictures blog http://www.radio51.blogspot.com/ Roger Bondy Alternative Thinking Philosophy http://www.rogerbondy.net/ ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, visit the group's homepage and use the dropdown menu at the top. This will allow you to unsubscribe your email address or change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso If you are using Outlook and you see a lot of unnecessary code in your email messages, read these instructions that explain why and how to fix it: http://personal-computer-tutor.com/abc3/v28/greg28.htm *************************************************************