Recent content by Vector

  1. V

    How to create a dynamic report to adjust various paper widths on a drum

    Thank you for the help. I see that the vba does provide a good start for getting to end goal.
  2. V

    How to create a dynamic report to adjust various paper widths on a drum

    Situation: Paper width to adjust on to a drum that have grooves. Goal: end goal is to place both edges onto "peaks" NOT 'Valleys or groove". Both edges must be atleast 0.1" away from "valley or call it grooves" Example: User Entry: 1.75" If the width of the paper (user input) is less than 7.5"...
  3. V

    common tasks table to be referred in other tables

    Doesn't the append replicates data? I am questioning 1- The logic of tblTransaction, tblMeasurement, tblTransacMeasure. 2- Getting the right IDs appended and use the IDs to pull the tasks and requirements, and then enter actual measurements. Please help!
  4. V

    common tasks table to be referred in other tables

    Hi, I have a common tasks table m-t-m: tblPart: PartID, PartNumber, PartDescription tblTest: TestID, TestNumber, TestTask, TestMinReq, TestMaxReq tblPartTest: PTID, PartIDFK, TestIDFK These tables have pre-defined part numbers, test tasks, requirements. e.g. PartNumber: 111456, 111234, 23156A...
  5. V

    How to create a table with different units of measure e.g. mA, uH, %, checkbox, ohms

    Hello, I have three tables (m-t-m): -tblPart: PartID, PartNumber, PartDesc -tblTest: TestID, TestName, PrameterNo, ParameterDesc, ParameterReqMin, ParameterReqMax, ParameterUnit -tblPartTest: PartTestID, PartIDFK, TestIDFK, ActualReading Question: How do I setup: -tblTest with different units...
  6. V

    Need to create a product traveler database

    Hi, Can someone help let me know if it is possible to take a product traveler (a bunch of papers attached to each product as the product moves from one station to another getting assembled by operators and manually filled out certain specs e.g. temperature, pressure, component serial number by...
Top Bottom