 Page [ 1 ]
|
|||
| Basic Outlook Printer Friendly Version | |||
|
Working with Outlook items, folders, recipients; dealing with security; writing event handlers | ||
| Topic | |||
|
Dbl-click Calendar and send a klient name to Access
Hi, Wonder if it is possible to double click an appointment in an Outlook calendar and by this action send a client name to Access in order to search for this klient in the access database? Lars Frederiksen 05-Nov-2009 03:14 |
||
|
|
Sue Mosher
05-Nov-2009 08:10
Double-clicking an appointment in the Calendar folder opens that appointment. Therefore, anything you want to happen would need to take place either in the Item_Open event handler on a custom appointment form or in VBA using the Inspectors.NewInspector or AppointmentItem.Open event. The connection with Access could be made with ADO. See http://www.outlookcode.com/article.aspx?ID=25 for database references. |
||
|
|
Lars Frederiksen
05-Nov-2009 09:14
Thank you! Does your book explain items like how Outlook and Access can "talk together"? Because when I double-click the appointment in Outlook I would like "the program" to jump to my Access form with the client's name in a search field so I can get hands on the client's data at once. |
||
|
|
Sue Mosher
05-Nov-2009 09:29
My older book has some information on the basics of database connectivity, not specific to Access, but the newer book doesn't, because it's not really an Outlook programming topic. You'd be better off consulting an Access book if you want to display Access forms. |
||
|
|
Lars Frederiksen
05-Nov-2009 09:44
But as I understand it is possible to show (make visible) an Access form through an event-handler in Outlook (I imagine that I have both Outlook and Access opened when starting the day)? Thank you for your time! |
||
|
|
Sue Mosher
05-Nov-2009 10:00
Yes, it's possible, but the bulk of the coding would involve Access objects, not Outlook objects. Outlook's only contribution would be the events I mentioned above and the access to Outlook data through the Outlook object model. If you need a primer on property syntax, see http://www.outlookcode.com/article.aspx?ID=38 |
||
|
Page [ 1 ]
|
|||
| Post a new message to this topic. name email  |