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 / May 2008

Tip: Looking for answers? Try searching our database.

Binding an Outlook Form to a Recordsource

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
HK - 22 May 2008 15:15 GMT
Is it possible, in outlook, to have a "table" and bind the form to a
Recordset and the Fields to a Record Source? Would this use DAO or
ADO?

I'm familiar with programming in MS Access so my mind relates this to
Access.

I'm trying to simplify making changes to existing Outlook
Appointments.

Note: I posted over in microsoft.public.office.developer.outlook.vba
but I thought I'd post here as well.
Ken Slovak - [MVP - Outlook] - 23 May 2008 13:56 GMT
Where would this table exist? Outlook doesn't have tables you can set up,
although it's own database (PST file or Exchange mailbox) is a modified Jet
database. What sort of form do you want to bind your table to?

An Outlook form can display information from a database such as Access but
only by interfacing with the database using code every time the form is
opened and displaying the data in something like a grid control. But there's
nothing native for that. How you'd connect to a database such as Access is
up to you, ADO or DAO work equally well.

You can sort of do a binding of Outlook items to Access, but it's limited to
only certain fields.

Please explain better what you want to do and where. And please don't
multipost. People will just ignore your posts.

Signature

Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm

> Is it possible, in outlook, to have a "table" and bind the form to a
> Recordset and the Fields to a Record Source? Would this use DAO or
[quoted text clipped - 8 lines]
> Note: I posted over in microsoft.public.office.developer.outlook.vba
> but I thought I'd post here as well.
HK - 23 May 2008 18:46 GMT
Sorry about the multiposting.

You answered my question. I would like to "bind" the Outlook form to
an Outlook "table" but i see that it won't be possible. It just didn't
make sense to me why the properties existed if they cannot be used in
outlook but it does make sense if you can bind your form to an ADO or
DAO recordset that's bound to an Access database.
 
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.