Search results

I have 3 linked tables in a Query as shown in the db enclosed. The screen shot of the query is as below. Is it possible to. get the linked tables data in columns and rows. I would like to have one row for each record in tblFabricCodeMaster_New and the data of Tape internal code in different...

I have 2 simple tables - an item Master and a table for the Bill of Material for the items in the master. Master (tblItemMasterMain) has all the items - those which need a BOM (Serial no ends with .1) and those which are part of the BOM . All items in this table are unique - no duplicates...

I am using the following expression in an Update query. The form referred to as a command button to the run the Query. However the criteria does not work. There are no syntax errors but it does not work IIF([Forms]![frmUncoatedRateChange]![txtItem]="Paperbags",17...

I have seen multiple posts on these and seem to be making a stupid error in logic/syntax which I cannot pinpoint The expression I built is as below. =DLookUp("[FGSpecs]","CustSODtlsTbl","[ERPfgcode]= '" & [Forms]![InvHdrfrm2]![InvDtlsfrm2].form.[ItemCode] & "'" and "[HeaderID]=" &...

I have 2 unbound text boxes in different forms using the same expression to display [FGCode].[column](1). FG code is a column of the same table used in the both forms In one form the value is displayed as in the table, but in the other form, it gets cropped - see below. What could be the...

I need to add a line break in an expression of a text box. The internet search yielded an expression &VbCrLf& for a line break. This does not help The expression used was ="A="&" "&DLookUp("packingtext","tblpacking","Abbreviationpacking='A'") & vbCrLf & "B="&"...

I have a continuous form based on a table "tblCustRFQCorrection" as below In the form when a enters a new EndCustCode, I would line the form to add 16 records with the same EndCustCode and PricingGroupID from 1 to 16 with blank CorrectionMF fields which the user will fill up If the End...

I have 2 fields in a form which are supposed to store values when user enters data. The 2 events in after update event of the 2 fields (UncoatedGSMID and ) in the CoatingGSMID1 form are as below Me.UncoatedGSMID = Me.UnGSMID Me.CoatingGSMID1 = Me.CGSMID1 The events work fine. The problem is...

I created 2 Update queries as below and added it to a subform with command button using a wizard. The table was updating but the sub form was not refreshing. I read there is bug in Access on sub form Requery. I tried several methods as suggested in forums , some only are listed below UPDATE...

I have a simple query where I use a right join. If an item is not found in the right joined table, it gives an error Many values of Lamcode in the tblUncoatedFabCost are blank. In these cases I get a #Num! error in the query. How can I get 0 instead of the error as I need to use this value in a...

I have a main form A and sub form B setup and need to search for a record in the sub form using a cbo say F placed in the header of the sub form. The Master form and sub form link fields are A1 and B1 I want to locate a record in the sub form by searching the value in the field C of the form...

I have a expression in a query as below QuoteUOM: IIf([UID]=1,

I have a table where I store the specifications of the object. There are 6 specifications, 4 of which are combo boxes and 2 are textboxes The combination of these 6 values needs to be unique. I therefore added an ComboCode in the table to store the conjugated values of these 6 textboxes and set...

I have 2 sample tables as in the enclosed DB file 1. tblItemMaster which has PartNo and a DFL value for each item 2. tblValueAdd which have a Value add for a min and max value of DFL What is the most efficient way to build a query where I can get the ValueAdd for each item in the...

I have strange problem which was not faced earlier. I must have accidentally made some changes in settings which I cannot trace back When I hover the mouse over any object in the Navigation pane it gets selected without clicking. This at times can open objects accidentally. This happens with...

The Data of tblStdBagConvRates is as below. The values 0.001 to 0.015 represent the ValueAdd for the bag sewing operation and this value depends on width of the bag (BagWidthMin and BagWidthMax) and the type of sewing BottomSewingStd or BottomSewingEZOpen BagConvID BagWidthMin BagWidthMax...

I have a query which looks like this. In the qryUncoatedFabCost some values of LamCode are Null and therefore values (numbers) fetched from qryCoatingRecipeHdr show error in such cases. I would like such values to be 0. I tried Nz() function to avoid this. No result. How can one resolve this?

I have a continuous subform where I am facing an issue. The record source of the subform is included as Picture 1. The record source in datasheet view is Picture 2 The Subform in Form view is Picture 3. The problem I face is that the moment I start a new record in the sub form I get an error...

I got this error in the main form/subform today In the table linked to the main form I see a record as below which seems to be the cause of the problem. The table linked to subform is as below I deleted the 2 entries in the sub form related table, ID 2470 and 2471 but am unable to...

I have a form where the RecordSource is a query. In this query I have an expression as under and display this value of QryCode in the form using an unbound text field QryCode: IIF(Left([itemmastertbl].[internalcode],1) = "B" or Left([itemmastertbl].[internalcode],1) = "F"...