i am using Access97 in a Novell environment.

The database i created works fine for me and my colleague. but when my boss (!) opens a form, first, he gets a message "There is no object in this control".  By clicking OK he can get to the form.

But, once in the form, any button he clicks (combo box, list box, command buttons, etc) produes the following error:

The expression On Click (or whatever the event is) you entered as the event property setting produced the following error: Automation error.
*The expression may not result in the name of a macro, the name of a user-defined function or [Event Procedure].
*There may have been an error evaluating the function, event or macro.

I do have a Calendar control in the form. could that be messing things up?  but, it works on my machine.  why not his?

i went into a code module and clicked on 'tools' 'references' and checked my boss's settings and my settings, and we both have the same items checked.

what a mystery!!! please help. my boss went back to using an Excel spreadsheet instead of my lovely database because of this.

Yes that’s exactly the Problem.
Your Calendar control is not he same as your bosses. Or he does not have one at all on his machine.
The way to find out is create a new form on you boss’s computer and try to add the calendar.
If its there great then you will have to use his on his PC and your's on your PC every time you make a change to that form you may have to re-sync the Calendar control.
But and I suspect this is more likely the culprit. The Boss’s computer does not have the calendar .DLL at all.  In which case you have to copy it to his PC and register it in his registry.
I‘m not sure if this is the file but “MSCAL.OCX” is on my PC. But I have Access ’97 and Access 2000 both loaded.
Depending on what operating system you have. I have Windows 2000 Pro.
Run this command at Start, Run menu
RegSvr32.Exe c:\Winnt\system32\xxxxxxxx.dll

c:\Winnt\system32 = The System32 folder on your boss's PC
Or
You can call Microsoft if you have LEGAL copies of Access 1-425-635-7050
They will help you install the calendar control too. <<<Best solution

DougP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.