Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / February 2006

Tip: Looking for answers? Try searching our database.

MS Access Form w Tabs

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ghadley_00@yahoo.com - 02 Feb 2006 13:21 GMT
I have an MS Access Database with multiple forms that all update fields
in a single table because I can't fit all the required fields onto a
single screen. I have looked into converting these multiple forms into
a single form with subforms as tabs  but to date my attempts to do this
have failed. Can any one give a pointer to an example / instructions on
how to create a tabbed form?

The form that I have created contains each of my current forms a
different tabs, however when I choose tab 2, it shows the contents of
both tab 1 and tab2 at the same time (making an incomprehensible
eyesore).

Any help that could be provided would be greatly appreciated.

Best wishes,

George Hadley
ghadley_00@yahoo.com
John Spencer - 02 Feb 2006 13:39 GMT
If the data is all in one table, then you don't want to use subforms on the
tabs.  You would probably end up with record-locking conflicts.

You do want to use a tab control to group the data into screens

Your current problem is that your have no controls on tab 1, they are on the
main form.  SELECT all the controls that you see when you are viewing tab 1.

Cut them,
click on the tab 1 header
You should see 6 handles appear in the tab control (6 small squares)
Paste the controls you have cut.   They should now be on page 1 of the tab
control
Flip to page 2 of the tab and check.

The trick is to make sure atab page has the focus when you add controls.  If
you don't, then the controls get added to the form instead of to the tab
control on the form.

>I have an MS Access Database with multiple forms that all update fields
> in a single table because I can't fit all the required fields onto a
[quoted text clipped - 14 lines]
> George Hadley
> ghadley_00@yahoo.com
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.