Marty, The default value in the field will be filled in when you create the = record. The value should remain at that unless you change it manually. = Try it out and see if it works. =20 James -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On Behalf Of Aerial Photography Directory Sent: Saturday, April 07, 2007 8:41 AM To: mso@xxxxxxxxxxxxx Subject: [mso] Re: Hot Keys MS access 2002 :VSMail mx5 Hello Dave, I guess I think people can read my mind. I want to put the date and time = in=3D a record and have not change so when I go back to it I know what I did = on=3D that date. I mostly will use this to know when I sent an invoice.=20 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=20 >time. Just use the expression builder in the Default Value area. > >Regards, Dave S > >----- Original Message -----=20 >From: "Aerial Photography Directory"=20 ><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 -----=20 >>>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=3D 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=20 >>>> email=3D3D >> >>>> 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=3D 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=3D fix=3D3D >> 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=20 >> 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=20 >> dropdown menu at the top. This will allow you to unsubscribe your = email=3D =20 >> 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=20 >> email messages, read these instructions that explain why and how to = fix=20 >> it: >> http://personal-computer-tutor.com/abc3/v28/greg28.htm >> *************************************************************=20 > >************************************************************* >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=20 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 ************************************************************* This message contains information that may be confidential and is = intended only for the use of the=20 person/persons identified and intended as the recipient. If you are not = the intended recipient, any=20 disclosure, copying, distribution or use of this information by anyone = else is strictly prohibited. If you have received this in error, please contact the sender = immediately and delete the message=20 from your computer. ************************************************************* 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 To be able to share files with the group, you must join our Yahoo sister group. This group will not allow for posting of emails, but will allow you to join and share problem files, templates, etc.: http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE SHARING ONLY. 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 *************************************************************