MS Access link to MS Outlook Help please!

[madetoheal13]

Hello all!

I have a question. Is it possible to link MS Access to Outlook? Specifically...My database is of my company's customers (specific retail locations). I have a data entry form that draws form a Customer Table, Contact table, and Face2Face Table (which is information from actual in store visits.) To make it easy for our outside sales people I would like to have all info in 1 place obviously so in that same form I would like to create a subform which will draw from a "new" table specifically for the Scheduling aspect of it. So when you bring up the specific retail account and you make an appointment with the account, can you click a date on a pop up calendar in the form then click off a check box that says "Schedule appointment"...so that access will take that date and send it to the calendar in MS Outlook that is shared with management, so one does not have to manually type in all appointment info in access because it is already in Access to be sent with the click of a button. I hope this wasn't too confusing.

Thanks!
Madetoheal13

 

[MajP]

Search this site there is a lot of code on this subject.
Example thread707-1167011

 

[madetoheal13]

OK I did this and it compiles fine. When I go to click the command button that will trigger this code, it comes back with an error 2465 saying that it cannot find the field referred to in my expression. any thoughts?

Madetoheal13

 

[MajP]

Not sure what exactly you put in, but if your referring to the code on that thread there are a lot of references to specific fields and controls from their forms.

 

[madetoheal13]

Ok I think this is the problem. I have a main form then I have a subform in that main table which was made directly from my Appointment table. I have the code and command button written in the main form, but it is referencing the fields from the subform. How can I click the button on the main form...to take the appointment from the subform and send it to my Outlook Calendar?

Thanks
Madetoheal13

 

[PHV]

Have a look here:

http://support.microsoft.com/?kbid=209099

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[madetoheal13]

Ok cool...last question...where do I put the form reference? in the VBA code?

Madetoheal13