f



How to color tab of tab control when content of tab meets generic criteria

I have an MS Access form that uses a tab control with multiple tabs.
On each tab, there are various fields.

How can I color-- or if easier add some simple icon--to a particular
tab (say tab 2 of 5 in the tab control) if a field on tab 2 meets some
generic criteria like salary field is > 50000. I'm trying to give the
operator a visual cue that tab 2 contains important data that should
be reviewed--so the operator does not have to visit each tab to
manually inspect all fields (which may contain only nominal values).
If I could color tab #2 red or mark just tab #2 with an icon, then the
operator would know to navigate to tab #2 specifically.

Please include all VB/code and tell me which event to use/how to
attach.

Thanks Access gurus.
0
gastross (1)
9/3/2004 1:32:00 AM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

1 Replies
607 Views

Similar Articles

[PageSpeed] 32

You could create a Bitmap that you would set as the Picture property of
the desired TAB Page.
Perhaps using the form's Current event you could do something like:

If Me.txtSalary >50000 then me.TabControlName.Pages(0).Picture =
"C:\LookAtMe.bmp"
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Scot Balfour" <gastross@aol.com> wrote in message
news:72cecde9.0409021732.1d13fa9a@posting.google.com...
> I have an MS Access form that uses a tab control with multiple tabs.
> On each tab, there are various fields.
>
> How can I color-- or if easier add some simple icon--to a particular
> tab (say tab 2 of 5 in the tab control) if a field on tab 2 meets some
> generic criteria like salary field is > 50000. I'm trying to give the
> operator a visual cue that tab 2 contains important data that should
> be reviewed--so the operator does not have to visit each tab to
> manually inspect all fields (which may contain only nominal values).
> If I could color tab #2 red or mark just tab #2 with an icon, then the
> operator would know to navigate to tab #2 specifically.
>
> Please include all VB/code and tell me which event to use/how to
> attach.
>
> Thanks Access gurus.

0
9/3/2004 5:45:12 AM
Reply:

Similar Artilces:

