Avatar of APD Toronto
APD Toronto
Flag for Canada asked on

Custom Access application slow

Hello Experts,

15 months ago I wrote an Access application and the details screen is pretty detailed and during these 15 months I uppgraded and upgraded. The detail code is now 2261 lines and it takes around 8 second to load, which my client says that it is way to long. I know that if I rewrote this code it will probably half or less, but if there is less time consuming solution?

I have already run compact and repair and compile.


Any advice?
Microsoft AccessVisual Basic Classic

Avatar of undefined
Last Comment
APD Toronto

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
raysonlee

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
pancholefty

I don't know if this will work for your situation but it's worth looking at. I've used this software on my VB projects for many years with excellent results. It says it works with VBA but I haven't tried it with an Access app.

http://www.aivosto.com/index.html

No points -- just a thought
APD Toronto

ASKER
I will try your suggestions, but it takes 8 seconds to open one record and they open a lot of records everyday.

I think I will also look at the form load event, but is there any format to document on paper in plain English what that code is doing, so I have it for my record?
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
APD Toronto

ASKER
Thank you all for your suggestions.

Appearantly, after upgrading from Access 2003 to 2007, the load time reduced from 8s to 4s.  I doubt tht this is a permanent fix, but I will revisit this once it becomes a problem again :)
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy