Search results

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

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

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.

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

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

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

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

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

For about 2 or 3 weeks now, everytime I click on Access it takes about 10 seconds to load the database I'm working on. I've tried other databases I haven't touched for several months and they take 10 seconds as well. By accident I discovered that if file explorer is open maximum size it takes 10...

Thanks, I spent a lot of time reading what turned out to be low quality responses to this issue. This link looks a lot better and gives me the info to have a sensible conversation with Ops.

Hi, I've just migrated several thousand records into my client's database from an old system and have started to get 3343 unrecognised database format a couple of times a week since then. It's fair to say I've also made a few changes to the code during this time and on the day that the error...

Oh because I'm an idiot! Thank you. I blame the heat. I removed the binding and it worked first time. Doh! On the bright side jdraw has given me some ideas on how to improve my error handling. Sorry everyone for wasting your time.

Sorry, the problem was whatever record I chose to update it would always update record 1 as well by overwriting the notes field. I didn't want to update record 1 at all. Since posting the issue I deleted every line of code except the update statement and changed p_lngID to 10. The result was it...