Re: [MS_AccessPros] Look up tables

 

Jim-

You should consider converting the macro to a VBA function, then come back here for help to make it run faster.  The fact that it runs slowly tells me you're better off suffering the overhead once when the app opens rather than use direct links to the People Soft data.  The data will load much faster from local tables, particularly if they're static tables (not Make Table) with proper indexes.  Perhaps also change the opening form to one that displays a "Loading remote data - please wait" message that then loads the actual main form after the data gets loaded.

John Viescas, author

Effective SQL

SQL Queries for Mere Mortals

Microsoft Office Access 2010 Inside Out

Microsoft Office Access 2007 Inside Out

Building Access Applications

http://www.viescas.com/

On Aug 23, 2016, at 07:49, luvmymelody@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Follow up question,

My boss has retired and I have inherited one of the databases they worked on. It is really slow when the database opens because of a macro that runs 15 queries on load of the opening form. most of them are queries that create lookup tables from various downloaded tables from PeopleSoft every morning. These are not like the local lookup tables I described before but created every time the form opens. It is a silly situation. These tables that are created are for drop downs on the forms in the database.

So I am thinking that I could get rid of these queries by using select statements on the row source instead of creating tables every time the form is open. Not very efficient I think.

What is the groups thoughts on using select statements for the row source which are essentially the same thing as the make table queries run in the macro.

Thank you for your advice

Jim Wagner

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (12)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___