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
--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> 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 <no_reply@yahoogroups.com>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Wednesday, May 23, 2012 1:36 PM
> 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
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar