PC Review Forums Newsgroups Microsoft Outlook Microsoft Outlook VBA Programming Outlook 2003 custom form item reference number

Reply

Outlook 2003 custom form item reference number

 
Thread Tools Rate Thread
Old 12-08-2004, 07:59 AM   #1
Colin McGerty
Guest
 
Posts: n/a
Default Outlook 2003 custom form item reference number


Hi,

I'm in the process of writing an issue tracking form for Outlook 2003
for use by our software team and I was wondering if you could give me
some pointers on programmatically creating an item reference number?

I just want to have a nice simple field like "BUG00001177" (or
something) and increment the last used one for each new item.

Any help you could give would be very much appreciated.

Thanks

Colin McGerty
Systems Administrator
Axiom International
  Reply With Quote
Old 12-08-2004, 02:58 PM   #2
Ken Slovak - [MVP - Outlook]
Guest
 
Posts: n/a
Default Re: Outlook 2003 custom form item reference number

I usually use either CDO 1.21 or Redemption (www.dimastr.com/redemption) to
create a hidden item in the folder of interest and then I create a property
in that hidden item that is a Long. I then increment the Long each time a
new item is added to that folder by handling the ItemAdd event on that
folder's Items collection.

You can also make the property a String property in which case you can use
any formatting you want.

An alternative would be to use something like an Access database for storing
the reference sequence. You can also use something like a Post form with the
reference stored in a property like BillingInformation or Mileage, but
something like that is visible and if they can see it users would mess with
it.

For information on using Redemption code see the samples on that Web site.
For CDO 1.21 information and samples see www.cdolive.com. For using Access
or a database see
http://www.outlookexchange.com/arti...eexample.asp#22

Please post your questions via the newsgroups and not by private emails.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Colin McGerty" <colin.mcgerty@mvhi.com> wrote in message
news:a2ec8c3.0408112259.50e6fdfa@posting.google.com...
> Hi,
>
> I'm in the process of writing an issue tracking form for Outlook 2003
> for use by our software team and I was wondering if you could give me
> some pointers on programmatically creating an item reference number?
>
> I just want to have a nice simple field like "BUG00001177" (or
> something) and increment the last used one for each new item.
>
> Any help you could give would be very much appreciated.
>
> Thanks
>
> Colin McGerty
> Systems Administrator
> Axiom International



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

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