Tab control in one of the tabs of another tab control
One of my colleagues is working with a tab control. He has several tabs. He is trying to embed another tab control inside one of the tabs of the first tab control. He had placed the second tab control inside one of the tabs of the first tab control. But the problem is that the second tab control does not show up (unless one goes to the block diagram and double clicks the second tab control, only then does it shows up; when the vi is closed and reopened its again not there). I told him that I had never seen such functionality (a tab control inside another tab control) in any application but is it somehow possible. All this is required while the VI is not running and is being developed (of course it should work at run time, but this functionality must show while the VI is not running, i.e., this functionality should be non-programmatic. Is it possible. Thanks for your time. Hi rashid, yes it is possible. See the attached example. I see no problems with it.Hope it helps.Mike Untitled_LV71.vi: http://forums.ni.com/attachments/ni/170/323165/1/Untitled_LV71.vi Thanks <a href="../view_profile?user.id=88992" class="auth_text" style="font-weight: bold;" target="_blank"> MikeS81</a>! Yes you are absolutely right. Your VI is working perfectly. I wonder what has my friend done to get such behaviour as he is getting. Strange! Thanks for the help!Have a very nice day! Hi rashid, can you upload your vi, maybe someone found the proble...

Tab Tab
How can I direct the output from pressing tab tab to a file? Op 4 Aug 2004 12:39:13 -0700 schreef gnosis: > How can I direct the output from pressing tab tab to a file? gawk 'BEGIN {print "\t\t"}'</dev/null >file -- There's no place like 127.0.0.1 Gerard Wassink http://linux.family.filternet.nl http://freeware.family.filternet.nl Linux counter #360967, "In a world without fences, who needs gates?" gnosis wrote: > How can I direct the output from pressing tab tab to a file? I'm not sure I understand the question..... If you mean: 'put 2 TAB (0x09) characters into a text file from a command prompt', then echo -e '\t\t' >somefile or echo -e '\t\t' >>somefile If you mean: 'the output of the BASH 'TAB-TAB' "completion key combo", then no. The BASH TAB-TAB key combo is meant as input to BASH, so BASH interprets the TAB-TAB combo before you have a chance to supply any re-direct operators for the command. Regards, Larry -- Anti-spam address, change each 'X' to '.' to reply directly. ...

Tab Events of Access Application ? (NOT Access Tab Control)
I'm trying to use the event when a person moves to a different form by clicking on the built in Access application tabs. Is there something I can reference or does it require some kind of subclassing/hook api calls? Thanks On Jul 21, 9:47=A0pm, "christianlo...@yahoo.com" <christianlo...@yahoo.com> wrote: > I'm trying to use the event when a person moves to a different form by > clicking on the built in Access application tabs. > > Is there something I can reference or does it require some kind of > subclassing/hook api calls? > > Thanks Hi Christian, You can use the OnDeactivate event. Imb. > You can use the OnDeactivate event. Hello Imb, Aha. Now I am forced to make an event for each form. Trying to automate what tab the ribbon moves to based on the access application tab. Okay, thanks. Access could use a rewrite of it's event system imho. There are no top level application events to tap into, no 'after delete' event, record saves w/ a 'dirty=true', it's all quite ridiculous. I was hoping the new table events would be the solution but they come up w/ this 'data macro' crap where there doesn't seem to be any way to call your own code on the event. Sometimes I wonder if the ms developers ever use Access. However, I love the report and form design improvements. <christianlott1@yahoo.com> wrote in message news:ba72c614-57c0-4045-9af0-3cd9734e923b@r18g2000vbs.googlegro...

tabbing order in tab controls
Hi How can I set the tabbing order of controls in a tab control on the front panel when having several other controls on the front panel. Right-click on the tab and select "Reorder controls In page" from the menu that pops up. This is not exactly what I meant. When I'm creating a local variable I can choose its destination (right-click - select item). Because there are so many I would like to reorder the tabbing order to choose the correct on the top. All this action are taken in the block diagramm. From the edit menu, select Set Tabbing order changing the tabbing order will also change the order the variables are listed when you want to list or select a local variable ...

tab control inside another tab control
Hi. Is it possible to put a tab control inside another tab control. I tried it several times, but for some reason this doesn't seem to work. Can someone confirm this, or tell me what the trick is. Thanks. -- Georges The only way I know to do this is to put a subform on the first tab control. Then you can put your second tab control on the subform. If you do this repeatedly, however, you will find the form loading rather slowly. HTH - Turtle "Georges Heinesch" <news@geohei.lu> wrote in message news:3fe82fb8$1_2@news.vo.lu... > Hi. > > Is it possible to...

Hide a tab on a tab control
Dear All, I have a tab control with about 5 tabs on it. Depending on who logs on, I want to hide one particular tab. How do I do it? thanks John Fox Per John Fox: >Dear All, > >I have a tab control with about 5 tabs on it. > >Depending on who logs on, I want to hide one particular tab. > >How do I do it? Code below selects different tabs and makes some tabs invisible. 2160 With Me.tabMain 2161 If .Value = mTabMain_Page_Security Then 'If user walking a compressed list, don't want tb jumping back to sec if looking at docs 2162 If ..Pages(mTabMain_Page_CompanyGroupIssuer).Visible = True Then 2163 .Value = mTabMain_Page_CompanyGroupIssuer 2164 End If 2165 End If 2169 End With 2170 With Me.tabMain 2171 .Pages(mTabMain_Page_Security).Visible = False 2172 .Pages(mTabMain_Page_Allocations).Visible = False 2179 End With -- PeteCresswell Thank you - sorted! John (PeteCresswell) wrote: > Per John Fox: >> Dear All, >> >> I have a tab control with about 5 tabs on it. >> >> Depending on who logs on, I want to hide one particular tab. >> >> How do I do it? > > Code below selects different tabs and makes some tabs invisible. > > 2160 With Me.tabMain > 2161 If .Value = mTabMain_Page_Security Then 'If > user walking a compresse...

Tab control within another tab control
I am creating a form with a tab control containing 10 tabs. and what I want to do is on only on of the tabs, I want a sub section of tabs. So what it ends up being is one main tab control with another tab control embedded into only one of the tab pages. The problem I am getting is when I insert the sub section tab control into one of the tabs from the main tab control, the sub section tab control appears in every tab in the main tab control. Can anyone help? What do I need to do so it only appears in one tab, not all. Thanks As you found, you cannot place a tab control on one of the pages...

Vertical Tabs on Tab Control?
Hi Folks: I've used conventional horizontal tabs on one application. Now I'd like to have a row of tabs, representing each letter of the alphabet, running down the right side of a tab control. These are owner drawn tabs. I have questions. I want a single line of alphabet tabs. If the control shrinks to too small to show all of the tabs, I'd like them to display a ragged edge, and arrows in order to scroll them. Instead, multiple lines of tabs are drawn. The Resource Editor's "Tab Control Properties" window has "Multiline...

Tab Indexing in a Tab Control
Anyone know why when I set my tabs index in my tab control (I have 3 tabs on the control) the numbering gets messed up when I save the form changes? I thought each tab on the control had an independent tab index, I guess not. Marcus ****** Just a suggestion, the Tab Index for a container (Tab Page) is different than the Page Index for a Tab Control. You might be thinking that the Tab Index is related to the Tab Pages. The order of the pages is Page Index. (Right Click Page Order) The order of the controls on a page, form or other container control is Tab Index. (Right Click Tab Order) Tab, in this case means the Tab key on your key board. As you hit the tab key the focus moves from control to control based on the order of the index of each control and whether or not the control has it's Tab Stop property set to True. As far as I know, each Tab Page does have a collection of controls, where each control will have a Tab Index in that Tab Page collection. The indexes stay the same for me. That is, when I set the Tab Index for each control on a Tab Page, it remains the same after saving. If I change the Tab Index for each control on another Tab Page, it remains the same also, and it does not affect any other Tab Page control collection index. Hope This Helps ...

Tab Tab #3
How can I direct the output from pressing tab tab to a file? lzman@mindless.com (gnosis) tried to express: > How can I direct the output from pressing tab tab to a file? in bash... set +o emacs echo "<tab><tab>" > output set -o emacs Op 4 Aug 2004 13:17:31 -0700 schreef gnosis: > How can I direct the output from pressing tab tab to a file? gawk 'BEGIN {print "\t\t"}'</dev/null >file -- There's no place like 127.0.0.1 Gerard Wassink http://linux.family.filternet.nl http://freeware.family.filternet.nl Linux counter #360967, "In a world without fences, who needs gates?" Wiseguy wrote: > lzman@mindless.com (gnosis) tried to express: > >>How can I direct the output from pressing tab tab to a file? > > > in bash... > > set +o emacs > echo "<tab><tab>" > output > set -o emacs > Cool, I never thought of that.... Regards, Larry -- Anti-spam address, change each 'X' to '.' to reply directly. gnosis wrote: > How can I direct the output from pressing tab tab to a file? .... could you post this a fourth time please, i didnt get it the first three times !!!!!!1 .. -- << http://michaeljtobler.homelinux.com/ >> Alimony is the high cost of leaving. ...

Tabbing to next tab
Hi Is it possible that when a user is past a field on one tab of the tab control it automatically switches to the second tab to save manually changing the tab when entering data? Thanks Regards "John" <John@nospam.infovis.co.uk> wrote in message news:4087efbe$0$26197$cc9e4d1f@news-text.dial.pipex.com... > Hi > > Is it possible that when a user is past a field on one tab of the tab > control it automatically switches to the second tab to save manually > changing the tab when entering data? Here is what I recommend... Place a tiny (but visible=true) TextBox...

Tab Tab #2
How can I direct the output from pressing tab tab to a file? Op 4 Aug 2004 13:15:51 -0700 schreef gnosis: > How can I direct the output from pressing tab tab to a file? gawk 'BEGIN {print "\t\t"}'</dev/null >file -- There's no place like 127.0.0.1 Gerard Wassink http://linux.family.filternet.nl http://freeware.family.filternet.nl Linux counter #360967, "In a world without fences, who needs gates?" ...

Control + Tab between subforms on tab control pages ACC 2002
Greetings! What I am looking for is help trying to accomplish control + tab exiting subform #1 on page #1 and entering the first control (main form) on page #2. I've tried the following code, however it seems to "fire twice", placing me at the first control on subform #2 on page #3, totally skipping page #2. It seems to very briefly stop the control on page two, but keeps going. Hope that made sense. Key preview for subform is set to yes. This is a continous subform, so options to leave subform on last control won't work. That's why I'm trying to use control tab. I'd appreciate any suggestions. Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = vbKeyTab And Shift = 2 Then DoCmd.GoToControl "txtZoningClass+" End If End Sub The problem is probably that you did not assign KeyCode = 0 in your handler. Thus, after your code runs, the keypress is also processed normally. On 13 Sep 2004 11:39:22 -0700, brian.flannery@ci.verona.wi.us (Brian) wrote: >Greetings! >What I am looking for is help trying to accomplish control + tab >exiting subform #1 on page #1 and entering the first control (main >form) on page #2. I've tried the following code, however it seems to >"fire twice", placing me at the first control on subform #2 on page >#3, totally skipping page #2. It seems to very briefly stop the >control on page two, but keeps going. Hope that made sense. Key >preview f...

Tabs on top of Tabs
This is probably a very stupid question but for the life of me I cannot figure it out. I have a form with tabbed pages and on one of the pages I want to put more tabbed pages. When I put the sub tabbed pages on the page I want it shows up on all pages. This is annoying. Thanks. Tyler wrote: > This is probably a very stupid question but for the life of me I > cannot figure it out. I have a form with tabbed pages and on one of > the pages I want to put more tabbed pages. When I put the sub tabbed > pages on the page I want it shows up on all pages. This is annoying. > Thanks. You cannot nest TabControls. There are two workarounds... 1) Use the Change event of the larger TabControl to hide the smaller TabControl except when the larger is on a certain page. Kind of a hassle in desigfn view, but in regular view it gives the apperance of a nexted TabControl. 2) Use a SubForm on one TabPage and place a TabControl on the subform. This works better in design view, but is a problem if you need controls on the nested subform to be bound to the same tables and record as the main form as this will cause write conflicts. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com ...

