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

Automation Object Error

P: 1
Hi everyone, I know that there is a question similar to this already posted but the answer to it does not really seem to relate to my problem! So here goes...

I have a main form which has a tab control that links a number of other forms together, if the information is already in all of the corresponding tables then everything works fine but if I am entering new details then I am getting an error in 2 out of my 7 tabbed subforms.

The error I get is 'The object doesn't contain the automation object Registrations' - You tried to run a Visual Basic procedure to set a property or method for an object. However the component doesn't make the property or method available for automation operations.

I have checked the VB code behind the form and there isn't any, this doesn't happen when I click on a button of any sort as there aren't any and there are no event procedures on the form. It happens when I attempt to enter data into the child link field.

To be honest I know it's a mistake I have made as I am no expert in Access, all my tables are linked though I wont guarantee that they are all correct though someone has looked at this for me and told me they are.

What I was trying to achieve was that the primary key would extract details such as surname and first name and place them in every form as soon as the primary key is inserted, the problem is that I have the same primary key in every table and when inserted in one table it is not updating the others, so when I attempt to insert it on one of the other forms I am getting the above error.

Any help would be really appreciated as I have rebuilt this database three times now and keep getting the same problems but with different error messages and I am now really pushed for time to get it finished.
Thanks in advance

acog1
May 10 '07 #1
Share this Question
Share on Google+
1 Reply


JConsulting
Expert 100+
P: 603
Hi everyone, I know that there is a question similar to this already posted but the answer to it does not really seem to relate to my problem! So here goes...

I have a main form which has a tab control that links a number of other forms together, if the information is already in all of the corresponding tables then everything works fine but if I am entering new details then I am getting an error in 2 out of my 7 tabbed subforms.

The error I get is 'The object doesn't contain the automation object Registrations' - You tried to run a Visual Basic procedure to set a property or method for an object. However the component doesn't make the property or method available for automation operations.

I have checked the VB code behind the form and there isn't any, this doesn't happen when I click on a button of any sort as there aren't any and there are no event procedures on the form. It happens when I attempt to enter data into the child link field.

To be honest I know it's a mistake I have made as I am no expert in Access, all my tables are linked though I wont guarantee that they are all correct though someone has looked at this for me and told me they are.

What I was trying to achieve was that the primary key would extract details such as surname and first name and place them in every form as soon as the primary key is inserted, the problem is that I have the same primary key in every table and when inserted in one table it is not updating the others, so when I attempt to insert it on one of the other forms I am getting the above error.

Any help would be really appreciated as I have rebuilt this database three times now and keep getting the same problems but with different error messages and I am now really pushed for time to get it finished.
Thanks in advance

acog1
You have a refresh problem. Chances are all you need to do is set up a case statement.

you would put this on your tab control's change event.
J
Expand|Select|Wrap|Line Numbers
  1. Private Sub MyTabControl_Change()
  2. Select Case Me.MyTabControl.Value
  3. Case 0 'first tab
  4. MsgBox "refresh subformname here"
  5. Case 1 'second tab
  6. MsgBox "refresh second tab subformname"
  7. End Select
  8. End Sub
  9.  
May 12 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.