Subform Linking Error
Dec 20, 2005
Could someone please help me trouble shoot this error:
"The Link MasterFields property setting has produced this error:'A problem occurred while Microsoft Access was communicating with the OLE Server or Active X Control'
I get the error when I try and select an item from a drop down list in a combo box on a subform that is linked to another form. The list is coming from a separate table.
When running the subform without opening the parent form I can choose from the combo box and do not get the error.
C
View Replies
ADVERTISEMENT
Aug 23, 2006
Hello,
I have a form and subform linked by the ID field (AutoNumber) on the Form and Record ID field (Number) on the subform. I have the field size on the Record ID field set to Long Integer.
When the form is opened, a message pops up "The LinkMasterFields property setting has produced this error: 'Ambiguous name detected: Add_client_info_Click' There was a macro set up with the name Add client info. However, that macro is not being used on either of these forms. I don't understand why this message is popping up.
Any ideas? I have checked each form, each form section and each field to make sure that macro didn't somehow get assigned, and I can't find it anywhere in relation to these 2 forms.
Thanks
Stacey
View 1 Replies
View Related
Apr 17, 2013
Go to frmInvoice, and you'll see a Net Total box (txtNetTotal) . It's control source is linked to a textbox in the subform fsubInvoiceDetails2 called txtStocktotal. It basically just pulls up all the costs associated with that InvoiceID.
The reference mechanism is as follows: =[fsubInvoiceDetails2].[Form]![txtStockTotal].Now...sometimes this works and sometimes it doesn't! Sometimes i've had to use: =forms!fsubInvoiceDetails2!txtStockTotal.
It seems to be very temperamental at times and i'm not fully confident if this can be explained.By way of note, I use express builder normally to input these statements: I go to Forms > ALL FORMS > fsubInvoiceDetails2 > txtstocktotal.
View 2 Replies
View Related
Mar 8, 2005
Hope someone can help me with this:
1. I have a form called F_Progress.
2. I have a form called F_Property.
3. F_Property contains a subform called F_Job.
4. F_Property is linked to F_Job by the Job ID field. Its a one to many relationship.
5. F_Job is linked to F_Progress by the Job ID field as well. One job has many months progress.
What I want to achieve:
I want a button within the subform (F_Job) which when you click on opens the related record in F_Progress where the Job ID is the same as the one in the subform.
Any suggestions very much greatly appreciated.
MZP
View 1 Replies
View Related
Nov 5, 2013
Have a database with a back end that I have been working on. The database resides on a USB at the moment. I was ready to deploy and now when I try to re-link the back end tables, I repeatedly have the following error: "Your network was interrupted. To continue, close the database, and then open it again."
At first I thought this was something to do with the network, as I was moving it to a shared network drive. However, I can recreate the same issue using someone else's computer and using my USB (although it's mapped to a different drive letter). I've tried a few things, including recreating the back end by importing only the table structure, but still no luck.
View 4 Replies
View Related
Jan 5, 2006
Firstly, apologies if any of the following seems to denote bad database design or a lack of forward planning. It does, but I've inherited it, so I'm stuck with it (for the time being).
I have a Subform (Training_Records_Sub) linked to a Form (Employee_Training). Both forms get their data from tables of the same name.
Up to now, these have been linked on the field Employee_ID. This has been working fine, as all information stored related to permanent employees, so everyone had an Employee_ID value.
Now, however, I've been informed that the system also needs to store information on temporary and contract staff, neither of whom have an Employee_ID number. In fact - for reasons I fail to understand but which I'm sure make sense to management - there is no unique indentifier stored for any of these people.
The best I can come up with is as follows:
Permanent Personnel - Can be uniquely identifed by Employee_ID and Cost_Center.
Temporary Personnel - Can be uniquely dentified by Last_Name, First_Name and Requisition_Number (this last number can apply to many people). I realise that two people of the same name COULD be hired under the same requisition number, but I've been assured that this won't be allowed.
My problem is in working out how to now link the Form and Subform.
Is there some way to use an 'If...Then..Else' statement? Even in VBA? I've sort of got an idea of what I need, but a day of playing with the code hasn't worked, so I thought I'd try posting.
Any ideas greatly appreciated.
View 1 Replies
View Related
Nov 17, 2006
I'm having a problem with my sub forms and the sample linking image code.
Top subform is in data view and the bottom in form. Sync'd with a textbox.
notes show individual data per record as you click on them, and the picture updates the location the same.
Problem I am having is that the picture does not display even though the path is there.
View 10 Replies
View Related
Jul 20, 2006
hey all,
i am having a problem linking my subform data to my form data on more that one fitler.
that is, i have a form that contains Last_Name and First_Name and a subform that pull a different set of info form anther table as i scroll through the main form.
on the properties of the subform i have Filter set to "Me.FilterOn="Last_Name".
BUT i need to bring in the filter on Last_Name AND First_Name because of different entries that have the same last name.
thanks
tuk
View 2 Replies
View Related
Mar 13, 2005
I'm creating a database to assist with the sales operations of a hat shop. I have a form for creating new orders called 'Invoice' where the order number and date is set.
Within this form is a subform called 'Invoice_Order' (Continuous layout), this form is used for assigning order items to an order number.
Within the subform there are two combo boxes which search the Stock table.
1st ComboBox- diplays hat styles (E.g- v1/v2/v3/v4...)
Problem is; different hat styles are available in different colours based on the material used. I would like the second CoboBox to display a list of colours depending on the style of hat chosen.
At present i can only get it to display a list of colours for all hat styles.
Does that make sense?
Any help would be most appreciated
View 4 Replies
View Related
Oct 12, 2005
At the moment i have an exisiting database that was not created by me. It consits of about 7 tables and a main table. Each table has a Primary Key that is a joining field. The Main form is built with subforms and when i enter a number in the primary key filed of the main table it enters that number in all the other primary keys in the other subforms.
i have now tried to create another subform to put into the main form but i cannot get this "link" between the primary fields to work.
can someone please help.
View 1 Replies
View Related
Jan 30, 2015
I have a form with a combo/dropdown on the MAIN form and a child subform.I have designated a Master /Child link of ID to FGId respectively linking the combobox with the subform.
However, when a select an item from the combobox I expect to see the subform datasheet refresh accordingly. This is not happenining , even when I force a refresh call on the subform control itself....?
View 1 Replies
View Related
Nov 22, 2006
Hi,
I have a form linked to a subform by an activity field, Both have a UID field also. I want to store the UID from the main form in each record in the subform. How do I link the two? I've done it before but cannot remember how and have been trying now for AGES! Any help would be much appreciated :)
View 2 Replies
View Related
Aug 16, 2013
I have an entry form with a field(combo box) called cboGetCode. I also have a sub form (continuous form) with number of fields, also an entry form. Now, I have added a code behind the cboGetCode AfterUpdate event to populate the result to relevant fields in the main form.
PHP Code:
Me.lngSCode = DLookup("[lngSchoolCode]", "[qrReadingFirstSchools]", "[lngSchoolCode]='" & Me.cboGetCode & "'")
This is working very well.Now, what I would like to do is get code as shown in the cboGetCode field to my sub form lngSCode field.
View 1 Replies
View Related
Apr 18, 2006
Hi All.
I have a from "frmMainClient" which has a subform "frmJob". They are linked using a field "accoint_no". when run the output show me the content of the "frmMainClient" and all the related jobs in the "frmJob" subform.
That fine. I now want to add another subform "frmSuppliers". I want to link the "frmSuppliers" to the "frmJob" using a field "supplierID" which is in both forms.
The end result required is the "frmMainClient" content is display along with all the records in the "frmJob" (linked) and all the records in the "frmSuppliers".
I hope I have been clear.
Can anyone point me inthe right direction to make this work.
Many thanks, keep safe and well.
Dereck
View 3 Replies
View Related
Dec 18, 2006
hi guys i was wondering if you can help me this is my code: i have a main form with this code, this form contains a subform linked by the All_PricingID
Set rst = CurrentDb.OpenRecordset("tblAll_Pricing") 'main table
' adding data to the table
rst.AddNew
' Main table
rst!All_PricingID = Me.txtPricingID 'Main table pk
rst!MainContract_ID = Me.cmbMainContract 'combo box in parent form
rst!ItemNumber = Me.txtItem 'Main form text
rst.Update
'sub Table
Set rst2 = CurrentDb.OpenRecordset("tblPricing") 'sub table
For varItem = 0 To Me.lstsubContracts.ListCount - 1 'this is a list in the main form
'--- loop through all the items in the list box and create a new row in the subform for each subcontract in the listbox lstSubcontracts.
rst2.AddNew
rst2!ID = Me.All_PricingID 'sub table foreign key
rst2!SubContractID = Me.lstsubContracts.Column(0, varItem) 'sub table
rst2.Update
Next varItem
'--- close the tables
rst.Close
rst2.Close
Set rst = Nothing
Set rst2 = Nothing
the subform appears correctly with the rows i wanted added but i need the user to be able to edit a column in the subform for the rows just created (my form is on datasheet view). but everytime i move to cursor into the subform, i can't even scroll up and down.
i keep getting an error that says :
The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. (Error 3022)
but when i check my tables tblAll_Pricing and tblPricing , everything is inserted correctly according to my recorset above, do you know why this is happening? and why i am not able to edit my subform. my subform allowsedits and additions.
help!!
View 2 Replies
View Related
Aug 22, 2014
How to populate the parent form's PK to multiple records in a child subform set to a default view continuous form?
In other words, how to auto populate the primary key to multiple records displayed the subform?
View 5 Replies
View Related
Jan 18, 2008
Hi all!
We have a form in our application(developed in Access 2003) with numerous tabs in it. On click of each tab a subform is displayed with relevant details.
Each of the subform is mapped to a table in turn.
When the subform is opened it shows the all the values of the table.
But when the form is opened (in Access 2007), it shows only one record in the subform.
The application works fine in MS Access 2003 showing all the records in the subform.
Suggestions please!!!!!
View 2 Replies
View Related
Nov 24, 2005
Hi guys,
i have a form which has a sub-form on it. each one is bound to a different table. the main form has a one to many relationship with the subform, but every time i try to add a new record to the subform i get an error say that you cant insert a duplicate foreign key.
not sure how to solve that as sql enterprise manager and access do seem to have the option to allow duplicates on the foreign key coloum.
View 3 Replies
View Related
Apr 18, 2007
hello,
I have a subform which opens good with Access 2003 but now that I updated to Access 2007, it won't open. It gives me a "type mismatch in expression" error. Why does this happen??
thank you.
View 2 Replies
View Related
Mar 15, 2008
Hi, i have a form which shows stock levels. It works by the user entering a value and pressing search, then one query returns the data on the product from the stock table (so that it can be edited), and another query returns a "total of how many have been sold" in the form of [sumofunitquantity]. by subtracting the number sold on the one subform from the number bought in on another, i get the number in stock.
my problem is, because of the way this system works, if the item has been bought in but none sold, it returns an #error in the [in stock] field because the return on the [sumofunitquantity] is null.
when the query is run in this situation, the product information is shown along with the number bought in, but the field for the number sold remains invisible on the form, so the calculation cannot be completed.
i have tried using a code such as this:
Private Sub Combo63_Change()
If IsNull([frm_stocksubsub].Form![SumOfUnitQuantity]) = "" Then
[frm_stocksub].Form![Text23] = 0
Else
[frm_stocksub].Form![Text23] = ([frm_stocksub].Form![StockBoughtIn] - [frm_stocksubsub].Form![SumOfUnitQuantity])
End If
End Sub
but with no success. basically i want it so that if there is a null value in no. sold, the stock value is 0.
any ideas?
thanks
jjames
View 7 Replies
View Related
Sep 19, 2005
I have a bound form with a bound subform which is in continuous or datasheet view. I have been experiencing a strange problem of late. After i complete the first record of the subform and then move on to the second record , sometimes i get strange messages like :-
1) The Microsoft Jet Database Engine Stopped the process because you and another user are attempting to change the data at the same time.
2) Invalid Argument
3) Unrecognised database format c:windows empjet(something).tmp
4) Not a valid bookmark
These errors once they appear wont go away even if you try to ignore them. they just keep coming and each of the columns has an "#error# written in it. you have to close the module and start again. Whats more if you enter exactly the same data again, they do not show up again i.e. random errors. and it happens only when you complete the first record.
To clarify, these errors appear even in a single user environment. i do not change the recordsource or link fields properties at run time for the subform or mainform.
is there anything i have overlooked in form design / code ? Please help me out.
View 6 Replies
View Related
Nov 4, 2005
I have a subform inside a Form.
When I'm trying to upadate the subfrom from an event triggered by a control in Form I get the error message that subform is not opened.Why is that?
I've tried commands MoveTo or Select (subform) before update command in order to force update command to understand that subform is opened but without any result.
I guess is a common problem but I can't find the solution. :(
View 1 Replies
View Related
Feb 13, 2006
Hi all,
I have a form with two sub forms and when I enter data into one of my subforms I get this error?
A Problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control.
Close the OLE server and restart it outside of Microsoft Access. Then try the original operation again in Microsoft Access.
I've checked the relationship and linked child / master fields and it looks ok. Does anyone know what could be causing this?
I am getting this error on a couple of different PC's running WinNT4 and Win2000.
Shutting down doesn't help and I don't get this with other databases. When I open the form (subform2) on its own I can enter data, just not when it's part of the main form?
View 1 Replies
View Related
Aug 14, 2006
Hi all,
I have a form with a button on it, that when clicked it will open a subform on the same form. But, when I clicked this button, it gave me this error message:
The expression On Click you entered as the event property setting produced the following error: A problem occurred while [Database Name] was communicating with the OLE server or ActiveX Control
For more details on this error message, see the attached file.
Any attempt to help will be highly appreciated.
Sorry for bothering you.
View 2 Replies
View Related
Sep 6, 2006
Well, I've got a multiple stage form structure. Data tables, in case it matters.
The two stages that we're interested in right now, let's call them Stage1 and Stage2. Anyway, Stage1 is controlled by a query (Query1) of a table (Table1). And Stage2 used the be the subtable of the Table1. It didn't work, with the same error.
"This property is read-only and can't be set." is what I see if I try to enter data into Stage2. I can enter data, but none of it is saved. The data entered into Stage1 -> (Query1 -> Table1) works perfectly.
Just for the record, Table 1 and Subtable are related, with referential integrity. How do I fix this?
View 2 Replies
View Related
Dec 16, 2004
I have a control called TotalPaid in a subform Footer section that sums up payment Amounts in the Details section. TotalPaid's control source is simply =SUM([Amount]).
That's it. Nothing tricky, I'm not summing up calculated controls or anything...
PROBLEM: TotalPaid frequently displays "#Error".
I can determine absolutely no reason for this. It is inconsistent, and is not specific to any certain subform records or mainform records. If I go to the next mainform record and then go back, the #Error will often disappear, to be replaced by the apprpriate SUM value.
Is this an Access 2000 bug?? I need to know what causes this and what I can do about, since the value in TotalPaid is VERY important to many of my other calculations. When it gives an #Error, my whole app becomes worthless.
View 4 Replies
View Related
