I have this strange situation. When capturing data, the capture form seems to "slow down to a stand still" almost, should one stop capturing for a few minutes. I then close the application and everything is back to normal, unless the data capturer takes a break. Is this a Windows 7 related issue, or Access taking a "power nap"?
Any Suggestions about his strange behavior when it shows calculating at the bottom of the screen?
6 1336 zmbd 5,501
Expert Mod 4TB
ZMBD, its a form with various dlookups and a subform. I just want to inquire if its a common problem on a busy form/subform with a table of about 200 000 row. The subform does not show the records on opening.
I have an idea that the 4 dlookups calculating stocklevels in the background using queries, after adding an item to the subform,are the cause. Would it help to disable these dlookups after completing a record and the enabling them when adding a new one?
The only "error" is is it shows is "calculating" at the botton of the screen.
zmbd 5,501
Expert Mod 4TB
You're going to have to provide more detail...
How are the dlookups "running" in the background when there's no active code?
I have functions in unbound controls on subforms; however, these are only ran when they become visible and I've never had a slowdown that anyone has noticed. This however, may not be how you are "running" your dlookups and/or other code SQL... there maybe something that needs a doevents to allow the system to clear, or a ton of other issues... you've simply not supplied enough information to help.
NeoPa 32,556
Expert Mod 16PB
It's really hardly possible to comment when most of the information about your actual problem is not shared, but only referred to obliquely.
Using Domain Aggregate functions (DLookup() etc) is generally likely to cause poor performance as every call requires a recordset to be initialised and executed. As we know so little in the way of details of what's actuially going on though, even that part is only guesswork.
Sorry have been away for a few days. I seem to have improved the speed issue drastically with the dlookups by using enabled=false on loading the form, then enabled=true in the click event of the first field in the subform row , and setting enabled= false in the last field of the row again for 6x dlookups. - [Forms]![orderf]![StockIn].Enabled = True
-
[Forms]![orderf]![StockIn].Enabled = False
-
zmbd 5,501
Expert Mod 4TB GUESSING HERE
You have the dlookup() in the "control source" property of a control within the details section of the form. I F F this is the case, then what Neopa stated in his post is starting to catch up with you and a shortcut on the form.... now I do use this construct myself; however, only for a limited return of records, say a dozen or so at the most; however, for thousands, I would most likely not use this and try to find a better method for the reason Neopa states. Sign in to post your reply or Sign up for a free account.
Similar topics
by: mark |
last post by:
I'm trying to make a drop down menu, when you select a few options I want it
to do *nothing* at all, null. The following works perfectly in IE6, but it
doesn't seem to worm in Opera 6 and IE5. When...
|
by: Gerald Khin |
last post by:
I encountered a performance problem with UPDATE statement and foreign
key constraints.
There are two tables involved: A parent table A and a child table B:
create table A(
ID CHAR(15) NOT...
|
by: cow3 |
last post by:
Is there anyone who can help me with this:
I have written a fairly complicated vb application of hydrological
model that does a lot of number crunching. The model creates a set of
object...
|
by: Paul_Madden via DotNetMonster.com |
last post by:
Basically I have a listbox to which I add simple STRING items- I have a
progress bar which I increment whenever I populate another portion of the
complete set of items I wish to add. What I observe...
|
by: Jose Walker |
last post by:
Hi there,
I've an ASP.NET 2 web application that I want to publish, but it happened
that the application slows down in performance compared with the version
managed by VS.NET 2005.
When the...
|
by: =?Utf-8?B?aXdkdTE1?= |
last post by:
hi, im attempting to create an intellisense type form and have hit a
roadblock. I need the form to return (like the ShowDialog method returns the
dialog result) the value that was selected when the...
|
by: kimiraikkonen |
last post by:
Hi,
I noticed that if i view some jpeg files via Picturebox control (.net
2.0) placed in to a single form, while dragging the form around the
screen, then the form slutters, dragging slows down...
|
by: Hansel Haycox |
last post by:
In access 2007, I created a query. I used the query and an additional table to create the form using Wizard. Yet, when I open the form, I am unable to edit existing records or add new records. I...
|
by: Brad Younie |
last post by:
I have a DLL assembly that my customers can use as a reference. I also have a Windows Service that they can use to access the same DLL on a different machine (or in another process) via .Net...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |