In need of help for 2 more form controls

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BMS - 20 Jul 2004 04:11 GMT

I have created a small helpdesk form for my users. I
added a "Due By" textbox and set the value to Date. Now,
the default keeps coming up as NONE in the textbox,
although you can remove it and keep going. How do I make
it come up blank each time?

Also, is there a way to create a read-only textbox such
as "TICKET #" and have it increment the number each time
someone uses it? Or is a connection to a small DB in the
background necessary? Thanks!!

Reply to this Message

Sue Mosher [MVP-Outlook] - 20 Jul 2004 04:45 GMT

You can't. Outlook always shows None for a "blank" date although it actually
stores the value #1/1/4501#.

To have a set of sequential numbers, you have to get the next number from
somewhere. A database table with an autonumbering table is a good solution.

Signature

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

> I have created a small helpdesk form for my users. I
> added a "Due By" textbox and set the value to Date. Now,
[quoted text clipped - 6 lines]
> someone uses it? Or is a connection to a small DB in the
> background necessary? Thanks!!

Reply to this Message