Recent content by LouiseJ

Sorry I missed that Remou. Thanks Majp. I appreciate the help from both of you.

So no way round it then? I need to test if a sub form is showing any records as a user moves through the records of the main form. Any suggestions? Thanks

Could any please explain why the following isn't working? It seems to fail on the Where clause of the SQL when attempting to open the recordset. However in debug [Forms]![frmMainBuildBOM]![ProductID] has a value. The code is executed from frmMainBuildBOM - ie the form is open. Error message...

Thanks MajP, your help is appreciated, although it will take me while to work my way through this code before I understand what it is doing! Thanks LouiseJ

Thanks Skip I have allowed for labour costs by adding labour as a component in the products table, its unit being 1 hour, and the labour hourly rate as a record in the price table. If an assembly takes two hours to assemble then two labour components are required as part of that assembly...

Hi I have the following tblProduct ProductID PK ProductDescription tblConponent ProductID PK ParentProductID FK Quantity tblPrice PriceListNameID PK ProductID PK FK CostPrice PercentageMarkUp Essentially as I understand it this is a Bill of Materials A product/component may form part of...

Thanks Johnherman. Apologies for the delay in replying, I’ve been away! I have gone back over your previous reply and now understand what you are suggesting! Thank you. As for calculating a price for any product/component I think I should have posted that question over in the Queries and JET...

Thanks Johnherman I think I may not be explaining myself very well. By introducing Product Tables as you suggest we have effectively added another level. A product can now be made up of a component or assembly. However it can not be made up from other products. To do that we could add a supper...

Thanks johnherman for the reply. Whilst your suggested design will allow a price to be calculated I can not quite see how it allows an assembly to be assembled from other component and/or other assemblies. Am I missing something? LouiseJ

Hi I have the following tblProduct ProductID PK ProductDescription tblConponent ProductID PK ParentProductID FK Quantity tblPrice PriceListNameID PK ProductID PK FK CostPrice PercentageMarkUp Essentially as I understand it this is a Bill of Materials I have the primary key in tblPrice on...

I am trying to automatically populate a nested form with records each time the parent form has a new record. The nested forms record source is TblPrintColour. The only way that I have been able to do this up till now is to create a duplicate table (TblPrintColour2) and use an update query to...

Thank you for your perseverance TheAceMan1 and for pointing me in the right direction. I had made a really obvious mistake with the Link Master field in the sub forms recordset. All is now working fine. Thanks again. LouiseJ

Yes it does have the disabled look! (Sorry, overlooked this as form originally designed with out navigation buttons) LouiseJ

Thanks for the 3 options. 1. frmSub1 was designed this way to allow the user a ‘quick glance’ at the records to locate the one they wanted before opening frmMain2 to see all of the detail of the record. (frmMain2 also has a sub form in it – did not mention this previously apologies if...

Hi TheAceMan1 Happy New Year to you. Thanks for coming back. Please bear with me and I’ll try to explain a little better. frmMain1 shows customer records. frmMain1!frmSub1 shows designs for each customer record (one to many). This sub form is in continuous view, each record occupies one...