Search results

  1. D

    Change tracking: comparing two tables for differences

    I have a similar issue. I need to compare and approve pricing between two tables: component pricing from a Contractor against component pricing from the Supplier. There needs to be a way to only see a list of FG codes that are unapproved where component pricing exists in the supplier tab...
  2. D

    Query Criteria and Variable in E-mail in VBA

    Getting Access to understand it is comparing prices for a SKU so it can move the approved pricing to an official table, send an e-mail once it's approved/denied to the finance department/contractor and then loop the remaining SKUs. One set of pricing comes from the contractor, the other set...
  3. D

    Form Group By Alternative

    Thanks for the response! I have utilized sub-forms as an option; however, the information encompasses many pages so it is a very big form. Also, the user may only need the company overview or contact information, not necessarily all the capabilities (there are about 5 categories of...
  4. D

    Form Group By Alternative

    Hey, Team! I currently have an information database for about 115 companies. There are several tables such as "Company Information", "Amortization", "Plant Location", "Manufacturing Capabilities", etc. I want to be able to open one form, such as "Company Overview" and have it link to another...
  5. D

    Query Criteria and Variable in E-mail in VBA

    Thanks for your help! We are trying to automate one of our price verification procedures. There are two forms to be filled out on Access. One (maybe two) come from our Contractor. They will input the Bill of Materials, Scrap Rates, Inventory Turns and Cost. This goes to a non-official Bill of...
Top Bottom