Rabu, 30 Mei 2012

[MS_AccessPros] Re: Filter form box slow

 

Thanks Bill! Good to have the confirmation and some more info to help me understand. Really appreciate this board--THANKS!!! Connie

--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> Connie -
>
> I think you figured it out. When an Access db is being backed up the backer-upper has to stop and start over if something changes in the database. I have QuikSync to back up mine every hour during development and sometimes I just have to stop working until it is finished.
>
> That calculating and querying stuff is happening because of your typing. Normally, those messages don't show but if there is heavy CPU usage from, say, a backup utility, Access can't grab all the resources it needs so it bogs down.
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile/Bill.Mosca
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com, mrsgoudge <no_reply@> wrote:
> >
> > Hi Crystal,
> >
> > Hope you're having a great day!
> >
> > Since putting the db online would mean it would take a chunk of time to alter the data for confidentiality, I've been trying to noodle this out. I am willing to do the work to alter and put it online but thought perhaps I could gather more data.
> >
> > When typing in the same info the typing will pause in different spots. Sometimes the 2nd spot, sometimes the 8th spot, etc. I noticed that Cobian backup was running so I turned it off. Since then I can't duplicate the problem. I would think that's been the problem except for the following.
> >
> > I noticed before turning Cobian off, that when the pause would happen there would often be a message in Access (on the bottom) that it was calculating or that a query was running. As far as I know there's no reason for a query to run in the middle of entering the address. The Events for that combo are:
> > BeforeUpdate, AfterUpdate, and NotInList. The Events for the form are OnCurrent, AfterUpdate, OnLostFocus and OnClose.
> >
> > I just decided to run Cobian again in the background and encountered the problem a couple of times but now it's not there. Perhaps it finally backed up the Access db I was working on?
> >
> > Connie
> >
> > --- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@> wrote:
> > >
> > > Hi Connie,
> > >
> > > > "When I type in the box it usually pauses after two or three characters "
> > >
> > > How long are the fields allowed to be?� Others say that setting to 255 doesn't matter till you use the characters but my experience shows me otherwise.� Knock the field sizes down.
> > >
> > >
> > > is there a CHANGE event?� If not, would you post a sample database and specify what to look at?
> > >
> > >
> > > Warm Regards,
> > > Crystal
> > >
> > > �*
> > > �� (: have an awesome day :)
> > > �*
> > >
> > >
> > >
> > > ________________________________
> > > From: mrsgoudge
> > >
> > > Crystal,
> > > Any other ideas?� I tried it and it's still stalling.� I put an index (AddressCity) on the combination of StreetComb and City with both of them marked Ascending.� When I click on StreetComb and City in Design mode, they are both marked as Duplicates OK. Then changed the OrderBy of the SQL to what you said.�
> > >
> > > I'm afraid that it will get worse as more data is added.� We currently have about 450 listings in the database and they are all in this drop down box and as more are added it will grow.� Is this okay?
> > >
> > > Thanks again!
> > > Connie
> > >
> > > --- Crystal� wrote:
> > > >
> > > > Hi Connie,
> > > >
> > > > put an Index on the combination of these 2 fields in the HomeInfo table design:
> > > >
> > > >
> > > > click on the lightening bolt icon to open the Indexes window
> > > >
> > > > IndexName = StreetCity (first column -- this can be whatever you want, within reason ;)
> > > >
> > > > - StreetComb
> > > > - City
> > > >
> > > > To get an entry in the window, for the Indexes property of StreetComb, in the lower pane, choose --> Yes (duplicates ok)
> > > > then, on the next row in the indexes window, in the 2nd column for field, drop the combo and choose --> City
> > > >
> > > > then an index will be built, which will make sorting faster.
> > > >
> > > > Then, in the SQL --> ORDER BY [StreetComb] & [City]
> > > >
> > > >
> > > > Warm Regards,
> > > > Crystal
> > > >
> > > > �*
> > > > �� (: have an awesome day :)
> > > > �*
> > > >
> > > >
> > > >
> > > > ________________________________
> > > >� From: mrsgoudge
> > > > Subject: [MS_AccessPros] Re: Filter form box slow
> > > >�
> > > > Sorry--the subject should have been "Slow combobox"
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com, mrsgoudge <no_reply@> wrote:
> > > > >
> > > > > Hi all!
> > > > >
> > > > > I have a form Listings with a combo box HomeInfoID.� When I type in the box it usually pauses after two or three characters which is frustrating because you're typing away and most of the typing is for naught and then you need to wait to be able to type the rest.� Any input is really appreciate as it's bugging my users (myself included :-(.
> > > > >
> > > > > The code behind the box has BeforeUpdate, AfterUpdate and NotInList events.� Control Source is HomeInfoID.� The Row Source is :
> > > > > SELECT HomeInfo.HomeInfoID, [StreetComb] & " " & ", " & [City] AS AddressCity, HomeInfo.ParcelNbr
> > > > > FROM HomeInfo
> > > > > ORDER BY [StreetComb] & " " & ", " & [City];
> > > > >
> > > > > StreetComb is indexed.
> > > > >
> > > > > I don't think the following affects the results but just in case:
> > > > > There are three comboboxes with HomeInfoID as their control source.� The user needs to enter either the address, parcel number or homeid.� There is always a homeid but that is impractical for entry.� The address is the best way to enter but there is not always an address.� Parcel number is the second most practical way to enter but there is not always a parcel number.
> > > > >
> > > > > Thanks,
> > > > > Connie
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar