Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Outlook / Programming VBA / December 2006

Tip: Looking for answers? Try searching our database.

form with variable/flexible input textbox

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
David Chang - 05 Dec 2006 10:58 GMT
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] - 05 Dec 2006 13:29 GMT
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.

Signature

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
 

> 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
[quoted text clipped - 19 lines]
>
> David
Ken Slovak - [MVP - Outlook] - 05 Dec 2006 14:13 GMT
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.

Signature

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

> Hi I am drafting an outlook form for our HR people (Please don't ask me
> why
[quoted text clipped - 22 lines]
>
> David
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.