Thread: Comments Field
View Single Post
  #7  
Old December 8th, 2006, 01:48 AM posted to microsoft.public.outlook.contacts
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 7,177
Default Comments Field

Look at the code in the form that gets the date/time value. The page I suggested explains how the FormatDateTime function works and even provides a very simple example on how to use it to return a string with a date/time value in a particular format. But since you seem to need another example, you could replace Date with FormatDateTime(Date, vbShortDate).

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Joe" wrote in message ...
Sue, This worked. I published the form and the date stamp button works.
thanks
On the other issue, I visited the site you suggested and I don't know what
to do with the code that is there. Do I insert it in with the code in my
form? Do I replace the code in my form with one of the lines of code? Not
sure what to do.

"Sue Mosher [MVP-Outlook]" wrote:

You need to publish the form. See http://www.outlookcode.com/d/formpub.htm

The FormatDateTime() function governs how the date/time appears. http://msdn2.microsoft.com/en-us/library/8aebkz6s.aspx



"Joe" wrote in message ...
I used this information and it was helpful. When in "design this form" I
complete the work as instructed and "run the form". Everything work great,
the date and time are inserted in the note field. However, when I save the
form and open it, the date stamp does not work. Any ideas? Also, is there a
way to modify the code so only the date shows? (no time)
thanks

"Hufault" wrote:

Thank you, Sue. Impressive Website. I've been looking for something like this.
Just fyi, looked to me like sperrysoftware already did the leg work and designed something I could use. I got that link from site you referred me to below. Thanks so much for your help.

"Sue Mosher [MVP-Outlook]" wrote:

See http://www.outlookcode.com/d/forms/stampdate.htm for a custom form
that's a start toward what you're trying to do.


"Hufault" wrote in message
...
I'd like to press a button that automatically places today's date, my
initials, the word "Notes:" a carriage return and an indent before writing
my comments.

Excel has a quick key stroke that adds todays date (Ctrl + , does
outlook have something similar? Is there a way to design this in Macros or v
basic?
Please provide specifics.