Search results

  1. T

    Update Query - multiple rows

    Hello all, Having a blonde moment! I have a properties table where there is a row for each property with a reference number. [property ref], [property name] etc In a second table are the charges for each type of maintenance for each property. [Property ref], [Charge category], [Charge amount]...
  2. T

    Creating a schedule

    hi, theres only the timecard template for access that comes up in the search which isnt really suitable at all. Thank you though :)
  3. T

    Creating a schedule

    Hi everyone, I am creating a database for a maintenance business. There are numerous properties in a table, another with charges for each maintenance type eg cleaning, pool maintenance, gardening etc. I need to create a schedule to show available dates for each maintenance type into which one...
  4. T

    Update a field based on selection in other field

    pbaldy you are a star :) got it sorted thank you :D
  5. T

    Update a field based on selection in other field

    thank you but i want the security deposit field to populate only when the property ref is entered on the entry form. I was thinking a lookup function on the after update property of the property ref? but not sure how to achieve it - cant remember the code :/
  6. T

    Update a field based on selection in other field

    Good evening, Its been a while since i did an access database so am a bit rusty! Can someone please advise? I have two tables, Bookings and Properties, both are related using a Property Ref field. On my data entry form bookings there is a field for security deposit amount. I want this to be...
Back
Top Bottom