Search results

  1. Vicar

    Lock old prices from updating

    Hi, please help if you can, i have searched the threads, but unfortunately didn't see anything close. Please point out if i missed some. I am trying to lock or archive old records/invoices from updating when prices update for the same products/services. Anyway of doing it a quick and dirty...
  2. Vicar

    4 Tables into 1 record = stuck

    I am making a service db, and one of the main functions in it, is customer's current equipment list with a parts sublist. These are the fields in the servicing equipment table and it is a duplicate of equipment table (EQ ID,Name, Manufacturer,Model,Serial,DateLastServiced(gets updated from a...
  3. Vicar

    Form with a Tab Control is stuck in loop

    I have a main form and a two-tab subforms connected to it. When i had one added, everything was fine, after inserting second one, when i run main form it starts looping-requerying the main form and also it’s subforms. I have included a clean version, maybe someone can tell me what’s the...
  4. Vicar

    Trying to import or recreate a multiplier formula from excel to access

    Simultaneous multi-discount calculation Really need help on this one, here is an excel expression: X Multipliers $ Value Multiplier is less than 5 then *3.8 is less than 50 *3.2 is less than 100 *2.8 is less than 200 *2.4 is less than 500 *2 is greater than 500 *1.8 so if price is less...
Back
Top Bottom