By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,084 Members | 1,969 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,084 IT Pros & Developers. It's quick & easy.

Unable to open form !!

P: n/a
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


Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"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
Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.