Unable to open form !!

[Filips Benoit]

A particular form - always the same - sometimes becomes corrupt after
saving.
Error msg =
The expression On Open you entered as the event property settings produced
the following error:
A problem occurred while 'DB-name' was communicating with the ole server or
ActiveX controle.

The form has a calendar-controle.
I have eliminated the code in the OnOpen-event but the form stays corrupt!

Sometimes before being corrupt the properties of a particular combobox are
changed.
Column Heads from No > Yes
List Rows from 8 > 25622
The rowsource becomes uneditable ( no ... on the right)

Any help is welcom.

Filip

[Fletcher Arnold]

"Filips Benoit" <be***********@pandora.be> wrote in message
news:M4********************@phobos.telenet-ops.be...

A particular form - always the same - sometimes becomes corrupt after
saving.
Error msg =
The expression On Open you entered as the event property settings produced
the following error:
A problem occurred while 'DB-name' was communicating with the ole server or ActiveX controle.

The form has a calendar-controle.
I have eliminated the code in the OnOpen-event but the form stays corrupt!

Sometimes before being corrupt the properties of a particular combobox are
changed.
Column Heads from No > Yes
List Rows from 8 > 25622
The rowsource becomes uneditable ( no ... on the right)

Any help is welcom.

Filip

Check your references. Are any missing? Does compact and repair help?
What about saving a copy of the form with a new name?
If things get really bad, remove all your code from the form and keep it
safe in a text file. Remove the control from the form and save the form.
Create a new database and import all objects. Re-insert the object and
paste your code back in.

For the future you could consider a non-activex control for the calendar.
Many people use an all-Access solution to avoid issues with the calendar
control.

Fletcher

[Filips Benoit]

Thanks,

Removing, re-insert the object + code curred the form.

Where can i find a non-activex control for the calendar?

Filip

"Fletcher Arnold" <fl****@home.com> wrote in message
news:bu**********@titan.btinternet.com...

"Filips Benoit" <be***********@pandora.be> wrote in message
news:M4********************@phobos.telenet-ops.be...

A particular form - always the same - sometimes becomes corrupt after
saving.
Error msg =
The expression On Open you entered as the event property settings produced the following error:
A problem occurred while 'DB-name' was communicating with the ole server

or

ActiveX controle.

The form has a calendar-controle.
I have eliminated the code in the OnOpen-event but the form stays corrupt!
Sometimes before being corrupt the properties of a particular combobox are changed.
Column Heads from No > Yes
List Rows from 8 > 25622
The rowsource becomes uneditable ( no ... on the right)

Any help is welcom.

Filip

Check your references. Are any missing? Does compact and repair help?
What about saving a copy of the form with a new name?
If things get really bad, remove all your code from the form and keep it
safe in a text file. Remove the control from the form and save the form.
Create a new database and import all objects. Re-insert the object and
paste your code back in.

For the future you could consider a non-activex control for the calendar.
Many people use an all-Access solution to avoid issues with the calendar
control.

Fletcher