Re: [MS_AccessPros] Tabbed forms question

 

Jim-

You don't say how many tabs you have in your current setup or how many subforms.  If you are using a Tab control and have many tabs all with subforms on them, you can start to have sluggish performance when the form opens and has to load all the subform recordsets.  If you're using a Navigation Control (2010 and later), you won't have that problem because Access loads the form recordset only when you activate the tab, but then you have to put any command buttons on the subforms loaded by the control or on the main form outside the control.

More details would allow us to help you more.

John Viescas, Author

Effective SQL

SQL Queries for Mere Mortals 

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

http://www.viescas.com/ 

(Paris, France)

On Feb 13, 2017, at 5:03 PM, 'Glenn Lloyd' argeedblu@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Jim, 

 

When necessary, I place buttons outside of the tab control. Then, if the action depends on the currently active tab I detect the active tab in the click event of the button to control a case statement.

 

Glenn

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] 
Sent: Monday, February 13, 2017 10:56 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Tabbed forms question

 

  

Hello all,

I was wondering what everyone's thoughts on tabbed forms as opposed to individual forms are? 

I have had a tabbed form for years for a department database. But I am considering changing to individual forms again. 
The reason is that sometimes adding buttons to a tab can not be added to the right tab, and then i get errors after adding a button. 

Thank You

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 (4)

---

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

.

__,_._,___