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

Adding date Validation between 2 months



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old May 6th 09, 10:16 AM
cidr cidr is offline
Junior Member
 
First recorded activity at Outlookbanter: Mar 2009
Posts: 6
Default Adding date Validation between 2 months

Hi there,

As I'm new with working with Outlook forms, I'd like to ask for help.

I'm developing an Outlook form for the company I work for. The idea is for people to go the calendar and book a laptop for a certain period of time. The entry will populate the calendar when the form closes. There may be quite a few entries in one day.

The information shown in the entry within the calendar is the number of the laptop, the name of the person who has the laptop. The entries are listed in the order they're created.

I'd like to find a way of sorting the booked entries by laptop number so the are sorted from 1+.

Does anyone know if there's a way to sort the entries?

Many thanks in advance for any help


P
Ads
  #2  
Old May 6th 09, 01:59 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default Adding date Validation between 2 months

Just use one of the calendar table views, make sure that property is added
both to the items and the folder and show that field in the view using the
Field Chooser and then sort on it.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"cidr" wrote in message
...

Hi there,

As I'm new with working with Outlook forms, I'd like to ask for help.

I'm developing an Outlook form for the company I work for. The idea is
for people to go the calendar and book a laptop for a certain period of
time. The entry will populate the calendar when the form closes. There
may be quite a few entries in one day.

The information shown in the entry within the calendar is the number of
the laptop, the name of the person who has the laptop. The entries are
listed in the order they're created.

I'd like to find a way of sorting the booked entries by laptop number
so the are sorted from 1+.

Does anyone know if there's a way to sort the entries?

Many thanks in advance for any help


P




--
cidr


  #3  
Old May 7th 09, 08:43 AM
cidr cidr is offline
Junior Member
 
First recorded activity at Outlookbanter: Mar 2009
Posts: 6
Default

Thanks for responding Ken,

I'm not sure how to add the property to the Items and folder (I'm not sure what you mean by item or folder).

I noticed your book, is there a section in there that may help me understand how to do this? I'd be happy to purchase it.

Many thanks

p
  #4  
Old May 7th 09, 02:49 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default Adding date Validation between 2 months

There's some stuff on forms in my book, but not in great detail. My book
deals more with COM Addins and FormRegions and such.

Sue Mosher's book is much more oriented towards forms and VBA programming.
You can find a link to Sue's book at www.outlookcode.com, where you'll also
find a ton of information about forms and forms programming.

Take a look at http://www.outlookcode.com/article.aspx?ID=38 for information
about adding fields to a form and what the results are of different ways of
adding those fields. Your goal is to add the field so it's added both to the
item (form) as well as the folder fields.

Once that's done and you use the View menu in Outlook to select a table type
calendar view you can right-click on the column headers in the table view
and select Field Chooser. You can then use the drop-down in Field Chooser to
select User defined fields in the folder and your fields should be listed.
You can then drag a field from the Field Chooser to the column header row of
the view to show the field in that space in the view.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"cidr" wrote in message
...

Thanks for responding Ken,

I'm not sure how to add the property to the Items and folder (I'm not
sure what you mean by item or folder).

I noticed your book, is there a section in there that may help me
understand how to do this? I'd be happy to purchase it.

Many thanks

p




--
cidr


 




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
Date Field Validation Chris Outlook - Using Forms 2 March 30th 08 07:00 PM
Date Navigator - Show 2 or more months Date Navigator Calendar 2 or more months Outlook - Calandaring 0 December 10th 07 07:35 PM
change months in the date navigator Jennifer Outlook - Calandaring 1 August 27th 06 06:22 AM
how do i get the Date Navigator to show three months at same time Ivette~ Outlook - General Queries 3 August 4th 06 03:47 AM
My date navigator isn't bolding events past three months Julie Outlook - Calandaring 2 April 21st 06 01:59 PM


All times are GMT +1. The time now is 08:17 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.