[AccessD] problem of a listbox's response on network...

Anita,
I'll try your own method too because ultimately it is very frustrating to 
the user to type a letter waiting more than 10 seconds to get the return 
filtered values
thank's for your reply.
/kostas

-----Original Message----- 
From: Anita Smith
Sent: Saturday, November 16, 2013 3:12 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] problem of a listbox's response on network...

Kostas,
I use this method on a regular basis except for two steps:

I have a second text box that receives the characters the user types in the 
search text box. I call it txtFindIt and I use this field as a criteria 
rather that the field they type in.

On change of txtSearch I fire the following:

Me.txtFindIt = Me.txtSearch.Text
Me.MyListBox.Requery

Instead of concocting the rowsource for the list box on the fly I use a 
query instead.
My list box has a permanent rowsource and I put the following criteria in 
the field I want to search on.

Like "*" & [Forms]![frmMyForm]![txtFindIt] & "*"

It may sound confusing but it is really very simple and have worked with 
many concurrent users so far. I can't remember why I do it this way but I 
think it has something to do with a problem using the textbox that the users 
type into as the criteria and using the OnChange event - anyhow my method 
works a treat.

Anita Smith


-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kostas 
Konstantinidis
Sent: Saturday, 16 November 2013 5:06 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] problem of a listbox's response on network...

hi to all,
I am working on a mdb file (office 2010) under linked tables from another 
database which is installed on a home network (workgroup 192.168.0.xx) For 
quick searching on basics fields (name, year born etc) every user on the 
network is working with a deigned form including an unbound list box

on a text unbound
Private Sub text_box_Change()
Me![list2].RowSource = "SELECT [AM], [Last_name], [First_name], 
[Father_name], [year_born] FROM [q_start_list] WHERE [Last_first_name]like 
'" & Me![text_box].Text & "*'"
End Sub

on a button
Private Sub list2_DblClick(Cancel As Integer)
    Dim stDocName As String
    Dim stLinkCriteria As String
    stDocName = "MT_basic_char"
    stLinkCriteria = "[AM] = " & Me!list2.Value & ""
    DoCmd.OpenForm stDocName, , , stLinkCriteria End Sub

what it happens... if only one person is connected working on the listbox 
there is no problem at all while the response returns on the spot But when 
more than one try to work on the same listbox the response is ridiculously 
slow...

Is there any idea about which is the reason it happens?

thank’s in advance
/kostas

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com