[AccessD] Access lockup when using record selector search

Ryan W wrwehler at gmail.com
Fri Mar 26 12:24:21 CDT 2021


Ok checking another staffers machine, same thing.  So this seems to be a
bug in Access or something along those lines.

If I focus into the datasheet view BEFORE using the search in the
"Navigation bar" (what I was calling recordselector bar) it does not crash
out.  Likewise if you do a me.subform.form.requery in VBA (in my case, at
the end of the button_Click event, it's fixed "permanently".  Perhaps even
though the dataset is viewable, for some reason it's not fully loaded
without the .requery ?


On Fri, Mar 26, 2021 at 12:16 PM Ryan W <wrwehler at gmail.com> wrote:

> Access 2013.
>
> 15.0.5267.1000  which is the latest patch/release for Office 2013.
>
> I'll test on another machine, but after suspect others do it as well.
>
>
> On Fri, Mar 26, 2021 at 11:50 AM Rocky Smolin <rockysmolin2 at gmail.com>
> wrote:
>
>> Aha, I see. If it works on other machines but not yours, then I think you
>> can eliminate your code and form. It's unusual - I've neve seen that.
>> Reinstall Office and get all the updates?
>>
>> What version of Office is it?
>>
>> r
>>
>> On Fri, Mar 26, 2021 at 8:52 AM Ryan W <wrwehler at gmail.com> wrote:
>>
>> > Yeah but I'm talking about the bar at th bottom of the datasheet (the
>> > recordselector bar), not the grey box to the left of the data in a
>> > datasheet view, if that makes sense.
>> >
>> > This image here calls it a navigation bar:
>> >
>> >
>> >
>> https://www.jegsworks.com/lessons/databases-2/basics/starwars-table-datasheet-labeled-2010.png
>> >
>> >
>> >
>> > On Fri, Mar 26, 2021 at 10:49 AM Rocky Smolin <rockysmolin2 at gmail.com>
>> > wrote:
>> >
>> > > When a record is selected the OnCurrent event is triggered.
>> > >
>> > > r
>> > >
>> > > On Fri, Mar 26, 2021 at 6:07 AM Ryan W <wrwehler at gmail.com> wrote:
>> > >
>> > > > I'm not sure if there's an event I can set for the recordselector
>> > that's
>> > > > built into access, is there?
>> > > >
>> > > >
>> > > > On Thu, Mar 25, 2021 at 9:59 PM Rocky Smolin <
>> rockysmolin2 at gmail.com>
>> > > > wrote:
>> > > >
>> > > > > On the click event of the search box can you set focus to the
>> > datasheet
>> > > > to
>> > > > > work around this idiosyncrasy?
>> > > > >
>> > > > >
>> > > > > r
>> > > > >
>> > > > > On Thu, Mar 25, 2021 at 7:10 PM Ryan W <wrwehler at gmail.com>
>> wrote:
>> > > > >
>> > > > > > Exactly. You click the box to search, which you think would
>> focus
>> > on
>> > > > the
>> > > > > > datasheet but it causes access to lock up.
>> > > > > >
>> > > > > > But if you purposefully click on the datasheet data and then
>> click
>> > > down
>> > > > > to
>> > > > > > the search in the record selector bar everything is happy.
>> > > > > >
>> > > > > > Sent from my iPhone
>> > > > > >
>> > > > > > > On Mar 25, 2021, at 8:58 PM, Stuart McLachlan <
>> > > > stuart at lexacorp.com.pg>
>> > > > > > wrote:
>> > > > > > >
>> > > > > > > I don't understand.
>> > > > > > > How do you use the search/fitler box without clicking in it
>> which
>> > > > sets
>> > > > > > focus to the datasheet?
>> > > > > > >
>> > > > > > > Can you explain exactly what you are doing?
>> > > > > > >
>> > > > > > >> On 25 Mar 2021 at 10:09, Ryan W wrote:
>> > > > > > >>
>> > > > > > >> 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?
>> > > > > > >>
>> > > > > > >>
>> > > > > > >>
>> > > > > > >> Sent from my iPhone
>> > > > > > >> --
>> > > > > > >> AccessD mailing list
>> > > > > > >> AccessD at databaseadvisors.com
>> > > > > > >> https://databaseadvisors.com/mailman/listinfo/accessd
>> > > > > > >> Website: http://www.databaseadvisors.com
>> > > > > > >>
>> > > > > > >
>> > > > > > >
>> > > > > > > --
>> > > > > > > AccessD mailing list
>> > > > > > > AccessD at databaseadvisors.com
>> > > > > > > https://databaseadvisors.com/mailman/listinfo/accessd
>> > > > > > > Website: http://www.databaseadvisors.com
>> > > > > > --
>> > > > > > AccessD mailing list
>> > > > > > AccessD at databaseadvisors.com
>> > > > > > https://databaseadvisors.com/mailman/listinfo/accessd
>> > > > > > Website: http://www.databaseadvisors.com
>> > > > > >
>> > > > > --
>> > > > > AccessD mailing list
>> > > > > AccessD at databaseadvisors.com
>> > > > > https://databaseadvisors.com/mailman/listinfo/accessd
>> > > > > Website: http://www.databaseadvisors.com
>> > > > >
>> > > > --
>> > > > AccessD mailing list
>> > > > AccessD at databaseadvisors.com
>> > > > https://databaseadvisors.com/mailman/listinfo/accessd
>> > > > Website: http://www.databaseadvisors.com
>> > > >
>> > > --
>> > > AccessD mailing list
>> > > AccessD at databaseadvisors.com
>> > > https://databaseadvisors.com/mailman/listinfo/accessd
>> > > Website: http://www.databaseadvisors.com
>> > >
>> > --
>> > AccessD mailing list
>> > AccessD at databaseadvisors.com
>> > https://databaseadvisors.com/mailman/listinfo/accessd
>> > Website: http://www.databaseadvisors.com
>> >
>> --
>> 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