[AccessD] Access lockup when using record selector search

[Ryan W]

Not practical at all, sadly.  Back end is pretty large.


this should be relatively easy to replicate.

Form and Subform

Main form has fields/combo boxes to create criteria, button "Get Data" runs
the DoCmd.RunSQL commands with the dynamic query/query string into the
table that backs the subform datasheet view. click the search in the
"navigation bar" and type and see if it locks up.

If it locks up, add me.subdatasheetname.form.requery at the end of the "Get
data" logic and try again.




On Fri, Mar 26, 2021 at 12:23 PM Rocky Smolin <rockysmolin2 at gmail.com>
wrote:

> Next move would be to send the front and back ends to one or more of us to
> test on our machines.  Is that practical?
>
> r
>
> On Fri, Mar 26, 2021 at 10:16 AM 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
> > > > >
> > seadvisors.com <http://www.databaseadvisors.com>
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>