You are here:

Using MS Access/MS Access 2000 tab control multipage form

Advertisement

Expert: Manish Batola - 4/5/2009


Question
This must be a stupid question as I have not been able to find a reference to it in several weeks of searching the net. Please help. I am a nubie to access 2000 and have learned to create a multipage form using a single table and the tab control and add pages to the existing form using the tab control. The problem is that all the same controls that appear on page 1 also appear on pages 2, 3, ect., and when I try to delete these controls from page 2 or 3 they are automatically deleted from page 1 so that I can not get a blank page 2 or 3 without deleting the controls on page 1. How do I keep all the original controls on page 1 and delete them from pages 2 and 3 so I can add new controls to pages 2 and 3 yet keep only my original controls on page 1? Thank you, Neil.  

Answer
Hello Neil,

Your question just ain't stupid, its logical cause I faced the same situation in 1999. Anyway what you need to do is really simple but with patients.
The same controls LOOK like they appear on different but they are actually not pasted on the forms correct location. -
-You need to first clean up all the fields on your tab form
-On your first tab, make sure you click on it where you can see the dots on the borders of that tab area
-When u see dots which are called handles, youre sure that the tab is selected
-Call the View table fields box and drag and drop your first few fields on this selected tab
-Immediately perform a view in Form View mode and check what happens when you click on the second tab, do the fields on your first tab still appear ? If no then paste the rest of your fields on the next tabs by selecting them.

Let me know,

Best regards,
Manish Batola

Using MS Access

All Answers

Answers by Expert:

Ask Experts

Volunteer

Manish Batola

Expertise

ALL MICROSOFT ACCESS DESIGN AND Development QUESTIONS which occur in a Access Projects Lifecycle. Can offer constructive help on Designing Advanced MS-ACCESS Applications such CRM/FRM(Follow-up),HSE-Health,Safety & Environmental Applications,School Management Systems,Hotel Software, Hospital Software,Chemicals Indenting,Import/Export,MRP - Manufacturing Resource Planning, ERP - Enterprise Resource Planning, Automotive Management Systems, Business Intelligence for Oil & Gas Drilling Operations, CRM,KPI- Key Performance Indicators,HealthCare, Hospitality, Constructions, Loyalty Clubs, Call Centers, Travel & Tourism, Educational Institutions, Industrial Strength Invoicing and many more being added every year.

Experience

26+ yrs in the Software industry with 19yrs completely dedicated on more than 300 Various Access Projects from different Industry Sector[s]. I'm using Access ever since it was born.

Organizations
Worked in various multinationals catering from Aerospace, Oil & Gas etc.

Education/Credentials
-MSAP (Master in Software & Applications Programming) -BPRE (Business Process Re-engineering Engineer) -SQAE (Software Quality Assurance Engineer) -STIE (Software Testing & Inspection Engineer) -Project Engineeer (Software Development)

Past/Present Clients
Catered to various clients in the following industries • Oil & Natural Gas (BPM/CRM/Access Development) • Sales / Marketing (CRM) • Automotive (Automobile Dealers) • Logistics & Indenters (Import/Export) • HealthCare / Hospitals • Hotels 3* & 5* • Restaurants • Construction Co’s (Project Billing) • Clubs (Concept Selling) • Shoe-Chains • Solicitors/Lawyers • Call Centers • Aerospace (Preventive Maintenance) • Travel & Tourism • Computer Vendors • Manufacturing • Music Shops • Education • Data Warehousing • Health,Safety & Environmental Applications • Mud Engineering • School Management Software

©2012 About.com, a part of The New York Times Company. All rights reserved.