Log in

View Full Version : Automation object


Gapo
Jan 12, 2005, 06:35 AM
I wonder if you could help me?
I started recentley working in a company. I am at the moment working on some listings of data bases in Access 2000. I was trying to make e customers phone list with the form similar to the one at Northwind Example. Everything went well with the table, form design(adjustment) and macro, but when I click on any of Toggle buttons, I am receiving message:

"The object doesn't contain the Automation object 'Company Namefilters'.
You tried to run a Visual Basic procedure to set a property for an object. However, the component doesn't make the property or the method available for Automation operations,. '

Could anyone please tell me what I have done wrong.

Thank you in advance.

davenims
Aug 11, 2005, 05:37 AM
What code do you have behind the form?

This is most likely some code that is trying to run at the same time when you press the toggle button.

If you have a Form_AfterInsert() subroutine, you get this message when you have a continuous form, and press a button or other control before the record has been saved (i.e. if you haven't clicked into another record). If that is the case, you can fix this behaviour by chaning it to Form_BeforeInsert(), and putting a Form.Refresh at the beginning of the code behind your toggle button, so that the record is saved before proceeding.