[AccessD] [EXTERNAL] Re: Access lockup when using record selector search

[Ryan W]

Yeah lots of questions came up that I wasn't thinking about.

Unfortunately the FE is tied into the BE so it would be hard to launch and
use.

Trying to think of a way to share out just the form and some data to
emulate the issue.


On Fri, Mar 26, 2021 at 1:11 PM Shane Groff via AccessD <
accessd at databaseadvisors.com> wrote:

> Hey Ryan,
>
> Seems like in your original post, you left out a few details that could be
> relevant 😊
>
> If you could share a database that demonstrates the problem, I can see if
> we might be able  to fix it.
>
> Shane
>
> -----Original Message-----
> From: AccessD <accessd-bounces+shaneg=microsoft.com at databaseadvisors.com>
> On Behalf Of Ryan W
> Sent: Friday, March 26, 2021 6:54 AM
> To: Access Developers discussion and problem solving <
> accessd at databaseadvisors.com>
> Subject: [EXTERNAL] Re: [AccessD] Access lockup when using record selector
> search
>
> Well I found a workaround.
>
> In my 'fetch data" button I fill in two tables and at the end I do a
> me.refresh (to refresh the form) so that the data shows in the datasheet
> view.    Changing that to me.subreport.form.requery and
> me.subreport2.form.requery fixes the lock up issue......
>
>
>
> On Fri, Mar 26, 2021 at 8:09 AM Ryan W <wrwehler at gmail.com> wrote:
>
> > Hi Shane,
> >
> > The focus is on the parent form of the subform that locks up. Once i
> > click into the search box and try and type access crashes.  I've tried
> > a compact and repair/decompile/etc.
> >
> >
> >
> > On Fri, Mar 26, 2021 at 5:42 AM Shane Groff via AccessD <
> > accessd at databaseadvisors.com> wrote:
> >
> >> Hi Ryan,
> >>
> >> Also can't repro this with Access2013 64-bit.
> >> Can you clarify where the focus is before you click in the
> >> recordselector search/filer box?  Is it in another document? In the
> navigation pane?
> >>
> >> Shane
> >>
> >> -----Original Message-----
> >> From: AccessD
> >> <accessd-bounces+shaneg=microsoft.com at databaseadvisors.com>
> >> On Behalf Of Gustav Brock via AccessD
> >> Sent: Friday, March 26, 2021 12:49 AM
> >> To: Access Developers discussion and problem solving <
> >> accessd at databaseadvisors.com>
> >> Cc: Gustav Brock <gustav at cactus.dk>
> >> Subject: [EXTERNAL] Re: [AccessD] Access lockup when using record
> >> selector search
> >>
> >> Hi Ryan
> >>
> >> I can't replicate this.
> >> When clicking the selector, the form gets focus, and I can type in
> >> the record to find.
> >> Version 2102 (Build 13801.20360 Click and run) 64-bit.
> >>
> >> /gustav
> >>
> >> -----Oprindelig meddelelse-----
> >> Fra: AccessD <accessd-bounces+gustav=cactus.dk at databaseadvisors.com>
> >> På vegne af Ryan W
> >> Sendt: 25. marts 2021 16:10
> >> Til: accessd at databaseadvisors.com
> >> Emne: [AccessD] Access lockup when using record selector search
> >>
> >> Access2013 64 bit.
> >>
> >>
> >>
> >> When using recordselector search/filter box at the bottom of the
> >> datasheet will lock up access unless datasheet is set in focus first.
> >>
> >> Has anyone experienced this?
> >> --
> >> AccessD mailing list
> >> AccessD at databaseadvisors.com
> >>
> >> https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdat
> >> abaseadvisors.com%2Fmailman%2Flistinfo%2Faccessd&data=04%7C01%7Cs
> >> haneg%40microsoft.com%7C0322ac5dc7d54104031a08d8f05e9942%7C72f988bf86
> >> f141af91ab2d7cd011db47%7C0%7C0%7C637523636389242411%7CUnknown%7CTWFpb
> >> GZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn
> >> 0%3D%7C1000&sdata=m9gQZUHe4NJmKnm2iFAQemR5Q%2FujEkwuw4WcXSRnOgg%3
> >> D&reserved=0
> >> Website:
> >> https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.
> >> databaseadvisors.com%2F&data=04%7C01%7Cshaneg%40microsoft.com%7C0
> >> 322ac5dc7d54104031a08d8f05e9942%7C72f988bf86f141af91ab2d7cd011db47%7C
> >> 0%7C0%7C637523636389242411%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMD
> >> AiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=M%2
> >> BF1yPdtG7DlxutqdKtnPQdabo0shqIZN4zr%2FBalTRE%3D&reserved=0
> >> --
> >> AccessD mailing list
> >> AccessD at databaseadvisors.com
> >> https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdat
> >> abaseadvisors.com%2Fmailman%2Flistinfo%2Faccessd&data=04%7C01%7Cs
> >> haneg%40microsoft.com%7C0322ac5dc7d54104031a08d8f05e9942%7C72f988bf86
> >> f141af91ab2d7cd011db47%7C0%7C0%7C637523636389242411%7CUnknown%7CTWFpb
> >> GZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn
> >> 0%3D%7C1000&sdata=m9gQZUHe4NJmKnm2iFAQemR5Q%2FujEkwuw4WcXSRnOgg%3
> >> D&reserved=0
> >> Website:
> >> https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.
> >> databaseadvisors.com%2F&data=04%7C01%7Cshaneg%40microsoft.com%7C0
> >> 322ac5dc7d54104031a08d8f05e9942%7C72f988bf86f141af91ab2d7cd011db47%7C
> >> 0%7C0%7C637523636389242411%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMD
> >> AiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=M%2
> >> BF1yPdtG7DlxutqdKtnPQdabo0shqIZN4zr%2FBalTRE%3D&reserved=0
> >>
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
>
> https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdatabaseadvisors.com%2Fmailman%2Flistinfo%2Faccessd&data=04%7C01%7Cshaneg%40microsoft.com%7C0322ac5dc7d54104031a08d8f05e9942%7C72f988bf86f141af91ab2d7cd011db47%7C0%7C0%7C637523636389242411%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=m9gQZUHe4NJmKnm2iFAQemR5Q%2FujEkwuw4WcXSRnOgg%3D&reserved=0
> Website:
> https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.databaseadvisors.com%2F&data=04%7C01%7Cshaneg%40microsoft.com%7C0322ac5dc7d54104031a08d8f05e9942%7C72f988bf86f141af91ab2d7cd011db47%7C0%7C0%7C637523636389252404%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=NumodtVVRWiAA4%2FwtTK5jGX7jxj7r0BT2sTxQ6%2FJiC4%3D&reserved=0
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>