Search results

Thanks for correcting my typo in the build number. So far all feedback on this bug fix has been positive.

@LarryE For info the Current Channel (CC) build you are on does contain a number of bugs. Suggest you update to the latest CC build 18925.20138 where the bugs have been fixed

See above

No but I have now. The additional spaces persist both in the legacy editor and in a text editor such as Notepad Just to make matters worse if I paste the subquery SQL into a new query it is truncated possibly due to a character limit?) and the final part is altered and in Notepad.... I...

Here is another (working) subquery based on Northwind 2.4 Dev edition SELECT Orders.CustomerID, Orders.OrderDate, Orders.OrderID FROM Orders WHERE Orders.OrderID IN ( SELECT TOP 3 OrderID FROM Orders AS Dupe WHERE...

As recently mentioned in another thread https://www.access-programmers.co.uk/forums/threads/trust-center-and-auto-updating-front-ends.334286/#post-1967416, code run from trusted locations can be at least 20 times faster as it bypasses the Anti Malware Scan Interface (AMSI scan) which otherwise...

FWIW, I understand the restriction on accessing forums from work Anyway, the article I mentioned is: https://isladogs.co.uk/trusted-location/index.html In particular, see section 4: Which is better? Trusted Document or Trusted Location?

@Silversee The Access team have requested a simple repro database. Are you able to upload that here for me to pass on to them.

In my experience when end users see that security message, it can cause a lot of concern and the response is often to click Cancel Although your situation is imposed by your IT department, it is short sighted. You could probably still add trusted locations using code without that being blocked...

Sorry, but I don't agree with doing that. Instead they get this security message: Are you really suggesting that having users click Open on the security message is a satisfactory solution?

Make sure all users run the database from a trusted location so that it will work first time. Depending on how your distribution is managed, you should be able to include a registry script for setting this as part of the distro.

The Access team have today confirmed that the next update to the Current Channel (v2506 build 18925.20136) will contain a fix for the disappearing captions bug. It should be released sometime this week - possibly tomorrow (Wed 2 July)

The Access team have today confirmed that the next update to the Current Channel (v2506 build 18925.20136) will contain a fix for the disappearing captions bug. It should be released sometime this week - possibly tomorrow (Wed 2 July)

The Access team have today confirmed that the next update to the Current Channel (v2506 build 18925.20136) will contain a fix for the disappearing captions bug. It should be released sometime this week - possibly tomorrow (Wed 2 July)

That particular query was chosen as it clearly illustrated the addition of unwanted spaces in the query designer caused by the pretty formatting in Monaco. It was originally created to demonstrate a different Monaco bug (since fixed) and has been useful for testing several Monaco related issues...

@Silversee TLDR: For now, disable Monaco and manually remove the additional spaces. The full answer: You didn't mention it but you are on an insider channel: Current Channel (Preview) and as such can expect to get bugs in new features. I am on the faster Beta Channel so get newer features but...

@Minty Perhaps, before you leave you can send a link to post #28 to your affected clients so they can perform the same action if they are on that specific build. Have a good holiday

@Thales750 Thank you. That's exactly what I needed to know That Office build should not have been released to the current channel. It is not listed on the 365 release history webpages: https://learn.microsoft.com/en-us/officeupdates/update-history-microsoft365-apps-by-date Unfortunately, that...

@Minty Please can you find out the update channel, version and build info of the affected users and report back

I remember having this conversation some time ago The channel should be displayed whichever one you are on. No idea why it doesn't appear for you. Probably a registry setting in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Configuration but no idea which.