Search results

  1. klsblues

    VBA Conditional Formatting error because I have more than 3 formatting requirements.

    Hi all, I am getting the error... An error occurred: The format condition number you specified is greater then the number of format conditions. I have a table that lists the status details of a job (see attached jpg) which allows the user to select (from a form) a fore color and back color...
  2. klsblues

    Solved Combobox to return the values from a table that haven't already been used and exclude the values that have been used

    I have a table that stores rooms (i.e. Bedroom1, Bedroom2, Living Room, Bathroom, etc.) it has the primary key as the room number (autonumber) and I have 2 tables to store information about the room. tblEstMain holds the main room information tblEstSub holds the individual items listed for the...
  3. klsblues

    Include or exclude records with a Zero value field using a checkbox on a form.

    I have a query that lists products and prices and a form that I use to print Various product price lists. On a form, I select a product group and I can print off the current price list. For certain purposes I want to include zero value sell price (it highlights to me that i need to add the...
  4. klsblues

    Solved WHERE on Allen Browne's ConcatRelated module issue.

    Hi everyone, I have hit a brick wall I am going round in circles trying to figure out the correct WHERE part of the Concatenation module from Allen Browne. I need to Concatenate the Qualifications for each candidate, but the query is returning all Qualifications against each candidate. So for...
  5. klsblues

    Solved Schedule grid

    Hi there, Is it possible to create a schedule grid like the attached picture? I haven’t started this yet, so I’m open to all ideas, but I was thinking along the lines of having an Employee table (with all the employee details in), a Schedule table (which would have date, start time and end...
  6. klsblues

    Sub form and main form issue - totals on sub form and updating main form problem.

    I have a weird issue with a database I’ve written. I have a table called tblQuote which contains the Quote details (Header info) and a tblQuickQuote which contains the individual lines for each quote (The tables are linked by QuoteId in the tblQuote). I have a form with the main quote details...
Back
Top Bottom