A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Outlook form backend



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old January 2nd 07, 03:50 PM posted to microsoft.public.outlook.program_vba
[email protected]
external usenet poster
 
Posts: 1
Default Outlook form backend

I'm not sure if I am posting this into the right group or not but I
hope I am.

I am trying to make a custom form that will let me send a training
request to my boss and have all that information stored in a Access
database backend.

In the first place is this even possible? From what I have read so far
it should be. The second thing is I have no experience in programming
VBA so anything would be greatly appreciated. I have some programming
experience but VBA syntax is a little above me.

Thanks,

Dan

Ads
  #2  
Old January 2nd 07, 04:01 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Outlook form backend

As a practical matter, you'd be able to get it to work only if you can publish the custom form to the Organizational Forms library on Exchange Server or each user's Personal Forms library. Even if you met those requirements, you would have a steep learning curve ahead of you, since you'd need to learn:

-- VBScript syntax if you plan to put the code to talk to the database behind the custom form (It's not clear whether VBA would be an alternative, given what you've told us so far.)

-- Syntax for working with the Outlook object model

-- ADO syntax for working with the database

Outlook custom message forms are not the best way of performing this kind of operation. A much better tool from the Office 2003 and 2007 suites is InfoPath.

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

wrote in message ups.com...
I'm not sure if I am posting this into the right group or not but I
hope I am.

I am trying to make a custom form that will let me send a training
request to my boss and have all that information stored in a Access
database backend.

In the first place is this even possible? From what I have read so far
it should be. The second thing is I have no experience in programming
VBA so anything would be greatly appreciated. I have some programming
experience but VBA syntax is a little above me.

Thanks,

Dan

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to open the default Contact form with the Activities tab activated from a custom form? VSTO 2005, Outlook 2003 David Webb Outlook and VBA 1 June 20th 06 09:59 PM
Outlook program, outlook form, local webpage form & Excel Junoon Outlook and VBA 1 April 3rd 06 06:45 AM
modify outlook form-appointment form blanc Outlook and VBA 1 March 24th 06 03:20 PM
Outlook opens Form as Email message, not Form [email protected] Outlook - General Queries 2 January 26th 06 09:54 PM
I send an Outlook custom form, but a std. form displays? Sue Mosher [MVP-Outlook] Outlook - Using Forms 0 January 20th 06 07:41 PM


All times are GMT +1. The time now is 10:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2024 Outlook Banter.
The comments are property of their posters.