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

Cannot run any functions from a form

P: n/a
Just upgraded to 2k3, and I've never seen this problem before. I have
a form with a couple of subforms, and I need a little bit of code to
refresh both of them when the user changes records. However, any time
I run any kind of function off an event, I get a message that says

The expression On Current you entered as the event property setting
produced the following error: A problem occurred while Microsoft Office
Access was communicating with the OLE server or ActiveX Control

I changed the code to do nothing but open a msgbox, and even changed it
from a private sub to a public function. I can run the function just
fine from the VB window, but I get the error whenever I try to run it
off an event. I googled around a bit and looked for any missing
references, but I couldn't find any.

Anyone that could help me out I'd be eternally grateful. This problem
has pretty well brought my project to a screeching halt.

Thanks!

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


P: n/a
If it was a References problem, it shouldn't work from the Immediate Window
either. I would suspect something is corrupted. If you create a new database
file, does it work properly? If so, make a backup of your current file then
try a decompile/compile. If that doesn't work, try creating a new, blank
database file and importing the objects form this file.

Here are some links on handling corrupt files.
http://www.allenbrowne.com/ser-47.html
http://www.granite.ab.ca/access/corruptmdbs.htm

--
Wayne Morgan
MS Access MVP
"Maddman" <ma********@yahoo.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...
Just upgraded to 2k3, and I've never seen this problem before. I have
a form with a couple of subforms, and I need a little bit of code to
refresh both of them when the user changes records. However, any time
I run any kind of function off an event, I get a message that says

The expression On Current you entered as the event property setting
produced the following error: A problem occurred while Microsoft Office
Access was communicating with the OLE server or ActiveX Control

I changed the code to do nothing but open a msgbox, and even changed it
from a private sub to a public function. I can run the function just
fine from the VB window, but I get the error whenever I try to run it
off an event. I googled around a bit and looked for any missing
references, but I couldn't find any.

Anyone that could help me out I'd be eternally grateful. This problem
has pretty well brought my project to a screeching halt.

Thanks!

Nov 13 '05 #2

P: n/a
I happened to have a backup from a couple of meetings ago, and
recreated the subform. Everything works just fine! The DB must have
just gotten corrupted. Thanks!

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.