Recent content by Brother Arnold

  1. B

    Getting odd errors after update

    So, I checked the references and nothing was missing but I did eventually find the issue with the second error and it was a bug that had always been there. I originally thought the two issues might be related to some sort of corruption but obviously not so I'll ignore the mouse error for the...
  2. B

    Getting odd errors after update

    Thanks I'll have a look. I only use 4. How can I tell if they are broken though?
  3. B

    Getting odd errors after update

    I did a compile in dev before I brought the file over but I didn't do one in prod. I'll give it a go anyway.
  4. B

    Getting odd errors after update

    Hi, anyhelp on the following would be much appreciated. Last Wednesday evening I implemented changes to our DBS and a couple of the users reported errors when they logged in the next morning. The implementation involved back end and front end changes so I took back ups, applied the BE changes...
  5. B

    Solved Query runs slow with NOT IN

    It was 'refreshed' Autumn/Winter last year so it at least knows Biden is president now. Back in July it swore blind Trump was president. OpenAI says today's date is 6th March 2021. I couldn't get on to ChatGPT just now but it's probably the same dataset. In an attempt to alleviate my...
  6. B

    Solved Query runs slow with NOT IN

    Well, it did have to sift through all its resources on the matter, decide which ones are relevant and then work out a reply but I get what you mean. It does work stuff out for itself when there aren't any resources such as yesterday when I pasted a complex bit of code into ChatGPT and asked it...
  7. B

    Solved Query runs slow with NOT IN

    Absolutely. I only mentioned AI out of interest. I don't give it any credence over what you guys are saying.
  8. B

    Solved Query runs slow with NOT IN

    I've used OpenAI for several months and ChatGPT when it came out for lots of different things. I'm in awe of how good it can be but unfortunately you can't trust its answers. You can ask the same question straight after and get a different and wrong result. It seems to me that if it doesn't know...
  9. B

    Solved Query runs slow with NOT IN

    I'm still here, taking it all in :) just getting over man flu Out of curiousity I asked OpenAI how it would resolve my issue and it used an unmatched query. I then asked why it didn't use a subquery and its response was: "The LEFT JOIN query is significantly more efficient than the subquery...
  10. B

    Solved Query runs slow with NOT IN

    Thanks, I completely forgot that existed. I don't work in Access enough to keep everything fresh in my mind :(
  11. B

    Solved SQL problem with 'WHERE a AND b' when b is null

    Sorry, not being clear again. I built rules into the form. I'm relatively new to Access and I didn't step back quick enough when they asked someone to volunteer to maintain it.
  12. B

    Solved Query runs slow with NOT IN

    I'm running a simple query that provides a list of client IDs that are in the client table but are not linked to the monitoring table. It's running a little slow and if I click to go to the last record for example it just hangs. Client has 18k records, monitoring 12k so result is 6k. The IDs are...
  13. B

    Solved SQL problem with 'WHERE a AND b' when b is null

    Originally it wasn't mandatory but as soon as I got my hands on the database I made it mandatory so sorry I wasn't clearer there. I've got over 20 years of data which would have provided some excellent analysis if the original developer had made fields mandatory and written some rules :(
  14. B

    Solved SQL problem with 'WHERE a AND b' when b is null

    Hi, I've spent far too long trying to get this to work and googling on line for an answer so it's your turn if you will to confirm why I'm feeling stupid at this moment and put me out of my misery. So, in my inexperienced Access mind the following statement looks pretty simple and should work...
  15. B

    Access performance issue linked to size of file explorer window

    It's only this desktop. If I access the database on the desktop from my laptop I don't get the issue. I've already tried a and b. Reboot makes no difference. Streamlining the start up code is worth a try. I have a couple of screensaver apps (like rainmeter) and a news app so I'll see what...
Top Bottom