Search results

Can you open Access itself? If no, then do an Office repair or a complete reinstallation If yes, then your database may be corrupted. Try first compacting your database externally and then decompiling your database using command line switches...

I wouldn’t know 😀 And the answer to both of your other two questions (since deleted) is a definite No!

Yes I saw that. Good to know 👍

I’ve not heard any other reports of this and cannot replicate it myself. So it may just be something on your machine? Try rolling back to a previous build or changing to a different channel. EDIT One other thing. Ask ChatGPT for specific links to backup its comment about being a known bug...

I have exactly the same CCP version & build on this (slow) machine. I can still see query SQL in Monaco but its slow to appear as that channel doesn't currently have speedy loading. For the first 3 seconds I see an empty grey box. Its much faster (almost instantaneous) to load in beta channel

@mellamokb Just to clarify... Are you saying that the AllowQueryRemoteTables registry key keeps being removed? Or do you mean that its value keeps being reset from 1 to 0? Also, whichever of those you meant, does this follow a Windows Update? Or was there an Office Update?

I asked CoPilot: Forum question: Can an Access ActiveX CustomControl be assigned to a CustomControl variable declared WithEvents? First the slightly worrying thing: As I have this thread open, CoPilot can reference it! Here’s the architectural truth of it, Colin — and it lines up exactly with...

You also don't need DISTINCT as Access won't let you create two objects of the same type with the same name ;) FWIW I prefer to filter by Type = -32764 (less to type!), but the outcome is identical to that using ParentID = -2147483645

At the moment this whole thread is too speculative for anyone to give you clear advice. When something stops working overnight, the first step is to identify what has changed. Office update? Windows update? Try to identify what changed and see whether rolling back updates fixes the problems...

As I can still use the old IE browser control in both Win 10 & Win 11 (except for PDFs), the answer has to be no. I am finding more & more issues with using it but the IE browser control still works and the Trident engine hasn't yet been deprecated

You can't sort a long text field from the context menu. However, you can of course sort tables by their long text fields from the table property sheet or using ORDER BY in a query. As far as I can remember, both of those have always been possible.

If the app can detect both monitors then it should extend the display automatically when the button is clicked. However if it only sees one monitor then nothing will happen.

I did a quick check earlier today. Searching was no faster after indexing long text fields. In fact in some cases it was slower. Whilst the results suggested there was no benefit in indexing long text fields it wasn't clear whether performance was worse overall. In addition, additional space is...

The old IE browser control hasn't been deprecated yet but will be later this year However, fellow MVP, Karl Donaubauer reported issues with PDFs in the IE browser control to the Access team on 5 Sept and that issue is being investigated. The cause hasn't yet been identified but only affects Win...

That screenshot was from v1.3 The additional items are in version 1.4 which is part of the second link in post #4 https://www.isladogs.co.uk/use-extended-access/index.html

Sorry. Never used Spacedesk nor have I tried using this code where the two monitors are connected to different machines. What do you see when you click the Refresh / View Monitor Info on the main form? Does it show both monitors similar to this? Similarly when you click on View Display...

Exactly so. That is why I said that stating "Null is undefined" is not sufficiently clear in itself. An empty variable is different in nature to a null variable so the results are different.

True but not always sufficiently clear in itself. For example A, B and C are variants: In the first Debug line, C is undefined (unknown) but that doesn't mean its null In the second Debug line, C is 'defined' as null. NOTE: I'm fully expecting responses that disagree with that interpretation! 😉

Assuming you mean autosaving of e.g. Word/Excel files to OneDrive, turn off the AutoSave feature in the application title bar

I also haven't checked recently but that may well still be the case For long text fields with a large number od characters, the data may not all be stored in the same location