Search results

  1. C

    Solved VBA Database.Execute("CreateTable...") - Table created in CurrentDB, not the specified DB

    you seem to be missing some code - ws is not declared, what is the code represented by ... and personally I would use dao.database rather than just database
  2. C

    UK Online Safety Laws - I, and therefore the site, are at risk

    There is also If a stupid idea works, it’s not stupid
  3. C

    TV License sorted..

    Not prepared to get into a debate, come and live here to find out how much has gone wrong in the last 15 months or so. It's not just about those particular laws.
  4. C

    TV License sorted..

    No - ever since labour got into power
  5. C

    TV License sorted..

    BBC is getting a lot of stick for: 1. Biased reporting - DT is threatening to sue for $1b for unfavourably editing a video on 2021 speech, and a report on Gaza broadcast without making it clear it was created by HAMAS to mention two recent activities 2. LGBTQ agenda overly supported- recent...
  6. C

    Change the background colour to red if the (word) or (words) are surrounded by a Bracket

    Phones always do
  7. C

    Solved How to Update a recordset without a loop?

    You can't use TOP with an update query but if you know the recordPK of the first record entered you could use something like this (not tested) with recordsetclone .movefirst currentdb.execute "UPDATE myTable SET identifier="something" WHERE UserFK=" & !userFK & " and recordPK>=" &...
  8. C

    Solved How to Update a recordset without a loop?

    Wouldn’t that be the userid, perhaps with reference to the condition?
  9. C

    How to query db with memory array data?

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

    Pat Hartman has left the building

    Somewhat out of date - message count is about 800 down
  11. 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
  12. C

    Random "unhide this form" prompt

    Possibly - what happens with a form that has no code?
  13. 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?
  14. C

    What's your best/worst joke?

  15. 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
  16. 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...
  17. C

    Solved conditional formatting

    in that case, take note of the red, green, blue values and use them instead
  18. 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
  19. 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
  20. C

    Solved conditional formatting

    Make sure the backstyle is set to normal
Back
Top Bottom