Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 25th, 2007, 09:31 AM
Friend of Wrox
 
Join Date: Jun 2005
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default Refreshing Forms

Hi All
I have a main form which I have put a sub form which has a list box. The sub form is refreshed every minute to update the listbox with current information. The problem is there are other forms on the same database.
In these forms they send e-mails of templates. Since I began refreshing the sub form on the main form the e-mail from time to time freeze. What can I do to stop this happening
Thanks

Brendan Bartley
__________________
Brendan Bartley
 
Old June 26th, 2007, 03:22 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Have tried refreshing ONLY the row source of the listbox instead of the source object of the whole subform? Perhaps it's tying up your resources to do the latter.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old June 27th, 2007, 03:55 AM
Friend of Wrox
 
Join Date: Mar 2007
Posts: 432
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi Brendan,

Sounds like Serrano is right, the system has its resources tied up processing the ListBox refresh. This
is due to the Single-threaded nature of VB/VBA.

Couple few questions:
  • Is this all on a single machine - accessed by a single user?
  • How is the ListBox linked to the data?
  • How are you performing the refresh?
Best Regards,
Rob

 
Old June 27th, 2007, 05:32 AM
Friend of Wrox
 
Join Date: Jun 2005
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The DB is on a server accessed by 10 users
The listbox is on the main form. Holds current issues for the end users to be aware of during the day.
I was updating it by timer function every 5 min.
The problem is that the forms on this DB are completed by end user and e-mailed . The timer function at certain times froze the e-mail and the form.
Thanks

Brendan Bartley
 
Old June 27th, 2007, 07:19 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Quote:
quote:Originally posted by robzyc
Sounds like Serrano is right, the system has its resources tied up processing the ListBox refresh. This
is due to the Single-threaded nature of VB/VBA.
Well, no, that's not what I said. I suggested that Brendan refresh ONLY the listbox row source instead of the whole subform source object. It'd mean less data to update. So...

So not

Me.MySubForm.Form.Requery

It'd be more like

Me.MySubForm.Form.MyListBox.Requery


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old June 27th, 2007, 07:47 AM
Friend of Wrox
 
Join Date: Jun 2005
Posts: 181
Thanks: 0
Thanked 0 Times in 0 Posts
Default

That fine it updates the sub form in my main form of the DB but does not update anyone elese on the network main form
Thanks

Brendan Bartley





Similar Threads
Thread Thread Starter Forum Replies Last Post
Refreshing a Gridview takwirira ASP.NET 2.0 Basics 1 January 9th, 2008 01:13 AM
refreshing XML withour refreshing the page sasidhar79 XML 1 January 12th, 2005 05:16 AM
Refreshing Datagrids Louisa VB.NET 2002/2003 Basics 13 May 11th, 2004 09:17 AM
refreshing data hellosweetone Classic ASP Basics 1 August 15th, 2003 12:32 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.