Tab order on multirow tab control
Is there a way to stop the default action of a multirow tab control whereby the row with focus moves to the front of the tabs? I find this behaviour annoying and confusing to the user and am at a loss as to why MS has designed their tab controls like this. Wayne wrote: > Is there a way to stop the default action of a multirow tab control > whereby the row with focus moves to the front of the tabs? I find > this behaviour annoying and confusing to the user and am at a loss as > to why MS has designed their tab controls like this. ALL multi-row tabs act this way. How else can you identify the active tab except by moving it to the front? Try the Buttons format instead of the Tabs format. The buttons don't move. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com Rick, I guess I hadn't thought about the fact that the tab needs to move to the front row as you have explained. Maybe it would be more intuitive to the user to highlight the tab by having its text go bold when selected instead of changing the tab row order. That way the user would always find the required tab in the same place instead of having to hunt for it. What do other users think or am I the only one who finds the action of the tab control confusing - maybe I'm easily confused. :-) Anyhow, thanks for the info Rick - it's much appreciated. "Wayne" <cqdigital@volcanomail.com...

Tab Control
Is there a way to lock all the items on a tab in a form without having to list each field and lock individually? I see a way to enable/ disable, but not lock. Thanks, Laura On Mar 10, 5:58=A0pm, musicloverlch <lho...@gmail.com> wrote: > Is there a way to lock all the items on a tab in a form without having > to list each field and lock individually? =A0I see a way to enable/ > disable, but not lock. > > Thanks, > Laura What I usually do is hide the tab. But if you want the user to see the data, you'll probably have to go through each control one by one and lock each. -- GL ...

