There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Business Applications
Tag Cloud
audio blue blue screen boot bsod compaq computer cpu crash dell drivers dvd error excel firefox format freeze freezing hard drive install internet internet explorer kb951748 lan laptop loss of internet malware memory motherboard network networking outlook outlook 2007 problem restart screen security slow sound startup trojan update virus vista windows windows xp winxp wireless zonealarm zone alarm
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Software & Hardware > Business Applications >
Access Link Master Fields help!!


Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members. Enjoy!

Closed Thread
 
Thread Tools
skins2848's Avatar
Computer Specs
Junior Member with 10 posts.
 
Join Date: Jun 2008
17-Jul-2008, 12:04 PM #1
Question Access Link Master Fields help!!
I have a form with many subforms. The main form and subforms are linked by the access generated ID numbers. However, whenever I try to input data into one of the subforms I get the message, "The LinkMasterFields property setting has produced this error: Object or class does not support the set of events" I am not sure what that means, but it hasn't affected the form that I know of. The data still saves within the subforms. Anyone know how to remedy this problem?
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 6,863 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
17-Jul-2008, 12:29 PM #2
If the data sources of the Subforms are in different Tables then you should not be using the Autonumber to Link them to the Main Form. Each Subtable should have a Maintable ID field to create thr correct Relationship between the tables. That is the field that should be used to Link the SubForms to the Mainform.
__________________
.
.
OBP
I do not give up easily
skins2848's Avatar
Computer Specs
Junior Member with 10 posts.
 
Join Date: Jun 2008
17-Jul-2008, 12:38 PM #3
What exactly do you mean? How would I set that up?
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 6,863 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
17-Jul-2008, 01:23 PM #4
Can you post a "Zipped" Blank version of your database?
skins2848's Avatar
Computer Specs
Junior Member with 10 posts.
 
Join Date: Jun 2008
17-Jul-2008, 01:53 PM #5
You may recognize it, you helped me out last week. Thanks again!
Attached Files
File Type: zip arch database.zip (101.6 KB, 11 views)
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 6,863 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
17-Jul-2008, 02:39 PM #6
Ok, I recognise it. you need to do some work on your table structures, you need to make the Applicant ID fields in the Sub Tables "Number" Type "Integer" and add the tables own ID Autonumber Fields. The Master Table Applicant ID field must be the Key field as I have set it up.
I have done the 3 shown on the relationships (Main menu>Tools.Relationships), note the way that they are Joined with One to Many links with Referential Integrity enfocred. this means that you must have an Applicant ID in the Master table before you can have that number in the Sub Tables.
The master Child links on the Forms automatically take care of that.
You might have some trouble with your eal database if it has data in it, as it might break those rules.
Have a look and see if you can reproduce it for the other tables and with your data.
Attached Files
File Type: zip arch database.zip (118.8 KB, 16 views)
__________________
.
.
OBP
I do not give up easily
Closed Thread

Tags
access, access 2007, help me, link master fields, troubleshoot

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.



Thread Tools


You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 05:49 PM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.