Recent content by AnilBagga

  1. A

    Query to get linked table data in columns not rows

    The output desired is shown in the Excel file enclosed.
  2. A

    Query to get linked table data in columns not rows

    Thank you June7. This looks a bit tough for my level of Access knowledge. Will copy paste this and revert
  3. A

    Query to get linked table data in columns not rows

    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...
  4. A

    Report Takes too long to process

    Thanks🙏 . Will test this very shortly
  5. A

    Report Takes too long to process

    1. I had an issue with sorting in text fields with Serial Nos. 1.2, 1.21, 1.22, 1.31 - they were not appearing in this sequence and I had changed the database structure. Changing it back to text could create other problems which I may not be able to handle. The DB is a subset of a large...
  6. A

    Report Takes too long to process

    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...
  7. A

    Solved Using IIF and Between and Or conditions in Access query

    Arnel, This is the code for the command button. Correct? In this statement, UpdateQuery = "Update [yourTable] Set [yourField] = blah" what is [yourtable]. This is not used anywhere else . The form is unbound and query name is "qryConvUpdate" What will be the criteria in the Query ? I wanted...
  8. A

    Solved Using IIF and Between and Or conditions in Access query

    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...
  9. A

    Solved Dlookup multiple criteria

    Thank you Arnel. I understood the mistake I was making
  10. A

    Solved Dlookup multiple criteria

    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]=" &...
  11. A

    Solved Text box length gets cropped in a form

    I put a dlookup statement in the text box and now I can get the full text. Thank you
  12. A

    Solved Text box length gets cropped in a form

    I saw that. What I could understand though as to why it works in the other case!
  13. A

    Solved Text box length gets cropped in a form

    The cropped version text box is unbound. cbo box is FGCode and source of the cbo is the table of ItemMaster. The text box control source is [fgcode].column(1) The uncropped version is coming from a query, as source of this form is a Query. The cbo in ths form is the same table as above - Item...
  14. A

    Solved Text box length gets cropped in a form

    Yes. It is 255. The other form is displaying 268
  15. A

    Solved Text box length gets cropped in a form

    I have the FG specs in table set to long text. But, if the table is same, why is the display different in different forms?
Top Bottom