About 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),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 and many more being added every year.
Experience 25 yrs in the Software industry with 19yrs completely dedicated on more than 250 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.
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.