Change values of Tabs on Tab Control
I have a LabVIEW application where it is possible to change the language on the front panel, in connection with this I want to change the names/labels of the Tabs on a Tab Control. Is this possible? Hi Labbie, yes it is possible. See the attachment. Mike Unbenannt 1_LV80.vi: http://forums.ni.com/attachments/ni/170/311358/1/Unbenannt 1_LV80.vi Awesome all... got what i needed. &nbsp; Peace, &nbsp; Pete ...

Tab control tabs dissapear when clicked
I have yet another problem with the infamous tab control in my Access 97 database. I have a form with a tab control with 4 tabs on each tab is a sub form bound to a form. When the main form loads the vertical scroll bar moves the main form down just low enough to were one can't see the tabs on the tab control. Once you scroll back to the top of the main form and click on one of the four tabs the sub form on that tab becomes visible but the same scenario as above happens. The main form vertical scroll bar once again moves down just low enough to were you can't see the tabs until you scroll back to the top. Does anyone know why this would be happening? I have tried every possible combination of repositioning controls and changing settings and nothing works. Any help would be much appreciated. Thanks in advance, Mark C. I found the answer at the following site. http://www.kbalertz.com/kb_Q298358.aspx "Mark C" <hereinde@yahoo.com> wrote in message news:-9GdnRdu97nH-uXcRVn-3Q@comcast.com... >I have yet another problem with the infamous tab control in my Access 97 >database. I have a form with a tab control with 4 tabs on each tab is a sub >form bound to a form. When the main form loads the vertical scroll bar >moves the main form down just low enough to were one can't see the tabs on >the tab control. Once you scroll back to the top of the main form and click >on one of the four tabs the sub form on that tab beco...

