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 Forms / August 2003

Tip: Looking for answers? Try searching our database.

how to store data written into a form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
rich - 04 Aug 2003 19:18 GMT
I am creating a form for our purchase orders to be
electronic.I will be using the workflow on exchange.I have
already created a form using outlook.My question is how do
I get the data that the user put in. to get stored in a
database for history use.(archive).Thanks
Hollis D. Paul - 05 Aug 2003 00:54 GMT
> I am creating a form for our purchase orders to be
> electronic.I will be using the workflow on exchange.I have
> already created a form using outlook.My question is how do
> I get the data that the user put in. to get stored in a
> database for history use.(archive).Thanks

Tell me, please, that you developed your form using the special
workflow object that you downloaded from Microsoft.  You will have much
better results with it than the standard mail form as your base.

You do understand the difference between the form and the data item.  
The form is the definition of the collection of controls that display
the data items when the item is shown on the screen, as well the
controls that implement the functions you expect to see in the form,
and the interior objects which are intrinsic to the data item.  The
data item consists of all the fields that have user data in them, and,
of course, data which Outlook/Exchange uses to store and manage them.

The grand design of the Exchange/Outlook InforStore is that these two
collections are kept separate until they are mated in the screen object
that the Outlook application uses to display and functionally
manipulate the data.

You include user input in the data collection by binding user-defined
controls to user-defined fields, or by having un-bound controls and
using the click-event of the control to move the input data to a field.

Once you have your user input data moved to permanent fields in the
data item, you can then write code to move the data from those fields
to whatever external database you are using.  Or you can just keep the
data items, and use Outlook vbscript code to loop through the items,
extracting the field data that you desire in a particular operation.  
In either case, you write the code to do what you want done, and run it
from a command button click-event or other event which occurs in the
processing of data items.

Lots of fun.  Do become familiar with www.slipstick.com, as that is the
premier resource for things Exchange/Outlook.  The next best resource
is www.CDOlive.com.

Hollis D. Paul [MVP - Outlook]
Hollis@outlookbythesound.com
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
http://search.support.microsoft.com/kb/c.asp?FR=0&SD=TECH&LN=EN-US
     
Mukilteo, WA  USA
 
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.