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

[Ryan Wehler]

Thanks again Shane!

I’ll work on this some more Monday...  glad we could reproduce it for an eventual fix, at least with 365.



> On Mar 26, 2021, at 11:36 PM, Shane Groff via AccessD <accessd at databaseadvisors.com> wrote:
> 
> The reason setting AllowAdditions to true makes a difference is that when it is set to true, then when the subform is first opened it has a single 'record' (the blank new record)
> If it is set to false, then since the subform has no other records, so no records are displayed (and there is nowhere valid to put the focus in the form).
> 
> Getting the form open with no place to put the focus is one of the necessary conditions to hit this bug.
> 
> I will open an issue to track this.  As always it is more likely we will fix a bug in Microsoft365, then it is that we will fix it in Access 2013 (or any of the perpetual license versions).
> 
> Thanks for providing a repro case Ryan.
> 
> Shane
> 
> -----Original Message-----
> From: AccessD <accessd-bounces+shaneg=microsoft.com at databaseadvisors.com> On Behalf Of Ryan W
> Sent: Friday, March 26, 2021 3:51 PM
> To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
> Subject: [EXTERNAL] Re: [AccessD] Access lockup when using record selector search
> 
> This still doesn’t explain why .allowadditions = true or .allowdeletions = true seems to remedy the .refresh glitch without a requery...  very odd indeed.  
> 
> The underlying data isn’t changing on this form as the tables are local to the user and not linked to the back end.  
> 
> Since you’ve seen the mock code that’s basically happening on my real FE. Moving data from BE to local table for processing. 
> 
> 
> Sent from my iPhone
> 
>> On Mar 26, 2021, at 5:45 PM, Stuart McLachlan <stuart at lexacorp.com.pg> wrote:
>> 
>> Refresh method
>> Use the Refresh method to immediately update the records in the 
>> underlying record source for a specified form or datasheet to reflect 
>> changes made to the data by you and other users in a multiuser 
>> environment. The Refresh method shows only changes that have been made 
>> to the current set of records; it doesn't reflect new records or deleted records in the record source.
>> 
>> Requery method
>> Use the Requery method to update the data underlying a form or control 
>> to reflect records that are new to or have been deleted from the record source since it was last requeried.
>> If you want to requery a control that isn't on the active object, you 
>> must use this method, not the Requery action or its corresponding DoCmd.Requery method.
>> 
>> 
>>>> On 27 Mar 2021 at 8:40, Stuart McLachlan wrote:
>>> 
>>> There is a lot of confusion between Refresh and Requery.
>>> 
>> 
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> https://nam06.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdata
>> baseadvisors.com%2Fmailman%2Flistinfo%2Faccessd&data=04%7C01%7Csha
>> neg%40microsoft.com%7C892a1d206ceb4d92b79008d8f0a9a336%7C72f988bf86f14
>> 1af91ab2d7cd011db47%7C0%7C0%7C637523958678051883%7CUnknown%7CTWFpbGZsb
>> 3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%
>> 7C1000&sdata=y8RM97EVyey4LUv%2BOxgJMz3CFDCgxyaJgnNYQ9xaDhY%3D&
>> reserved=0
>> Website: 
>> https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.d
>> atabaseadvisors.com%2F&data=04%7C01%7Cshaneg%40microsoft.com%7C892
>> a1d206ceb4d92b79008d8f0a9a336%7C72f988bf86f141af91ab2d7cd011db47%7C0%7
>> C0%7C637523958678051883%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLC
>> JQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=ZMMMnrNf
>> jyguXAgGMyDG3j68AE5zjo9ngOS4o7P6UUo%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%7C892a1d206ceb4d92b79008d8f0a9a336%7C72f988bf86f141af91ab2d7cd011db47%7C0%7C0%7C637523958678051883%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=y8RM97EVyey4LUv%2BOxgJMz3CFDCgxyaJgnNYQ9xaDhY%3D&reserved=0
> Website: https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.databaseadvisors.com%2F&data=04%7C01%7Cshaneg%40microsoft.com%7C892a1d206ceb4d92b79008d8f0a9a336%7C72f988bf86f141af91ab2d7cd011db47%7C0%7C0%7C637523958678051883%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=ZMMMnrNfjyguXAgGMyDG3j68AE5zjo9ngOS4o7P6UUo%3D&reserved=0
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com