By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,094 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

Open MS Access Form to a specific record From Outlook Command Button

P: 2
Hi Everyone,

I need to open an Access 2003 form to a specific record from a custom Outlook 2003 Appointment form. The form has a command button that would pass a record id to access and open the appropriate record. I have searched through many Outlook and Access books and the web and cannot seem to find any info on this. Your help would be greatly appreciated.

Serge
Nov 6 '07 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi Everyone,

I need to open an Access 2003 form to a specific record from a custom Outlook 2003 Appointment form. The form has a command button that would pass a record id to access and open the appropriate record. I have searched through many Outlook and Access books and the web and cannot seem to find any info on this. Your help would be greatly appreciated.

Serge
Hi Serge

I'm not familiar with Outlook VBA but as standard you would need to make sure that the Microsoft Access library was referenced and then use application automation to reference the database and form.

Have a look at the following questions for more information.

http://www.thescripts.com/forum/thre...plication.html
http://www.thescripts.com/forum/thre...plication.html

Mary
Nov 8 '07 #2

P: 2
Thanks very much for your help Mary, you pointed me in the right direction. I think I will be able to solve this issue with a little more research.
Nov 9 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Thanks very much for your help Mary, you pointed me in the right direction. I think I will be able to solve this issue with a little more research.
If you get stuck at any point, feel free to start a new question and we'll try to help.

Mary
Nov 9 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.