Recent content by klsblues

  1. klsblues

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

    @arnelgp - THANK YOU VERY MUCH. This is now working as it should and the end users are VERY happy! Thank you to everyone who commented and for the time given to resolving this issue. I had spent hours and hours on this and to have it resolved is brilliant. You guys are great.
  2. klsblues

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

    I agree. I’ve spent so long trying different things but to no avail. It will be interesting to see what DBguy has done.
  3. klsblues

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

    The schedule grid is frmGrid, but it has onload criteria that restricts access. The form frmmainmenu uses the login to set the restrictions. Then select schedule grid.
  4. klsblues

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

    Hi DBguy. I have attached the front end, back end dummy data and a DoNotDelete DB (which is usually encrypted) with licence info in it. When you first go in, the login screen sets user rights and other info, so select the username Eileen and the password is Dover, this will give full rights to...
  5. klsblues

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

  6. klsblues

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

    Thanks DBguy, anything you can do would be very much appreciated.
  7. klsblues

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

    Hi Gasman, Thanks for this - I have edited my original post. I hope this helps someone to help me! Regards.
  8. klsblues

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

    Hi Gasman, How do I do that?
  9. klsblues

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

    Hi Dickyp, So does this mean that the user can't set more than three from a form - instead, I will have to 'pre-set' the CF using the conditional formatting button and not allow the user to choose their own colour scheme?
  10. klsblues

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

    I have the Microsoft Office 365 for Business (Version 2410 Build 18129.20116)
  11. 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...
  12. klsblues

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

    Hi both, I have solved it using 2 queries. 1st query (query1) links tblRoomDesc to tblEstSub (using the room number) I used the form to populate the criteria [SubMainEstID] with the ID Number for the record I want and this returns the 6 rooms used for that record. 2nd query links query1 to...
  13. klsblues

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

    Hi Gasman, Thanks for the reply. I have 2 dropdowns - 1 labelled 'Add a room' and 1 labelled 'Edit a room' and if the user selects edit a room, it only lists the rooms already added (I did this because there are 28 variations to rooms and it saved them scrolling down). It's actually the...
  14. 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...
  15. 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...
See more
Back
Top Bottom