Search results

  1. C

    How to query db with memory array data?

    Perhaps use a function called by the query to retrieve the in memory data
  2. C

    Pat Hartman has left the building

    Somewhat out of date - message count is about 800 down
  3. C

    Solved Problem with the format property of a combo box.

    Another option (but more work) is to create a bespoke combo using a textbox and a continuous form that looks like the dropdown. Has other benefits such as being able to use colour and/or richtext in the dropdown
  4. C

    Random "unhide this form" prompt

    Possibly - what happens with a form that has no code?
  5. C

    Random "unhide this form" prompt

    I presume your firm is open but hidden. Have you got code in your other forms triggered when they close to set focus or reference that form?
  6. C

    What's your best/worst joke?

  7. C

    Solved conditional formatting duplicates

    took a quick look at the changes required - if the OP meant what you think they meant, i..e. then see attached - had to modify the query filter slightly to cater for nulls
  8. C

    Solved conditional formatting duplicates

    Agreed, but this is what the OP asked for and provided an image to illustrate and the solution is based on that Not all previous fields If there were three consecutive fields with the same value, the 2nd and 3rd would be highlighted. But easy enough to fix in the function - extend the static...
  9. C

    Solved conditional formatting

    in that case, take note of the red, green, blue values and use them instead
  10. C

    Solved conditional formatting duplicates

    is this what you mean? if so see the attached - a short function which is then called from your query
  11. C

    Solved conditional formatting duplicates

    You might be able to do this with a vba function. Not at my computer at the moment but will take a look later
  12. C

    Solved conditional formatting

    Make sure the backstyle is set to normal
  13. C

    Solved conditional formatting

    in form design view look at the backcolor for a control that has the right colour. if it is a custom colour it might look something like this 1. if it does, copy the value (#66CCFF in this example) 2. if it is a description such as 'access theme 1' or similar, click on the 3 dot caret to the...
  14. C

    Solved conditional formatting

    Aside from the fact you are not specifying a back color, perhaps the control back color is set to transparent
  15. C

    Solved conditional formatting

    If you say so - they don’t matter, so I’ll drop off this thread because i think that is where the problem is Good luck
  16. C

    Solved conditional formatting

  17. C

    Solved conditional formatting

    need to clarify what you mean - are you talking about the non red date in the new record row? Or something about the third row? Whichever it is you need to provide a copy of what your rule is and what field(s) it applies to together with an explanation of what the rule is supposed to do
  18. C

    Solved How to add text to a null value field in an access report

    Why code to do this? Assuming it is null why not use the format property of the control on the report On my phone so change to use the correct double quotes
  19. C

    Optimizing a query with multiple LIKE '%abc%'

    Perhaps two queries , the first just the last % LIKE '@SearchTerm + '%' Which will use an index (assuming the field is indexed). And then a second query using LIKE '%' + @SearchTerm' On the results from the first query
  20. C

    Multiple member List

    You might need a field to allow for annulled marriages 😀
Back
Top Bottom