CodeDocu.com

MS Access Error: The object does not contain the automation object

 

When entering a new data record, the error is displayed:

 

Error message:

The LinkMasterFields property settings have caused this error:

The object does not contain the automation object tblBase_Player

 

Here, when entering the first value into a data field of the subform

MS Access Error: The object does not contain the automation object

 

Reason:

In the subform, the parent detail reference must always be specified. In a subform, there is a field that refers to a field or value in the main form.

This value is missing when creating a new record. You have to set it before.

 

Solution:

Remove parent entries and reduce the subform with the data source so that only those records that are set in the main filter are displayed.

 

Delete the link master fields and link child fields entries

To do this, select the subform and remove the entries under link in Properties.

MS Access Error: The object does not contain the automation object

 

Reduce the records

 

To do this, click in the subform and then open the entry on the data source.

Here you have to change the SQL-Select entry.

 

Reduce the records in the subform, depending on the filter field in the main form:

SELECT * FROM tbl_Football

WHERE IDBase_Player=[Forms]![frm_Players]![ctlList_Players]

 

 

Here is the data source in design mode. You can see that with * select all fields and the filter refers to the ID field.

MS Access Error: The object does not contain the automation object

 

 

Default value:

 

The subform always refers to the selected record in the main form. This is why you have to make this entry in the data field automatically when you create or append records.

The automatic default value is obtained by entering a reference to the filter field in the main form in the field: Default value.

 

Example: as a default value for new values

Default Value: = [Forms]! [Frm_Master]! [CtlFilter_Control]

MS Access Error: The object does not contain the automation object

 

Test when entering new records:

New records have been added, marked blue here.

It is important that the IDBase_Player was entered automatically as the default value

MS Access Error: The object does not contain the automation object

 

News English:

The LinkMasterFields property settings has produced this error:

The object doesn’t contain the Automation object tblBase_Player

 

 

 


Software Entwicklung Stuttgart NĂ¼rtingen
Suche Projekte C#, WPF, Windows App,ASP.Net, vb.Net, WinForms, SQL Server, Access, Excel