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...
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...
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...
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...
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...
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...
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.
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...
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 :(
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...
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...