I have posted here quite a few times about Excel Automation and thank everyone for their help with it as I am trying to learn more levels of Foxpro. The only things that I get tricky on are these API Calls, Active X, and OLE Controls.

I have experimented with the Calendar Control in VF7. I am trying to get a date box to pop the calendar when it is right clicked. Then when the end user picks the date, it will put it into the date box. However, I looked it up on MSDN and it came up with instructions on creating a class for the datebox, but is that necessary?

I added the calendar control to the form. I make it visible = .F.

When the right click is executed on the box, the .oleAdviseCalendar is set to .T.

However, when I place code in the AfterUpdate and try to take the value clicked, it blows exception errors for OLE. I assumed that the value would be inherent when clicked and automatically placed in the box. Could anyone steer me in the right direction into getting this to work?

Thanks


Never Underestimate Radical Vision