Re: tabbing order in tab controls
Is there a way to change the tabbing order without having the order on a list or local change also? I didn't take that into account when making the program, should have ordered all the control before wiring it all up :-/ Hi leachdor,When you change the tab order of a specific control in LabVIEW, it must then re-order the other controls in order to ensure that each tab order value is only applied to one control, and that there are only as many tab stops as there are controls.&nbsp; As such, there is no way to simply re-order a single control without modifying other controls. Hi and thanks for the response. I think I may have explained the behavior i'm seeing wrong.&nbsp; Changing the tab order, you have those two little boxes the first showing the changed order number, and the black background one that shows what it was previously.&nbsp; Each time you change one, yep you have to change the order of the rest otherwise you might tab and select two fields at once!The behavior I'm not sure about though, is when I change them to the proper order on the front page, it changes my block diagram.&nbsp; For example if I have a cluster with 3 items in it, and I change the tab order of the items inside that cluster.&nbsp; Then if I had previously used an "unbundle" function prior to the tab order change, and it was all wired up with item 1 at the top, item 2 in the middle output, and item 3 as the bottom output - AFTER the change, those controls...

Tab Control
Hi, all! &nbsp; I would like to customize Tabs on the Tab Control. More exactly - I would like to add bevels to the tabs as shown below: &nbsp; <img src="http://vi-lib.com/forForum/TabControlwithBevel.jpg"> &nbsp; Is it theoretically possible? May be&nbsp;some workarounds exists? &nbsp; with best regards, &nbsp; Andrey. Hi, TiTou, This requirement coming from corporate UI Guidelines, where shapes of Tabs strongly predefined. I can do required "skinning" for most controls which can be customezed, but unfortunately not for Tab Control... Andrey...

Getting XP look with tabbed dialog control and tab strip control
I know how to use a manifest file to get the XP look for the Windows Common Controls 6 group of controls but I also have both the tabbed dialog and tab strip controls in my app and I want those to take on the XP look as well. Does anyone know how? Also, while I am able to get the XP look through a manifest file in my app's folder I should be able to do this without the file having to be in the app's folder. I've read it has to do with compiling with a resource file but I don't know how to do that. Can anyone offer any assistance? Thanks! ...

