Search results

Looks like Edge browser control hit GA yesterday (4/25/23) for Office 365. You no longer have to use one of the Preview/Beta channels. https://learn.microsoft.com/en-us/officeupdates/current-channel#version-2304-april-25

This is resolved in Office 365 16.0.16130.20306 (Released 3/14/23). Not a windows patch, but an office patch.

Well not all of us have early access ;)

3/14/23 Patch Tuesday has fixed this issue.

In related news: the Tuesday patch HAS fixed the ghost designer issue.

Yeah, I know it! Just wishful thinking.

The Monaco SQL Editor isn't hiding in there too, is it? :confused:

I did not see that before deletions but it did appear the people helping the OP were not responding well to whatever hostility was being given.

Hey, I try. Sometimes I don't convey the message right... but being that I deal with end users who give me reports like "this doesn't work" (no detail).... I couldn't do that to anyone else interested in reproducing this bug! haha

Thanks for writing an article about it, Colin!

It's a public group, anyone can join: https://databaseadvisors.com/mailman/listinfo

It's full of a bunch of old timers. We fit right in. lol

That was over on the AccessD mailing list: https://databaseadvisors.com/pipermail/accessd/2023-March/date.html

I've added both workarounds to the post:

Unfortunately since this is a crosstab query using a table might not be possible (though a select * into might do the trick). I'll just roll back to Feb 14ths update until a fix happens. By the way Shane Groff (whom I believe is on the MS Acesss Dev team at Microsoft) told me that if you set...

I couldn't find any reports on the issue on the Access community forums, here or reddit so I posted to all three. Thanks for confirmation. Is the other bug mentioned that your font size goes whacky in the query designer?

I've now received confirmation others outside of my org are affected.

I've got a form with a subform that has a stored query as a source object. When I cursor over the data, I get what appears to be some of the query design elements: Here is the "show" checkbox Crosstab pulldown: Total pulldown: I thought maybe it was some form corruption so I tried making a...

It looks like my quote and parenthesis got inverted at the back end of that expression. Should be Eval("28 IN (15,999,28)")

Eval was already brought up. It also works for IN clauses. ?Eval("28 IN (15,999,28))" Weird to use in VBA but handy in certain situations.