[AccessD] Access lockup when using record selector search

[Rocky Smolin]

IME, if I had a workaround that works, I stopped trying to figure out what
was really going on.  So you could put that focus on the datasheet in the
Load or Open event and the problem goes away?

r

On Fri, Mar 26, 2021 at 10:24 AM Ryan W <wrwehler at gmail.com> wrote:

> 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
> >>
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>