What can I do to speed it up?

B

Bob Vance

I have a list box on my Main form that may have 200 Names in it which has a
query in row source
But when I click on a name it wont highlight the name straight away then
takes about 15seconds to open the record , is there a faster way I can
design it to open quicker
 
B

Bob Quintal

I have a list box on my Main form that may have 200 Names in it
which has a query in row source
But when I click on a name it wont highlight the name straight
away then takes about 15seconds to open the record , is there a
faster way I can design it to open quicker
Click to expand...

How long does it take the query to run?
I'll bet it's 15 seconds.
Find ways (e.g. indexes, normalization) to speed up the query and once
that's fixed, your listbox will load faster.
 
J

John W. Vinson

I have a list box on my Main form that may have 200 Names in it which has a
query in row source
But when I click on a name it wont highlight the name straight away then
takes about 15seconds to open the record , is there a faster way I can
design it to open quicker
Click to expand...

Correct the indexing on your table, or correct the errors in your query, or
correct the errors in your code.

We can't see any of these of course.
 
B

Bob Vance

Sorry John, Dont think there is any errors but just was wondering is there
another way I could go about it, just is annoying when you select a record
it does not highlight ans takes like 15 seconds to open the record...Thanks
Bob
 
T

Tony Toews [MVP]

Bob Vance said:
I have a list box on my Main form that may have 200 Names in it which has a
query in row source
But when I click on a name it wont highlight the name straight away then
takes about 15seconds to open the record , is there a faster way I can
design it to open quicker
Click to expand...

I wonder if the number of columns specified on the listbox property sheet match the
number of fields in the query?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
A

Arvin Meyer MVP

On a decently indexed table, the time to open a form should be about a
second unless that form has lots of subforms in it with lots of data. How
long does it take to open the form without the list box?

I think, that something else is going on in your computer to cause this
problem. The first place to look is your anti-virus software, or any program
which either scans or indexes your machine.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


Bob Vance said:
Sorry John, Dont think there is any errors but just was wondering is there
another way I could go about it, just is annoying when you select a
record it does not highlight ans takes like 15 seconds to open the
record...Thanks Bob
Click to expand...
 
T

Tom Wickerath

Hi Bob,

Have you installed Service Pack 1 for Office 2007?
Perhaps this hotfix might help:

Description of the Access 2007 hotfix package (Access.msp): August 26,
2008
http://support.microsoft.com/kb/956054

The third bullet in the Introduction section includes:

"After you upgrade Access 2003 to Access 2007, operations
on existing forms have slow performance."

So, it's worth a shot to see if this hotfix might help.

Access MVP Allen Browne maintains an up-to-date listing of all hotfixes for
Access 2007. This is how I quickly located the above hotfix. Allan's page is
found here:

http://allenbrowne.com/Access2007.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________
 
B

Bob Vance

Thanks Guys, found the problem I changed the focus so when Main form opened
focus was on my ListBox, then on my other form I made the focus on my
listbox (Main form)on Close Form...........Regards Bob
 
Top