A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Outlook 2007 form into access field format



 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8  
Old October 30th 09, 12:38 PM posted to microsoft.public.outlook.program_vba
Karl Timmermans
external usenet poster
 
Posts: 789
Default Outlook 2007 form into access field format

#1 - Would suggest that you use newsreader when responding to the messages
to retain a thread of what the conversation is about. anyone reading your
response would have no idea as to what this is in reference to ....in any
case

#2 - "what help file" - since your subject is in reference to "into
access field format" - am assuming you are familair with MS Access and
therefore not sure how differently to state the first sentence in my
original response: " See MS Access help Format Property - Date/Time
Data Type - set your Access field definition accordingly at teh table level
(in your case = Short Time for hh:nn format as per your original post).
Alternative is to search Outlook VBA help for "Format".

#3 - This has absolutely nothing to do with outlook custom fields (or
Outlook in general for that matter) but everything to do with dealing with
the DateTime field type. You're question relates to the display format
since your original/question asks how to show 4:13 instead of 4:13:00
AM - The question/issue would be the same if you were inserting another MS
Access table datetime field instead of an Outlook datetime field.

For reference sake - the DATETIME field is stored internally as a "numeric
value" which gets tanslated and displayed according to the "format" rules
established (or to be more specific - it would never internally contain the
characters AM or PM). The format date rules (wherever set/used) govern how
any datetime gets displayed (or what gets extracted from the field). What
you can do is limit the datetime value elements inserted into a datetime
field (i.e. date only with a 00:00:00 time value, no date with time only
etc) but that is completely outside the scope of the original question.

Karl
__________________________________________________ ____
Karl Timmermans - The Claxton Group
ContactGenie - Importer/DataPorter/Exporter/Toolkit
"Contact import/export/data management tools for Outlook '2000/2007"
http://www.contactgenie.com


"bear" swin_1234[at]yahoo[dot]com wrote in message
...
Thank you for the lead. The goal is to have format handled on import.
I am not sure what help file you were talking about in relation to custom
fields. Submitted using http://www.outlookforums.com



 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
pdf format in access 2007 Grimwadec Outlook and VBA 1 October 12th 09 02:35 PM
Make field searchable in custom form in outlook 2007 Irina Outlook - Using Forms 1 May 16th 09 08:56 PM
How to Access the "To" Recipient field and update it in outlook form Venkat M Outlook - Using Forms 11 October 13th 08 08:01 PM
How do I set up the phone field to format with dash in Outlook? joecross Outlook - Using Contacts 1 October 17th 06 01:26 AM
How to access custom field in Custom Form by C# Minh Nguyen Outlook - Using Forms 3 April 24th 06 03:32 PM


All times are GMT +1. The time now is 03:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.