Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   form with variable/flexible input textbox (http://www.outlookbanter.com/outlook-vba/34544-form-variable-flexible-input-textbox.html)

David Chang December 5th 06 11:06 AM

form with variable/flexible input textbox
 
Hi I am drafting an outlook form for our HR people (Please don't ask me why
we use outlook for this purpose). This form requires the HR person to enter
employees' information. (The number of employees can change from time to
time.) Since each employee's info will take a lot of space, so I would like
to find out if there's a way to automatically expand the number of fields
for this purpose.

For example:

Outlook form

Field1 - Field10 : for 1st employee
Field11-Field20 : for 2nd employee

When the HR person finishes entering Field20, Field21-Field30 will show up
for the user to fill up. Field31-Field40 will show up after the user
finishes entering info for Field30.

Is it possible to do something like this?

Your help will be greatly appreciated.

David



Sue Mosher [MVP-Outlook] December 5th 06 01:29 PM

form with variable/flexible input textbox
 
You would have to design all the fields you need into the form before you publish it. A better design would be one employee per item.

--
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

"David Chang" wrote in message . ..
Hi I am drafting an outlook form for our HR people (Please don't ask me why
we use outlook for this purpose). This form requires the HR person to enter
employees' information. (The number of employees can change from time to
time.) Since each employee's info will take a lot of space, so I would like
to find out if there's a way to automatically expand the number of fields
for this purpose.

For example:

Outlook form

Field1 - Field10 : for 1st employee
Field11-Field20 : for 2nd employee

When the HR person finishes entering Field20, Field21-Field30 will show up
for the user to fill up. Field31-Field40 will show up after the user
finishes entering info for Field30.

Is it possible to do something like this?

Your help will be greatly appreciated.

David



Ken Slovak - [MVP - Outlook] December 5th 06 02:13 PM

form with variable/flexible input textbox
 
Dynamically adding controls to an Outlook item is an excellent way to
one-off the form. You also have to be careful about too many controls on a
form, that can cause corruption and data loss and in extreme cases can cause
Outlook to just vanish from memory. Use fewer than 100 controls to be safe.

You can create your controls on tabs (a tabbed control) and make the tabs
visible as needed.

--
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


"David Chang" wrote in message
. ..
Hi I am drafting an outlook form for our HR people (Please don't ask me
why
we use outlook for this purpose). This form requires the HR person to
enter
employees' information. (The number of employees can change from time to
time.) Since each employee's info will take a lot of space, so I would
like
to find out if there's a way to automatically expand the number of fields
for this purpose.

For example:

Outlook form

Field1 - Field10 : for 1st employee
Field11-Field20 : for 2nd employee

When the HR person finishes entering Field20, Field21-Field30 will show up
for the user to fill up. Field31-Field40 will show up after the user
finishes entering info for Field30.

Is it possible to do something like this?

Your help will be greatly appreciated.

David





All times are GMT +1. The time now is 05:03 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com