Is it possible to use a toggle button to change the colour of a label?
I assume the code should be something like this:
Code:
If Me.ToggleButton = 1 Then
Label.BackColor = RGB(0, 255, 0)
ElseIf Me.ToggleButton = 0 Then
Label.BackColor = RGB(255, 255, 255)
End If
But I've tried it in the "On Click" sections and it doesn't work.
Ok what I would like to do is have a switchboard with a number of command buttons on, each button opens to a form with a few fields within them.
Is it possible for the initial switchboard labels to be 'red', then as the related form is opened and populated the switchboard label turns 'amber' and once the form is complete the switchboard label is 'green'. See example piccie attached, to get a better understanding!
This is to enable multiple users to see at a glance the status of various jobs.
If anyone knows how I can go about this or suggest any alternatives, I'm open to suggestion.
Thanks in advance
http://img101.imageshack.us/img101/223/switchsamplert7.jpg
I'm using a label as a button so it looks nicer, but if I press it without officially exiting the last text field I was in, then that text field doesn't update, so the vba believes it's blank or whatever it was.
I could manually setfocus to a couple different fields or have a teeny field thats hard to see to set focus to, but these both seem roundabout.
hi again,
i am making a form which has a help link on it;
the help link is basically a label using this code:
Private Sub help_Click()
Me.help_pop.Visible = True
End Sub
this makes the help_pop label appear visible (as it's visibility is false)
ok so i have that bit sorted, now i want to be able to click the help link agian to make the help_pop label disappear..
any help appreciated
Rob
I have a printed form that pulls some of its data from a table.What i need is that printed form to have a variable that two area in the form can change based on who is printing the form.I have a table that has all the users data in it. the current form pulls that information from the label and places it into the for. easy enough so far right.
for example. But i need this printed form to be able to be dynamic. So for instance Tom inst sitting that the computer wanting to print the form and so on for four different users who will print the form.So the button that allows the print either needs a way to have a selection or i need four different button. So the second part of this Mark Twain quits his job and Johnny takes his place. easy enough to change the data in the table that my form is pulling the data from but the button label needs to change to that the button.
I have n horizontal labels named Label_1 to Label_n. I'd like to assign values to the label captions by using a loop.
Something like:
For i = 1 To n
Set Label_i.Caption = i
End
However, this doesn't work. Message "Object required".
Any suggestions?
Hi all,
I have a form with two subform on it and two toggle buttons.
Clicking each toggle button will open one of subform, and clicking it again will close that subform. But the problem is that I need to click the toogle button two time to open the sub form.
So, what is the problem??
This is the code under On Click event:
Private Sub Toggle0_Click()
If Me.TendComm_Label.Visible = False Then
Me.TendComm_Label.Visible = True
Me.TendComm.Visible = True
Else
Me.TendComm_Label.Visible = False
Me.TendComm.Visible = False
End If
End Sub
Private Sub Toggle1_Click()
If Me.AuthorizedSignature_Label.Visible = False Then
Me.AuthorizedSignature_Label.Visible = True
Me.AuthorizedSignature.Visible = True
Else
Me.AuthorizedSignature_Label.Visible = False
Me.AuthorizedSignature.Visible = False
End If
End Sub
how do these work syntactically? there's no wizard for them.
i want to create a button that displays a picture, then when you click it, it shrinks the form and changes the button picture, and when it is clicked again, the form goes back to the original size and picture. thanks
Hi, I'm very new to programming and i have very little knowledge about it. My problem is probably more simple than I may think, but for some reason I haven't been able to find a solution for it.
In MS Office, I'm making a form with a few toggle buttons which are linked to Yes/No fields on a seperate table. What I would like to do with the buttons is in their default state, which is "No", I want for the word "No" to appear on the top of the button. When the button is pressed, I need for the button to display the word "Yes". I know that it's possible to set the caption on the button to "No". Is there a way to have the caption change to display "Yes" with the press of the same button it's on? If so how? Also to have the fields reset to default with a new page on the form.
Please explain it to me as if I'm a 5 year old trying to learn programming.
Thanks in advance.
Hi,
I'm currently using MS Access 2002.
I use forms to display client info and i would like to know if the following is possible, and if so, how ?
When a clients installation date is older than 6months old (date is in a text box) i would like the form's background to change colour for that paticular client.
eg/ if the clients installation date was 7 months ago, the form's background would change red - but only to that client.
Kinds Regards
Chris
page colour name change
View 3 Replies View RelatedFriends,
I would like some help with my form.
I would like the following:
If txtname is null (without data), then txtdob font is changed to colour white.
Any help?
Thanks.
Hi, I would like to have a toggle button on my form that when clicked it changes the button colour and the button text. The toggle button doesnt have to be bound.
cheers
I have a routine than has been working perfectly up to now. My save routine was called by clicking a Command Button called cmdAdd.
I tried to change this Command Button to a toggle button by deleting it then creating the toggle button, naming it cmdAdd and clicking on the event property to link it to the existing procedure. PS It is an UnboundForm
BTW, I've done this for several other commands without a problem but with this particular case I get the following error
Run Time Error 2115.
The macro or function set to the Before Update or Validation Rule is preventing Access from saving etc."
It seems likely that I need to do something to the toggle properties.
It allows the docmd.save but still says "You must save the current field before you run the Requery action"
The system is looking to save/update and something is stopping it. Funny though that this doesn't occur with Command Button
I have tried decompiling, compact and repair, commenting out every line that involved updating a field or variable (Except for a recordset operation that does correctly do the updates required)
BTW the Toggle button has no Before or After Update events - Only the On_Click
...but I'v got a picture and I want to put a red box behind it so the picture looks like it has red borders, the problem is that the box always appears above the picture, I'm sure there must be a way to prioritize them or something but I can't find it!
View 3 Replies View RelatedI've been working on a database for quite a while now, and i've now given it out for testing, and i've come across a little problem. One of the users is colour blind, and the colour theme i've used throughout this database is causing him problems.
I have a function that can single him out when he logs in, question is, is there a way i can change the font colour for the whole database in one go through code??
I have around 12 forms with many controls and labels, i'm kind of hoping i don't have to name each control and label separately to change the font colour.
Please tell me that there’s some clever piece of code that can change the font colour on a form in one hit…..
Regards
Darren.
Hi
I have a problem where the user has certain contraints in colour.
I am trying to change all the colours of labels in the database to purple.
Is there any way to declare it once in the database and all label statements will pick up the new colour. Saves me going through every form. Also there are other users who want to use the database with black.
???:rolleyes:
Hello,
First please accept my apologies if this has been done before. In the attached database I am going to have a form which is continous what I am looking to do is change the colour of the box which is in the background to the associated colour from the quote table for example
if they choose water then it will look at the TBLQuoteType and change the box colour to the colour which has been assigned to that value.
Hope this explains it ok I will continue to try and figure it out but I thought I could also use your expert knowledge.
14030
Thanks again
Im trying to change the background colour of some fields if the value is null or missing, but I'm not quite sure how to handle the coding. The fields in question are title, given name and surname, and if they are empty I want to change the background colour to highlight to users that they need to collect this information.
Any help that you can provide would be great!
Is it possible to get Access to automatically change the colour in a form field via code etc. My problem is that i would like to easily pick/see any out of date quotations for my customers, so when the quotation date is 30 days old the text changes to red. Any advice would be gratefully received.
View 1 Replies View RelatedI have a report which i am trying to format, I want every other row's details to alternate colour which i have done (See below)
I also have on my report, a checkbox and a text feild (not sure if i could use a rectangle and format that instead , it doesn't do anything i just need it to change colour)
chkbox name = "chkClean"
Text box name = "txtclean"
I just want the back colour to go red if the check box is true and white if the check box is false
Please help
ANdy
Code:Option Compare DatabaseOption ExplicitPrivate m_RowCount As LongPrivate Sub Detail_Format(Cancel As Integer, FormatCount As Integer)m_RowCount = m_RowCount + 1 If m_RowCount / 2 = CLng(m_RowCount / 2) Then Me.Detail.BackColor = 15263976 'Change value to the color you desire Else Me.Detail.BackColor = 14811135 'Change value to the color you desire End IfIf Me.chkClean = True Then txtclean.BackColor = 255Else txtclean.BackColor = 16777215End IfEnd Sub
I have a bar graph on a report in ms access that represents 4 different risks ie count on the y axis and risk type on the x axis (low, moderate high and extreme)
Question: How do i get the each bar to automatically represent the colour based on the risk colours below?
Low: Green
Moderate : Blue
High : Yellow
Extreme: Red
Is there a way to show the toggle buttons in an option group as NOT selected when the form first loads up? I've cleared all the default value properties in the table and the form but it always loads as showing one of the buttons pressed/selected. I want the form to load and both buttons in the group look the same.
View 3 Replies View RelatedI am making a specialty form where it must toggle on or off when the user clicks on a boxed area. Since toggle backgrounds cannot be set to transparent, I need to do it some other way. I thought of either using a button to control a hidden checkbox, or just writing code altogether. The problem is that I don't know what code to use to programmatically change the state each time the box is clicked.
View 14 Replies View RelatedI have a contact list db that displays in datasheet view on startup. I also have an alternate form that displays in datasheet mode that i want to be able to toggle to with a click of a button. I would like the button to appear at the top of the default datasheet form, that will allow a user to toggle to the alternate form when they need to.
View 7 Replies View RelatedI have form with a number of of combo boxes that filter a query that populates a list box. It's used to track inventory. I want to add a toggle button that when press will filter my query so that it shows only items with a value > 0 in the quantity field. And when not pressed it won't filter by that field at all.
View 14 Replies View Related