No object in this control...

[tech]

When a user attempts to open a .mde file (Access 2007), the error "no object in this control" is displayed. This is using a terminal server and the error doesn't occur on all machines. ActiveX issue?

Thanks.

[boblarson]

Sounds like you have used the Calendar Active X control (which is deprecated in Access 2007) so it isn't available for it to use. You will need to remove all of those calendar controls from any form that uses it and then you might want to look into using a non-ActiveX solution (including using the built-in calendar control that will appear automatically when entering a date in a control that is bound to a date field.

[zambam737]

Hey Bob,

Thanks for this.. i was having the same problem.

I removed the active X control, and replaced it with a text box which has a date picker.

The compiler runs without incident now.

However, when I select a date, i have to press Enter for it to register the change.. by simply selecting a date doesnt do anything. I want to select a date and for this selection to requery a listbox.. the code works but the date isnt updated just by selecting it. I have tried using VB code SendKeys to send Enter or Tab to enforce the change.. but it doesnt work on any of the control properties...

any advice very welcome..

many thanks

mark