Data to outlook calander

[Gary.]

I have a form setup with a command button that when clicked sends
information from the form to the outlook calendar.

I am using Office 2007.

My problem is how to reference a specific calendar other than the default
calendar

I have the default calendar and another calendar named BidDate.

I need to send the information to the BidDate calendar.

I am not sure how you reference the BidDate calendar in my Access VBA code

 

[Stuart McCall]

I have a form setup with a command button that when clicked sends
information from the form to the outlook calendar.

I am using Office 2007.

My problem is how to reference a specific calendar other than the default
calendar

I have the default calendar and another calendar named BidDate.

I need to send the information to the BidDate calendar.

I am not sure how you reference the BidDate calendar in my Access VBA code

You really ought to be asking this in an outlook forum. This one is aimed at
Microsoft Access.

Still, I haven't worked much with outlook, but here's my guess: It wouldn't
surprise me if outlook has a Calendars collection, so you could try:

Set cal = objOutlook.Calendars("BidDate")

(change my example names to your own, of course)