[mso] Re: Hot Keys MS access 2002 :VSMail mx6
- From: "Aerial Photography Directory" <Webmaster@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Tue, 10 Apr 2007 12:54:31 -0500
Hello Jim, I went to form view and did the inset time date and it did not=
got into any of the boxes on my form.
*********** REPLY SEPARATOR ***********
On 4/10/2007 at 9:02 AM James LaBorde wrote:
>Marty,
>
>Instead of using the Date() function, use the Now() function. I believe=
=3D
>that is the date and time. If you want, you can add a button on the =3D
>form for the record that will update the field in question using the =3D
>Now() function when you hit the button.
>
>James
>
>-----Original Message-----
>From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
>Behalf Of Aerial Photography Directory
>Sent: Monday, April 09, 2007 5:04 PM
>To: mso@xxxxxxxxxxxxx
>Subject: [mso] Re: Hot Keys MS access 2002 :VSMail mx6
>
>
>Hello James, Thank you for taking an interest.
>I want to todays date in the record so I know when the last time I =3D
>called=3D3D
> them. I want the date not to change except by me. I know how to put =3D
>date.=3D3D
> I know how to put the time. I want to know how to put them at the =3D
>same=3D3D
> time.
>Marty
>
>*********** REPLY SEPARATOR ***********
>
>On 4/9/2007 at 3:14 PM James LaBorde wrote:
>
>>Marty,
>>
>>Do you want to put a specific date or do you want to put the date now?
>>
>>If you want to put today's date in a group of records, create a query =3D
>=3D3D3D
>>that gets all of the records you want to add the date to, then change =3D
>=3D3D3D
>>the query type to Update and under the date field, enter Date() as the=
=3D
>=3D3D3D
>>Update To. Execute it (Using the !) and it should put today's date in=
=3D
>=3D3D3D
>>all of those records.
>>
>>James
>>
>>-----Original Message-----
>>From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
>>Behalf Of Aerial Photography Directory
>>Sent: Monday, April 09, 2007 2:15 PM
>>To: mso@xxxxxxxxxxxxx
>>Subject: [mso] Re: Hot Keys MS access 2002 :VSMail mx3
>>
>>
>>Hello James, Thank you for your response.
>>
>>I have created thousand of records and that never happened. I guess I =3D
>=3D3D3D
>>have=3D3D3D3D
>> to do something to make it happen.
>>
>>How do I put a date in an old record that stays there until I change =3D
>it?
>>
>>Thanks Marty
>>
>>*********** REPLY SEPARATOR ***********
>>
>>On 4/9/2007 at 8:43 AM James LaBorde wrote:
>>
>>>Marty,
>>>
>>>The default value in the field will be filled in when you create the =3D
>=3D3D3D
>>=3D3D3D3D3D
>>>record. The value should remain at that unless you change it =3D3D3D
>>manually.=3D3D3D3D
>> =3D3D3D3D3D
>>>Try it out and see if it works.
>>>=3D3D3D3D3D20
>>>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 =3D
>=3D3D3D
>>time=3D3D3D3D
>> =3D3D3D3D3D
>>>in=3D3D3D3D3D3D
>>> a record and have not change so when I go back to it I know what I =3D
>=3D3D3D
>>did=3D3D3D3D
>> =3D3D3D3D3D
>>>on=3D3D3D3D3D3D
>>> that date. I mostly will use this to know when I sent an =3D3D3D
>>invoice.=3D3D3D3D3D20
>>>
>>>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 =3D
>=3D3D3D
>>view.
>>>>
>>>>There are functions for Date (), Time () and Now (). Now () is date=
=3D
>=3D3D3D
>>=3D3D3D3D3D
>>>and=3D3D3D3D3D20
>>>>time. Just use the expression builder in the Default Value area.
>>>>
>>>>Regards, Dave S
>>>>
>>>>----- Original Message -----=3D3D3D3D3D20
>>>>From: "Aerial Photography Directory"=3D3D3D3D3D20
>>>><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 =3D
>the
>>>>>>record
>>>>>>is created?
>>>>>>
>>>>>>Regards, Dave S
>>>>>>
>>>>>>----- Original Message -----=3D3D3D3D3D20
>>>>>>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 =3D
>=3D3D3D
>>=3D3D3D3D3D
>>>record
>>>>>>with
>>>>>>> few key strokes?
>>>>>>> Marty
>>>>>>>
>>>>>>>
>>>>>>> *************************************************************
>>>>>>> You are receiving this mail because you subscribed to=3D3D3D3D3D3D
>>> 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 =3D
>=3D3D3D
>>use=3D3D3D3D
>> =3D3D3D3D3D
>>>the
>>>>>>> dropdown menu at the top. This will allow you to =3D
>unsubscribe=3D3D3D3D
>> your=3D3D3D3D3D20
>>>>>>> email=3D3D3D3D3D3D3D
>>>>>
>>>>>>> address or change your email settings to digest or vacation (no =3D
>=3D3D3D
>>=3D3D3D3D3D
>>>mail).
>>>>>>> //www.freelists.org/webpage/mso
>>>>>>>
>>>>>>> If you are using Outlook and you see a lot of unnecessary code =3D
>in=3D3D
> =3D3D3D
>>=3D3D3D3D3D
>>>your
>>>>>>> email messages, read these instructions that explain why and how=
=3D
>=3D3D3D
>>=3D3D3D3D3D
>>>to=3D3D3D3D3D3D
>>> fix
>>>>>>> it:
>>>>>>> http://personal-computer-tutor.com/abc3/v28/greg28.htm
>>>>>>> *************************************************************
>>>>>>
>>>>>>*************************************************************
>>>>>>You are receiving this mail because you subscribed to =3D3D3D3D3D
>>>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=
=3D
>=3D3D3D
>>=3D3D3D3D3D
>>>the
>>>>>>dropdown menu at the top. This will allow you to unsubscribe your=
=3D
>=3D3D3D
>>=3D3D3D3D3D
>>>email
>>>>>>address or change your email settings to digest or vacation (no =3D
>=3D3D3D
>>=3D3D3D3D3D
>>>mail).
>>>>>>//www.freelists.org/webpage/mso
>>>>>>
>>>>>>If you are using Outlook and you see a lot of unnecessary code in =3D
>=3D3D3D
>>=3D3D3D3D3D
>>>your
>>>>>>email messages, read these instructions that explain why and how =3D
>=3D3D3D
>>=3D3D3D3D3D
>>>to=3D3D3D3D3D3D
>>> fix=3D3D3D3D3D3D3D
>>>>> 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 =3D3D3D3D3D
>>>mso@xxxxxxxxxxxxx
>>>>or=3D3D3D3D3D20
>>>>> 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=
=3D
>=3D3D3D
>>=3D3D3D3D3D
>>>the=3D3D3D3D3D20
>>>>> dropdown menu at the top. This will allow you to unsubscribe your=
=3D
>=3D3D3D
>>=3D3D3D3D3D
>>>email=3D3D3D3D3D3D
>>>=3D3D3D3D3D20
>>>>> address or change your email settings to digest or vacation (no =3D
>=3D3D3D
>>=3D3D3D3D3D
>>>mail).
>>>>> //www.freelists.org/webpage/mso
>>>>>
>>>>> If you are using Outlook and you see a lot of unnecessary code in =3D
>=3D3D3D
>>=3D3D3D3D3D
>>>your=3D3D3D3D3D20
>>>>> email messages, read these instructions that explain why and how =3D
>to=3D3D
> =3D3D3D
>>=3D3D3D3D3D
>>>fix=3D3D3D3D3D20
>>>>> it:
>>>>> http://personal-computer-tutor.com/abc3/v28/greg28.htm
>>>>> =3D
>*************************************************************=3D3D3D3D3D20
>>>>
>>>>*************************************************************
>>>>You are receiving this mail because you subscribed to =3D3D3D
>>mso@xxxxxxxxxxxxx=3D3D3D3D
>> =3D3D3D3D3D
>>>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 =3D
>the
>>>>dropdown menu at the top. This will allow you to unsubscribe your =3D
>=3D3D3D
>>=3D3D3D3D3D
>>>email
>>>>address or change your email settings to digest or vacation (no =3D
>mail).
>>>>//www.freelists.org/webpage/mso
>>>>
>>>>If you are using Outlook and you see a lot of unnecessary code in =3D
>your
>>>>email messages, read these instructions that explain why and how to =3D
>=3D3D3D
>>=3D3D3D3D3D
>>>fix=3D3D3D3D3D3D
>>> it:
>>>>http://personal-computer-tutor.com/abc3/v28/greg28.htm
>>>>*************************************************************
>>>
>>>
>>>Roger Bondy 405-447-6743 Open 24-7-365=3D3D3D3D3D20
>>>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 =3D3D3D
>>mso@xxxxxxxxxxxxx=3D3D3D3D
>> =3D3D3D3D3D
>>>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 =3D
>the=3D3D
> =3D3D3D
>>=3D3D3D3D3D
>>>dropdown menu at the top. This will allow you to unsubscribe your =3D
>=3D3D3D
>>email=3D3D3D3D
>> =3D3D3D3D3D
>>>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 =3D
>your=3D3D
> =3D3D3D
>>=3D3D3D3D3D
>>>email messages, read these instructions that explain why and how to =3D
>=3D3D3D
>>fix=3D3D3D3D
>> =3D3D3D3D3D
>>>it:
>>>http://personal-computer-tutor.com/abc3/v28/greg28.htm
>>>*************************************************************
>>>This message contains information that may be confidential and is =3D
>=3D3D3D3D3D
>>>intended only for the use of the=3D3D3D3D3D20
>>>person/persons identified and intended as the recipient. If you are =3D
>=3D3D3D
>>not=3D3D3D3D
>> =3D3D3D3D3D
>>>the intended recipient, any=3D3D3D3D3D20
>>>disclosure, copying, distribution or use of this information by =3D
>anyone=3D3D
> =3D3D3D
>>=3D3D3D3D3D
>>>else is strictly prohibited.
>>>If you have received this in error, please contact the sender =3D
>=3D3D3D3D3D
>>>immediately and delete the message=3D3D3D3D3D20
>>>from your computer.
>>>*************************************************************
>>>You are receiving this mail because you subscribed to =3D
>mso@xxxxxxxxxxxxx=3D3D
> =3D3D3D
>>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 =3D
>=3D3D3D
>>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 =3D
>=3D3D3D
>>sister
>>>group. This group will not allow for posting of emails, but will =3D
>allow
>>>you to join and share problem files, templates, etc.:=3D3D3D20
>>>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 =3D
>=3D3D3D
>>fix=3D3D3D3D
>> it:
>>>http://personal-computer-tutor.com/abc3/v28/greg28.htm
>>>*************************************************************
>>
>>
>>Roger Bondy 405-447-6743 Open 24-7-365=3D3D3D20
>>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 =3D
>mso@xxxxxxxxxxxxx=3D3D
> =3D3D3D
>>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=
=3D
>=3D3D3D
>>dropdown menu at the top. This will allow you to unsubscribe your =3D
>email=3D3D
> =3D3D3D
>>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 =3D
>sister=3D3D
> =3D3D3D
>>group. This group will not allow for posting of emails, but will =3D
>allow=3D3D
> =3D3D3D
>>you to join and share problem files, templates, etc.: =3D3D3D
>>http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for=
=3D
>=3D3D3D
>>FILE SHARING ONLY.
>>
>>If you are using Outlook and you see a lot of unnecessary code in your=
=3D
>=3D3D3D
>>email messages, read these instructions that explain why and how to =3D
>fix=3D3D
> =3D3D3D
>>it:
>>http://personal-computer-tutor.com/abc3/v28/greg28.htm
>>*************************************************************
>>This message contains information that may be confidential and is =3D3D3D
>>intended only for the use of the=3D3D3D20
>>person/persons identified and intended as the recipient. If you are =3D
>not=3D3D
> =3D3D3D
>>the intended recipient, any=3D3D3D20
>>disclosure, copying, distribution or use of this information by anyone=
=3D
>=3D3D3D
>>else is strictly prohibited.
>>If you have received this in error, please contact the sender =3D3D3D
>>immediately and delete the message=3D3D3D20
>>from your computer.
>>*************************************************************
>>You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx=
=3D
>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 =3D
>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 =3D
>sister
>>group. This group will not allow for posting of emails, but will allow
>>you to join and share problem files, templates, etc.:=3D20
>>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 =3D
>fix=3D3D
> it:
>>http://personal-computer-tutor.com/abc3/v28/greg28.htm
>>*************************************************************
>
>
>Roger Bondy 405-447-6743 Open 24-7-365=3D20
>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=
=3D
>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 =3D
>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
>
>To be able to share files with the group, you must join our Yahoo sister=
=3D
>group. This group will not allow for posting of emails, but will allow=
=3D
>you to join and share problem files, templates, etc.: =3D
>http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for =3D
>FILE SHARING ONLY.
>
>If you are using Outlook and you see a lot of unnecessary code in your =3D
>email messages, read these instructions that explain why and how to fix=
=3D
>it:
>http://personal-computer-tutor.com/abc3/v28/greg28.htm
>*************************************************************
>This message contains information that may be confidential and is =3D
>intended only for the use of the=3D20
>person/persons identified and intended as the recipient. If you are not=
=3D
>the intended recipient, any=3D20
>disclosure, copying, distribution or use of this information by anyone =3D
>else is strictly prohibited.
>If you have received this in error, please contact the sender =3D
>immediately and delete the message=3D20
>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
>*************************************************************
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
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
*************************************************************
Other related posts:
