Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

THE OBJECT DOESN'T CONTAIN THE AUTOMATION OBJECT ...?!?

Posted on 2006-06-20
4
981 Views
Last Modified: 2007-12-19
I have a subform that is linked to a form by "PONO;" however, when I attempt to add a part number to the subform, I get the following error:

The object doesn't contain the Automation object 'PONO.'

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

Check the component's documentation for information on the properties and methods it makes available for Automation operations.

WHEW!  Help!!!

stevenjoe
0
Comment
Question by:stevenjoe
  • 2
4 Comments
 
LVL 12

Accepted Solution

by:
fruhj earned 500 total points
ID: 16946827
Sounds like the subform got messed up.

do you have other forms/subforms that work?

If so- I suspect you can fix it by deleting the subform, saving and re-adding the subform.
0
 
LVL 84
ID: 16949895
Are you sure that the mainform and/or subform contain the PONO field in their Recordsets? Can you post the .Recordsource of each here, along with the Master and Child linkfields?
0
 

Author Comment

by:stevenjoe
ID: 16953742
Fruhj,

Deleted and re-added and works great--thanks!

stevenjoe
0
 
LVL 12

Expert Comment

by:fruhj
ID: 16954164
Cool thanks for the points!
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question