Option Control to hide/show page tabs
Option Control to hide/show page tabs
I am fairly new to access databases and am teaching myself as I go along. However I have now got myself stuck!
I am creating a form where I have an option group with 7 options and a tab control with 7 pages. What I want to happen is when a user selects an option only the corresponding page tab is displayed, all the others are hidden.
I would also want the tabs hidden when opening a new record and no selection has yet been made.
Show or hide object tabs
Microsoft Office Access 2007 provides a new way to work with the tables, forms, reports, and other objects in a database. Instead of opening each object in a separate window, Access now places objects in a single pane and separates them with tabs. Tabs are the default behavior for all databases created with Office Access 2007.
In this article
* Understand tabs
* Why hide tabs?
* Show or hide object tabs without using overlapping windows
* Switch from tabs to overlapping windows
2010: How to create Multiple row for tab control?
I have a 50 page form and therefore decided to use tab control.one page for each tab. Can anyone tell me how to have the tabs on different rows instead of having them listed horizontally. I have set the "multi row" to "yes" but it still keeps showing the tabs in one row until I can't even see extra tabs I'm adding because the width of the page increaseswith every tab I add.
What I want is roughly 10 tabs per row. Is there anything else to change beside setting "multirow" to yes?
Hide each control, control group or subform?
I'm setting up a form that (depending on an option selected) will either show or hide some of the controls.
There are about 30 usable controls, ranging from option groups to text boxes and command buttons. Also a bunch of other non-usable labels, lines etc.
They will be hidden or shown in groups of roughly 1/3 of the total controls.
My question is what would be considered best practice here:
1) To set the controls in subforms
2) To group the controls and use a For Each statement based on the .tag property
3) To manually show/hide each control
I believe that (1) would be the easiest, but I once read that subforms carry a lot of overhead. (2) would probably be my second choice, but carries more code than (1). I hope nobody says (3) since I'd sure not like to code all of that.
Or, is there another, better choice?
GoToControl and Record Navigation....
I have several pages (tabs) on a Form.
On the last record of each page, I have added an OnExit Event with a GoToControl macro so that one can Tab from the last control of one page to the First control of the next page.
this works well.
However, one of the users has discovered that if the cursor is in the last box on any page (which has the GoToControl macro) and she clicks to advance the Navigation button, instead of moving to the next record (and same control), the Navigation button moves the cursor to the first control of the next page.
Does anyone know how I can get the record navigation to work correctly (to next Record) while still having the tabbing sequence working well (from last control on one page to first control on the next page)?
VB.NET How do design settings forms
I'm using Visual Studio 2010 and my software will be a Windows Forms Application. kind of like Tabs, except they're not tabs.
I have an good example from the TeamViewer software settings page. I'm interested in learning how to design forms like that in VB.NET.
How do I load a different page when you click a different setting? There are tons of software that have a kind of "tabbed" settings page, except there are no visible tabs.
I have not found any option that I know that allows you to do this in VS2010 by the use of tabs, panes or other Group Controls.
Does anyone know how to design the form like the images below and how to make it look like it's different pages/views being showed without using tabs or anything like that?
Setting Properties for Multiple Objects in a Collection or Array Simultaneously
I have a form which includes an option group and multiple controls that I would like to hide if a user selects a certain option in the option group.
The option box is called fmeKnitWovenOther. There is a label called fmeKnitWovenOtherLbl that I would like to hide when any option is selected and a number of controls I would like to hide only if the user selects option 2.
The problem is that I have set the .visible property of every control individually, but I will need to expand this form and add more controls to be hidden for the other two options. If I keep setting the .visible property for every control manually, I am going to wind up with a giant list of controls all manually set to .visible = True and .visible = False depending on theIf or ElseIf condition.
Show or Hide Tabs in Microsoft Access 2007
Access 2007 introduces the tabbed document format found in other Microsoft Office products. In some cases, you may wish to hide these tabs to change the look and feel of your database or more closely simulate the appearance of older versions of Access.
Tab Issue: Want the first tab to control the records for others
Having issues with a tabbed navigation form - I want the first tab to control the record for the others I.e. if I select a member of staff in the first tab, all the other tabs when opened will display their record.
I can get this to work in a split form with inserted tabs but not on a plain horizontal tabs navigation page.
Establish tab order between objects in tab control pages
In Access 2003/XP/2000/97, I have a form with a main tab box (created with a tab control) with four tabs on it and each tab has a number of text boxes on it. I have indexed these tabs so when the user tabs across, it goes from one tab page to another. However when it reaches the last text box on a particular tab instead of going to the next tab, it goes to the next record.
How can i hide tab items again after it loses focus?
I have created a form which contains a tabbed control with 3 tabs (Start, User 1 and User 2)
I have added a password protect code to the tabs (User 1 and User 2) so that when clicked, the user is prompted for a password.
I have created the user input as a string and have hidden the tab content by using a tag on each item and the visible command. the content remains hidden and returns to the start tab.
If the correct password is entered, the items with the specified tag become visible.
Its only a very basic password protection and isn't protecting vital content but I have a problem I would like to fix.
This is the issue.
If I select the user 1 tab and enter the password correctly, then I click the user 2 tab and enter the password correctly THEN click the User 1 tab again.I am prompted again for thepassword (which is fine), but all the items on the tab are still visible.
I want to be able to re-hide the tab items when it loses focus so if I switch back to the tab, it is clear. I am unsure on how to do this.
The code is entered on the OnChange Property of the tabset.
Another option I was thinking of was to hide the other user tabs when the password is entered correctly on the selected tab. Not sure how to do that either.
Which type of Form layout is recommended?
I have been working on this project for this guy.
One of the forms I'm working on is linked between three different tables. One option is to have buttons that can be clicked that will take you to different details of each prospect (thus opening up another form) and the other option is to use tabs to enter details of each prospect. Pictures below.
Option 1: The use of buttons. Another form will open up with a click of a button. The button "Stats" at the bottom was clicked and opened up the formStat.
Option 2: The use to tabs. No form opens up with each click. The form is unprintable however, since tabs are being used.
Which option would you recommend or do you prefer? Buttons or tabs.
Hide or Unhide Fields in Query using VB
Is it possible, using VB, to create a show/hide control for a query similar to its show box?. This query will be exported to Excel, so, a Form control is not a solution
Is it possible to put a tab control onto a particular page of another tab control, similar to a subform. I'm trying but it just shows up across all of the main tabs. It isn't pasting to the particular page I want it to
Form with tabs
Form frmEntry data source is qryReports. The header has fields from qryReports. I have a page tab control in the detail section. Four of the tabs have control fields from qryReports.
The fifth tab has a subform linked by reportNum. As soon as the subform is entered, I lose the data I have put in the main form and the other tabs.
Big form with 5 tabbed control 1 tab via 1 table and the other tabs via another table
I have a form with a 5 tabs in it via tab control, 4 of the tabs are based on one table and one of the tabs is based on another table. The two tables share a unique key, both named 'ID' that allow me to join the data from both tables successfully.
I have been trying everything to attempt to synch the 'ID' on the first table (the 4 tabs of data) with the 'ID' on the second table (the 1 tab of data) together so that the one tab will always and only show data that goes with the primary table (the 4 tabs).
I have tried to use filter on the form and it doesn't work or render an error.
There will always be exactly a 1-to-1 relationship between the two tables.
tabs not viewable
I created a form with 6 tabs across the top of the page. One of my users is not able to see the tabs even though everyone else is able to. When she opens a report then goes back, she can see the tabs temporarily, but this isn't a reliable method. Does anyone have any thoughts on why this is occuring with her computer only, and what I can do to resolve the issue in a way that doesn't affect everyone else
Hide tab macro
I'm (trying to) create an access database containing a form with multiple tabs. My objective is to make a button with a module that will hide (make not visible or disable) one of the tabs if a combobox has a specific value. Essentially, I want to hide the tab 'qA' if the combobox has a value of 'AA'. The problem appears to be referring to the correct tab within the form. I've been trying to do this for a couple of hours and have been through many error messages
Scrolling a tab page
Is it possible to have scrolling capability within a tab page on a form?
Currently I have a form with tab control. There are 7 tabs and the 7th tab has a long list of check boxes that wont fit inside the area I set aside for the tab control box. When I place the check boxes into the tab page, the page automatically re-sizes to contain all the new check-boxes. I am not able to re-size the tab page. Are there any settings that will allow me to re-size the tab page to contain all the check-boxes and scroll to view them all?
It seems like it should be easy and straightforward. right?
Tab Control "Visible" Property
I'm trying to get this working, however, being very inexperienced, can't make it work. I basically have several tabs, which some I want to hide depending on the value of "fkProcessID", i.e.//
Private Sub Form_Load()
If Me!fkProcessID = 23 Then
frmSample!TabCtl206.Page(1).Visible = True
frmSample!TabCtl206.Page(1).Visible = False
If Me!fkProcessID = 28 Then
frmSample!TabCtl206.Page(2).Visible = True
frmSample!TabCtl206.Page(2).Visible = False