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

Ryan W wrwehler at gmail.com
Tue Mar 7 14:35:41 CST 2023


Hey Shane,
 Because this is a crosstab query I'm not sure I can make a datasheet for
it since the column names are (in this case) dates, and sometimes dates
with extra information.

 I am changing the QueryDef.SQL string based on the criteria needed, that
Stored Query is statically bound to the subform control.

 I now have someone on Reddit who's run into this and someone on the Access
Tech Community as well.  Not sure if they're all using the stored query as
the source object or not.







On Tue, Mar 7, 2023 at 2:29 PM Shane Groff via AccessD <
accessd at databaseadvisors.com> wrote:

> 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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list