Search results

I did all this and it works very well. Thank you for your patience in bearing with a novice like me. I changed data entry to No just so see if that causes an issue. Does not but the sewing type field is blank as it does not pull data from the table. If I enter the width again, then I get the...

Another thing See DB enclosed. The Query and input table have 14 records. I dont see them when i open the form! I entered 2 values and data can be seen in table and Query but not in the form after closing and reopening it? The form source is the query and therefore all 14 records of the Query...

Let me try to explain 1. The length value is dependent only on the fold type and is not dependent on with of the bag as can be seen in tblCutLength. The fold type top and bottom have different options. I have edited the table and ID 1 to 3 which relate only to the top fold type, the values of...

I have gone thru the DB. So much less clutter to have only one qry. Thank you. I have understood how to capture only the PK in the form and not the values and establish relationships with PK only Just one observation - the user needs to select the range and the sewing type combination in the...

I have seen the DB but yet to go through it and understand it. Will do so today. I am sure I will have questions and would like your support.

Can you explain this Dlookup statement We re looking for Bagweight in qrybagweight2 where the erpfgcode (of the record) is same as erpfgcode in the qry. Correct The text '" & [ErpFGCode] & "' is not clear. A better understanding will help me learn

1. The Form is bound to the table - tblUserInput. 2. There are 4 queries being used in this process. In 2 queries we need multi selection in a relationship. The user inputs sewing type and the width of the bag. One sewing type is therefore linked to all the 9 width ranges with each...

The Query and the table are joined on a unique field - the ErpFGcode which is indexed and no duplicates The other queries are joined differently for different reasons For example in the query qryAddonBagBottom i had to select the weight from table based on the width range of one field and the...

I have a form where the user enters data on the specifications of a bag and there is a query and a report to get the result of the exercise - the bag weight It would be a good idea to have the result - the bag weight in the Form as soon as the user fills in all the data, like we get in Excel...

Thank you for taking the pains to explain. It is clear now(y):)

Thanks To understand how it was done, I tried to open the Query in Design view. I get errors as per screenshots below. Can you please explain why? I can see the query only in SQL view Also can I store the result of the query- the weight in the table UserInput in the field created for this?

Can you be so kind to edit the DB and share please

I tried to do do this INNER JOIN. I get an INNER JOIN error. See DB enclosed. See Screenshot below I am not good at VBA so pardon my curiosity but we dont use WidthRange of the Select statement anywhere. Also can you help me understand what we are trying to achieve in this statement?

Hi Paul Thanks. That was just an example. The variables actually are 12 for the width range and 7 for the types of Sewing but that is not a deterrent. Making master data with 84 values is not a problem We will have the masterdata with fields "WidthRange" and "SewType". User data entry form...

I have to build a query to calculate bag weight. I am calling this complex from my perspective The bag weight has 2 major components Fabric – the weight of this is easy to calculate. It is related to width of the bag and length The yarn used sew the bottom of the bag. This yarn weight depends...

Thank you Vlad. You made my day! I cannot thank you enough

Vlad, The process is clear now. Based on this understanding I wanted to make some changes as below: 1. The value ShortClose needs to be saved for future and hence I added this field to the "CustPendingOrdertbl" . I modified the Qry (qryTempPendingOrder) accordingly but all the records which are...

Let me check

Vlad, Yes that works.. I see the code used in the frmTempPendingOrders DoCmd.Echo False CurrentDb.Execute "DELETE tempPending.* FROM tempPending;", dbFailOnError CurrentDb.Execute "qryAddPendingOrderqry", dbFailOnError Me.Requery DoCmd.Echo True I need to productionize this after a few...

Yes. That works. Thank you. How does one replicate this? Where is the code etc. I need to replicate this in the prod DB and a better understanding will help in making the changes