Search results

  1. A

    Solved Dependent tables

    I have a split DB and in the BE file I have a large number of tables. Like Excel, can we find out where a table data is linked to - which form or query is using this data of the table. I have a linked Excel file which I used in some forms and need to switch this linkage to a table
  2. A

    Solved Criteria equivalent to BUT

    Pat/MajP I have used the In function exactly as suggested. It works perfectly! Thank you both for your help Anil
  3. A

    Solved Criteria equivalent to BUT

    Thank you. I was not aware of the IN function
  4. A

    Solved Designing a DB

    I read this post. Interesting. Fortunately we have had brainstorming sessions with users in this case. My initial foray into Access was with lesser preparation and consumed a lot of time in correcting things! I saw a post on code for emptying and appending data from a TempTable to another table...
  5. A

    Solved Criteria equivalent to BUT

    Mr Hartman Is the screen shot what you suggest? I think I got got wrong . This query removes all records with MewarInvUnit = M2N. Records with MewarInvUnit = M2N and ConsigneeCode say 1091 are also removed. But we dont want these 6 customer codes to be filtered out! I used this query by...
  6. A

    Solved Designing a DB

    Let me clean my my DB before sharing
  7. A

    Solved Criteria equivalent to BUT

    Mr Hartman I want all rows under Consignee Code to also use the filter condition os MewarInvUnit. As I stated before the condition translated should be all records where MewarInvUnit <> M2N but if customer codes are A,B,C , include them and ignore the MewarUnit filter condition. Howw can this...
  8. A

    Updating a form based on changes in another form

    Mr Hartman, I am aware of this process, but my need is slightly different. I just posted a new thread on this https://www.access-programmers.co.uk/forums/threads/designing-a-db.315121/
  9. A

    Solved Designing a DB

    The DB basically needs to create monthly price lists for customers. The table and queries planned are as below. These 5 tables and queries are more or less ready tblItemDetails = PK – ERPFGCode + various specifications (say TS) tblCustomerRFQ – PK – CustCode and ERPFGCode. It will have other...
  10. A

    Updating a form based on changes in another form

    Mr Hartman You have a point. The CustomerRM Table has prices and dates. Therefore the RM historical data is available and I dont need to store this data in Customer RFQ table. This DB is for price estimation So when I run the report I can check the RM related to the date of the report and do...
  11. A

    Solved Criteria equivalent to BUT

    This is how the QEB looks now and is giving the desired results. All records where MewarInvUnit = M2N are excluded except if ConsigneeCode = 1048, 1091...or 360167 Records where MewarInvUnit is <> M2N and Consignee Code = 362389 or 360631 are excluded
  12. A

    Solved Criteria equivalent to BUT

    Worked!
  13. A

    Solved Criteria equivalent to BUT

    You mean A, B, C will be in Or rows under column SomeOtherField
  14. A

    Solved Criteria equivalent to BUT

    M2N is a seperate field called InvoiceUnit A, B and C are of another field called CustomerCode This is the problem
  15. A

    Solved Criteria equivalent to BUT

    Can you explain further. What criteria do I add in the Customer Code field. There are hundreds of Customer Codes in the tables. I cannot put "A" and "B" and "C" in the customer code criteria as this will remove all other Customers from the data!
  16. A

    Solved Criteria equivalent to BUT

    I have a query with 2 fields on which I want to add a filter criteria Invoice Unit - Exclude data with value M2N - criteria is <>"M2N" - works BUT I dont want this filter to work for 3 Customer Codes - say A,B and C. Meaning filter condition is filter out all records where Invoice Unit is...
  17. A

    Updating a form based on changes in another form

    Let me rephrase the requirement. My approach maybe wrong I need all records in tblRFQ1 to store the RMRate. RMRate source is tblCustRMRate and the RMRate is based on a) RMType (available in tblRFQ1) b) Date - RMRates change every month and thus the need to check the month and year of the...
  18. A

    Updating a form based on changes in another form

    I have a form 'frmMain' where I have an unbound text box 'txtDate' with a date. I use this date to run reports/update databases. In another form 'frmCustRFQ1' I use this date to fetch a rate from a table using Dlookup (see below)in an unbound textbox called 'txtRMRate'. The rate fetched from...
  19. A

    Joining a table with 2 different tables in a query

    In the enclosed DB query "qryUncoatedValueAdd" , I need to select a value - UncoatedRate rate from a table 'tblCustFabricConvRates'. The selection is dependent on the CustomerCode (tblCustRFQHdr) and the FGCode from"tblItemMasterPricingSpecs". The outer joins are posing an error Can someone...
  20. A

    Solved Vertical scrolling issues in a query design view

    Thank you. That worked! I couldn't search for this issue in the forum. I tried before posting.
Back
Top Bottom