[AccessD] Access lockup when using record selector search

Ryan W wrwehler at gmail.com
Fri Mar 26 08:53:40 CDT 2021


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%2Fdatabaseadvisors.com%2Fmailman%2Flistinfo%2Faccessd&data=04%7C01%7Cshaneg%40microsoft.com%7C77e5b23c734f41b1376008d8f02ba203%7C72f988bf86f141af91ab2d7cd011db47%7C0%7C0%7C637523417495526889%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=jfVZ61aa2NQV2HylCNSEsyxeMDgVkMaCYaSlu1iQ0QI%3D&reserved=0
>> Website:
>> https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.databaseadvisors.com%2F&data=04%7C01%7Cshaneg%40microsoft.com%7C77e5b23c734f41b1376008d8f02ba203%7C72f988bf86f141af91ab2d7cd011db47%7C0%7C0%7C637523417495526889%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=o%2BvISy8Q4jlvF8kBGlz712DvZAoU40XvbC%2B9uPF1MBU%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