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

Charlotte,
hmm... no the form remains always open even after the dblclick..
So It could be probably better to add a requery or refresh or something as a 
last line down of the dblclick event?

thank's
/kostas


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

Are you saying they're all using the same front end rather than individual
copies?  You're setting the rowsource for the listbox in the textbox Change
event and then using the doubleclick event of the listbox to open a form
filtered on the selected listbox value, right?  Are you then closing the
form with the listbox or clearing it to free up the resources?

Charlotte


On Fri, Nov 15, 2013 at 10:05 AM, Kostas Konstantinidis 
<kost36 at otenet.gr>wrote:

> 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