473,408 Members | 1,798 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,408 software developers and data experts.

Form problem - LinkMasterFields error (only when adding a new record)?

geolemon
I have a form/subform used for inventory management.
It is a bound form.

The error:
The LinkMasterFields event has produced this error: "The object doesn't contain the Automation object 'Parts'."
I don't understand what this means.

How the form is intended to work:
When you select a part number in the main form, the subform displays potentially several instances of that part number in inventory, and is designed to allow the inventory manager to adjust the quantities for each instance of the part in inventory.

It's bound to a central fact (or matrix) table, which stores key values that relate to dimension tables that describe the attributes of that instance.
My controls in the inner form are drop-downs allowing the user to select valid values from each dimension table, and therefore the appropriate key values are then written to the bound table. Or that's the intention anyway. (ack)
(Parts is one of my dimension tables - the one that contains the part number that corresponds to the part number selected in the outer form.)


The form works fine if an instance already exists in inventory. No problem changing attributes or changing quantity. Press an "Update" control and the record is saved, and a record is written to a transaction log to record the history.

However, if no instance exists in inventory, I should be able to create a new instance in inventory by simply selecting the right combination of attributes from my comboboxes, entering a quantity, and being on my way...

...instead, I'm getting that error.

Is anyone familiar with this error?
What does it mean?
HELP! Very much appreciated!
Jan 7 '09 #1
1 1748
Stewart Ross
2,545 Expert Mod 2GB
Well, when this highly misleading error happened to me it was as a result of a sudden internal failure in the database concerned. For some reason it had become corrupt. I could not fix it no matter what I tried - compact and repair did not help. Deleting the form and importing another copy of the form did not help either, nor did deleting the source query and reimporting that.

The form that gave me the 'does not contain automation object...' message had been working perfectly until then. Thereafter this message occurred when trying to add records.

I reverted to a previous backup to resolve it, but there are other options that may work, including creating a new DB and importing all existing objects in from the apparently corrupt one.

Good luck with resolving it.

-Stewart
Jan 7 '09 #2

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

Similar topics

15
by: Steve | last post by:
I have a form with about 25 fields. In the BeforeUpdate event of the form, I have code that sets the default value of each field to its current value. For a new record, I can put the focus in any...
5
by: Steve Strik | last post by:
My Problem: I have created a database here at work that is exhibiting some very strange behaviour. Essentially the database is structured in a manner where one table is a master record table...
25
by: Lyn | last post by:
Hi, I am working on a genealogy form. The only table (so far) lists everybody in the family, one record per person. Each record has an autonum ID. The parent form (frmMainForm) displays the...
6
by: cyoung311 | last post by:
I'm trying to do an automatic update of one table from another through a form. Basically, when a selection is made for an item, in this case a particular workshop, I want to get the associated...
4
by: Dave Boyd | last post by:
Hi, I have two very similar forms each with a subform. The main form gets a few fields from the user and passes this back to a query that the subform is bound to. The requery is done when the...
2
by: Rosy | last post by:
I have a sub-form(company name & address) that is connected to my contact listing. When I change the contact, it doesn't update the subform until I close the main form or refresh. Is there a way...
3
by: dbaxter7 | last post by:
OK, here's my dilemma. I am trying to create a system to track cases and clients. There are instances when cases have multiple clients, and there are instances where clients have multiple cases. ...
2
by: dBNovice | last post by:
Hi all! I have 3 separate forms: Tasks, Subtasks, and Elements. All 3 is related by TaskId and Subtasks and Elements are related by SubtaskID. In the DB after I add a task, I want to be able to...
4
by: crystal | last post by:
I've checked the threads but haven't been able to come up with a solution to my issue. Help...... I have a simple form based on a table. Within the form is a subform that is also, through a Q,...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.