[AccessD] [EXTERNAL] Re: Possible Bug? Access 365 Version 2302 (Build 16130.20218)

Tue Mar 7 14:29:20 CST 2023

Hi Ryan,

We hadn't seen anyone else mention it prior to you bringing it up either!
It is, as you've determined, new to Version 2302, and I think using a query directly as the Source Object for a subform is uncommon enough that most people haven't encountered the problem.

For now, we don't have a workaround other than creating a datasheet form that uses the query as its Record Source, and then using the form as the Source Object for the subform control, rather than the query.

However, we should be able to get a fix for this problem into the Patch Tuesday update (March 14).

Shane

-----Original Message-----
From: AccessD <accessd-bounces+shaneg=microsoft.com at databaseadvisors.com> On Behalf Of Ryan W
Sent: Tuesday, March 7, 2023 11:45 AM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: [EXTERNAL] Re: [AccessD] Possible Bug? Access 365 Version 2302 (Build 16130.20218)

I've gotten wind that this is a known bug that MS is aware of.  Sure wish they'd be more transparent... hadn't seen anyone else mention it prior to me bringing it up.  *shrug*

On Tue, Mar 7, 2023 at 8:38 AM Ryan W <wrwehler at gmail.com> wrote:

> I did some rollback testing. It appears thus far only the newest 
> Office
> 365 update (16130.20218) is affected:
>
>
> Feb 28 - Version 2302 (Build 16130.20218) - **affected** Feb 14 - 
> Version 2301 (Build 16026.20200) - unaffected Jan 26 - Version 2301 
> (Build 16026.20146) - unaffected Jan 10 - Version 2212 (Build 
> 15928.20216) - unaffected Jan 4 - Version 2212 (Build 15928.20198) - 
> unaffected
>
> On Tue, Mar 7, 2023 at 8:06 AM Ryan W <wrwehler at gmail.com> wrote:
>
>> Apologies for the multiple emails... working on this to get a feel 
>> for what's going on
>>
>>
>> Here's a link to a basic 1 table / 1 query /1 form mdb that 
>> reproduces the glitch:
>>
>>
>> https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdri
>> ve.google.com%2Ffile%2Fd%2F1VktXsLHAoeqeDL67eTukhYYVjVjRpF3O%2Fview%3
>> Fusp%3Dsharing&data=05%7C01%7Cshaneg%40microsoft.com%7C624e19a7ab664d
>> 7727f608db1f447dc8%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C63813
>> 8151262380469%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2l
>> uMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=BjUlIw46KEx
>> ujSmbYWoot68%2FZo8pakdfloTM0rKZSIU%3D&reserved=0
>>
>>
>> Another note: using the runtime simulation flag from the command 
>> line, the subform now shows NO data but you can still click in / 
>> around to get the query designer elements.
>>
>>
>>
>> On Tue, Mar 7, 2023 at 7:54 AM Ryan W <wrwehler at gmail.com> wrote:
>>
>>> Here's a short video of the glitch in action:
>>>
>>>
>>> https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fww
>>> w.screencast.com%2Ft%2FdfLDfEE1B&data=05%7C01%7Cshaneg%40microsoft.c
>>> om%7C624e19a7ab664d7727f608db1f447dc8%7C72f988bf86f141af91ab2d7cd011
>>> db47%7C1%7C0%7C638138151262380469%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC
>>> 4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7
>>> C%7C&sdata=%2Ftf7MaZhqhZuSxas7h8VbfzQkLuCEiPOrDBEYq4043g%3D&reserved
>>> =0
>>>
>>> I've tried setting the subform control to locked = yes/enabled = no 
>>> to no avail.
>>>
>>>
>>> On Tue, Mar 7, 2023 at 7:44 AM Ryan W <wrwehler at gmail.com> wrote:
>>>
>>>> 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
>>>> https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fi
>>>> .imgur.com%2FrTniQct.png&data=05%7C01%7Cshaneg%40microsoft.com%7C62
>>>> 4e19a7ab664d7727f608db1f447dc8%7C72f988bf86f141af91ab2d7cd011db47%7
>>>> C1%7C0%7C638138151262380469%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjA
>>>> wMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C
>>>> &sdata=U2XvjHhGznpulraN7C22tGD8POOtfdPQ5jcmoz%2FsxFQ%3D&reserved=0
>>>>
>>>> Crosstab pulldown:
>>>> https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fi
>>>> .imgur.com%2F5FUwo1w.png&data=05%7C01%7Cshaneg%40microsoft.com%7C62
>>>> 4e19a7ab664d7727f608db1f447dc8%7C72f988bf86f141af91ab2d7cd011db47%7
>>>> C1%7C0%7C638138151262380469%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjA
>>>> wMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C
>>>> &sdata=D1U4gvTKQEvscKTtWydJV0aVZsujcPS%2FwUOF3x5xw6s%3D&reserved=0
>>>>
>>>> Total pulldown:
>>>> https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fi
>>>> .imgur.com%2FvJUR0vx.png&data=05%7C01%7Cshaneg%40microsoft.com%7C62
>>>> 4e19a7ab664d7727f608db1f447dc8%7C72f988bf86f141af91ab2d7cd011db47%7
>>>> C1%7C0%7C638138151262380469%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjA
>>>> wMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C
>>>> &sdata=TdBWrfar6ts%2Ff2AtUS7Pj09vZSHIMpKowO%2FZDnYYDUE%3D&reserved=
>>>> 0
>>>>
>>>> I thought maybe it was some form corruption so I tried making a new 
>>>> form with a subform referencing the same stored query and got the 
>>>> same result?
>>>>
>>>> It also does this with stored queries that are NOT crosstabs (like 
>>>> the above example)
>>>>
>>>>
>>>>
--
AccessD mailing list
AccessD at databaseadvisors.com
https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdatabaseadvisors.com%2Fmailman%2Flistinfo%2Faccessd&data=05%7C01%7Cshaneg%40microsoft.com%7C624e19a7ab664d7727f608db1f447dc8%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C638138151262380469%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=3XqhtTho45VN%2Bx7CZsWI1xzQwaXmayxwosgSPAcd8gE%3D&reserved=0
Website: https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.databaseadvisors.com%2F&data=05%7C01%7Cshaneg%40microsoft.com%7C624e19a7ab664d7727f608db1f447dc8%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C638138151262536693%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=4nrk3caJGPAf2dBz2R0TMp93ny209XX5GHV%2Ff1CExHM%3D&reserved=0