How can I set the tab order of text box controls on each page of a tab control?
I need to be able to select the tabbing order of individual controls on a single page of a tabbed control. How?? In LV 6.1 an up you should be ablel to right click on the edge of the tab control when the tab-page in question is selected. The bttom selcetion in the pop-up is "Reoder controls in page..." selecting this option will switch editing modes to allow you to specify the ored, just like in a cluster. I seem to remeber in older versions you had to drag the tabable controls off the tab control, specify the tabbing oder and then drag them back on. The oldest version I have on ...

Executing a Script when clicking a tab in Tab Control
Is it possible to execute a script when clicking on a tab when using the new Tab Control function in FMP8? place an invissible rectangle on the part where you want to click, define this as the button. Ursus "Steve" <snl930@hotmail.com> schreef in bericht news:1134101672.975937.311770@g49g2000cwa.googlegroups.com... > Is it possible to execute a script when clicking on a tab when using > the new Tab Control function in FMP8? > ...

working with a tab control with no tabs in design view
I'm using a tab control in Access 2000, and the user requested to have buttons in the form header, instead of the built-in tabs (so that when they scroll down, they can still switch tabs). Now, this works fine. However, when I'm in Design View, I can't access the tabs without changing the tab control's Style back to Tabs. But I want to be able to place controls in that space at the top where the tabs used to be. But if I need to turn the tabs back on when I need to make design changes, then I can't do that. So the result is wasted space at the top of the tab control, because I have to toggle the tabs back on whenever I need to make design changes. Is there a way to cycle through the tabs in a tab control in design view without the tabs being on? I can select the tab control, itself, by using the Object dropdown in the toolbar; but I can't get to tab 2, 3, etc., unless I turn the tabs back on. There must be a way to do this. How else would one work with it in Design View with the tabs off? Thanks for any assistance. Phil Reynolds wrote: > I'm using a tab control in Access 2000, and the user requested to have > buttons in the form header, instead of the built-in tabs (so that > when they scroll down, they can still switch tabs). Now, this works > fine. However, when I'm in Design View, I can't access the tabs > without changing the tab control's Style back to Tabs. But I want to > be able to place contr...

Web resources about - How to color tab of tab control when content of tab meets generic criteria - comp.databases.ms-access

Multiple-criteria decision analysis - Wikipedia, the free encyclopedia
Multiple-criteria decision-making or multiple-criteria decision analysis ( MCDA ) is a sub-discipline of operations research that explicitly ...

Appropriate Use Criteria (AUC) for Cardiac Radionuclide Imaging on the App Store on iTunes
Get Appropriate Use Criteria (AUC) for Cardiac Radionuclide Imaging on the App Store. See screenshots and ratings, and read customer reviews. ...

8 Success Criteria for Facebook Page Marketing - Flickr - Photo Sharing!
... lack a strategy. Altimeter Group conducted research, and gleaned input from 34 vendors, agencies, and experts, to determine success criteria ...

Odds are pension criteria only going to harden
Odds are pension criteria only going to harden

Merit protection is not 'red tape': the dangers of scrapping job selection criteria
Job criteria aren't always used well, but getting rid of them opens the door to nepotism and inappropriate influences.

South Australian 2015 road toll: Rural roads don’t meet safety criteria for 110km/h
RURAL roads outside the state’s main highways do not meet strict road safety criteria for 110km/h speed limits and should be reduced to 100km/h, ...

The judging criteria
The judging criteria

Public Service Commissioner John Lloyd slams job criteria as a waste of time for everyone
Top ranking public servant slams job criteria as a waste of time for everyone.

Olympic golf criteria announced
... champion Phil Mickelson is currently ineligible for the 2016 Olympic Games despite being the world's 13th-ranked golfer. Controversial criteria ...

Brendon Bolton's criteria for success at Carlton in 2016
&quot;Reset&quot; is the operative word at Carlton and, for once, no one is under any illusions as to the magnitude of the challenge.

Resources last updated: 3/21/2016 2:49:15 PM