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

[Shane Groff]

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