Changing Backcolor
Dec 13, 2004Hoi,
When i'm select a record, i want to change the background color of all textfield in that record.
Does someone know how to do this?
greetings
koen
Hoi,
When i'm select a record, i want to change the background color of all textfield in that record.
Does someone know how to do this?
greetings
koen
hello,
I have a txtBox. Its backColor property changes according to what I do on the form. Now, when I close the form and reopen it, the backColor is not the same one with which the form was closed.
Ex. red, green
if I close the form having the backColor = green, then when I reopen it, it changes to red.
Can anyone tell me what I am missing
Thank you
Hi,
Is there a way to set the background color of a datasheet? I don't mean the color of the cells, but the datasheet itself outside of the rows/columns as shown below (dark grey color):
http://img.photobucket.com/albums/v368/flemmo/datasheet.gif
Thanks
I open form and get parameter in the openArgs
I have a tabular Form
and I want change the color if the ID is aqual.
for example:
I open the form like this:
DoCmd.OpenForm "frmMessageShow", , , "fID=" & Me.fID, , , Me.AssighmentId
[the Me.AssighmentId is the openArgs]
I want in the second form to color the textbox if AssighmentId = me.openargs
I try do it:
If Me.AssighmentId = Me.OpenArgs Then
AssighmentId.BackColor = vbRed
End If
and its not work :mad:
is there is an option to do it?
thanks!
Hello,
I have the following code for changing the back-color of a field:
Private Sub txttekst1_AfterUpdate()
Dim lngRed As Long
Dim lngGreen As Long
lngGreen = RGB(0, 255, 0)
lngRed = RGB(255, 0, 0)
If Me.txttekst1 < 100 Then
Me.txttekst1.BackColor = lngRed
ElseIf Me.txttekst1 > 200 Then
Me.txttekst1.BackColor = lngGreen
End If
End Sub
Problem: When I change to record to record the back color is not
the same as I have write the code.
mulderm
Hi all,
Is it possible to change the Background color of a command button?
Whan I right click in the properties of the command button I cannot see a BackColor property. Further, when I programatically try to change the BackColor property in VBA I get an error message.
Thanks in advance
Kabir
I have a randomized table named tblRandomBoxes with the following data:
ID RandomID
1 4
2 5
3 2
4 6
5 1
6 3
I have 6 command buttons named command1,command2,command3, etc. and 6 Labels named Label1,Label2, Label3, etc. On Click of each command button, I want to lookup the ID based on the RandomID and set the backcolor of that label number to a different color.
ie) on command1 click me.Label4.backcolor = 39835
How can I 'build' the label number with the lookup? Here's the code I'm trying, but it doesn't recognize my 'built' label number:
Private Sub command1_Click()
Dim ctl As Control
ctl = "Label" & DLookup("ID", "tblRandomBoxes", "RandomID = 1")
Me.ctl.BackColor = 39835
End Sub
Thanks,
Sup
I am trying to change form backcolor with a cmd button via VBA.
View 6 Replies View RelatedA user requested a change that would change the form header and detail back ground color to white when they click the button print record and then change the color back all in one click after the record prints. I keeping getting a run time error, type mismatch on the line where to code is to be changed. The colors are numbers not vbColors. I am using Access 2007.
Code:
Me.FormHeader.BackColor = "#FFFFFF"
Me.Detail.BackColor = "#FFFFFF"
I am trying to color code text boxes based on the data entered in. The column is "PHASE" and the items entered in are either "1" "2" or "3". 1 is supposed to be Red, 2 Yellow, 3 Green.
I have Microsoft Access XP (I'm sure). I've tried to do it on VB and had no luck. I couldn't figure out Macro and I don't have On Click or Code Builder.
I have tried a couple of different expressions and no luck. I'm definitely an amateur to Access. I'm only using it cause it's what we have in the office.
I would like to know if this is possible using VBA ( or other method)
I want to determine the back color o a cell based on a color value stored in another cell in other word
backcolor of cell A = the value of cell B
So if I change the numbers of cell B (which is color codes) , backcolor of cells A change accordingly and it will have the color specified in cell B.
I have a subform with two fields [status] and [process], i am trying to get the backcolor of procces to change to red if the status field contains the text "expired".
I have tried vba. plced on the after update
if me.status = "expired" then
me.process.backcolor = vbred
else me.process backcolor = vbwhite
end if
this
Changes the color of the field [process] but also all process field colors to red even if the status field does not contain "expired".
I think conditional formatting is the way to go but i think i need an expression to complete this.
I wish to change the backcolor of a field on a current record being dispalyed in a 'multiple items' form. However when using me.A.backcolor = makes refrence to all fields called A on the 'multiple items' form and therefore all fields change colour not just the current record.
View 2 Replies View RelatedI just recieved a call from a customer who is having trouble with a database that I did not create for her.
She says that she modified a form in design view and saved it. Now when the database is opened using he shift key, the changes show on the form in form view. She says if she opens the database normally (without the shift key) the changes do not show on the form.
This does not make sense to me. Can anyone give me a clue as to what might be going on?
Is there any whay you can change the cursor as it moves over an object, similar to what it does with hyperlink.
I am trying to make the form more dynamic
Thanks
Dave
We use a device called a site master to test frequency levels across a system. This device stores plots onto graphs which are then downloaded onto an Access (95) database. When the plots are captured before they are put into the database they are time and date stamped among other things. When I open the Database in access I can go into the fields and physically change each of the dates. Yet when I use the site master software to open the database the Time and Date stamp appear at the bottom as the original values and not the changed values that I have assigned. Also when you right click the plots table and go to the properties. The created and modified dates have stayed as the originals. What I would like to be able to do is adjust this date. And what I would like to know is this possible??? Is it like a Windows File 'System' that is giving this date or is it a function in Access that can be changed?
View 4 Replies View RelatedHello Everyone,
I'm pulling my hair off with this situation. I have an excel file that was given to us by the payroll department of our company, but my manager doesn't like the layout in which was given to us. I've attached a sample of the file, the file has two sheets the first one is how the original file looks like and the second sheet "final look" is how my manager want the file to look.The original file is pretty big, it's for 33 different employees and it contains 93,500 rows. I think it will take forever to do this manually, any ideas would be really appreciated.
Thanks,
Pablo
hello guys,
firstly thanks to all the guys here without whose help, I would not have been able to finish my database. However, there remains one question to which I havent found a satisfactory answer. I have checked through all the threads here.
I have made an .mde for my application and I want to customize my application icon to my company icon. The DB by default shows the access icon which I would like to change.
The threads here deal with issues of changing the desktop shortcut icon or changing the icon for forms. These threads do not address the problem I am facing.
I want the icon to be changed from access icon to a customized icon.
I am using MS access 97.
Any help will be greatly appreciated. If there is a thread which I may have overlooked, plz point me out.
Thanks in advance
FXP.
I have set a password on my access document but now need to change it - does anyone know how to do this?
View 1 Replies View RelatedI need a little help in the following topic:
There is an Access (2002) database used at our company covering its different tasks; different mdb files are used for different tasks (storage, invoicing etc.). All of them are linked to a central file that holds the tables.
Some of the users use more files; the same colleague uses for example the storage module and the service module.
I'd like to keep it this structured but I'd like to make it easier to change between the files so the user don't have to quit manually from the storage moduel and open a service module, giving his password for the tenth time per a day.
Could you help with an advice how I could do with VB that by clicking on a button the presently used file closes and another preprogrammed one opens.
(For closing I'm using DoCmd.Quit but no idea how to open something)
I really appreciate your help.
Peter
i am doing a computing project using access 2003 and vba.
i have designed 2 forms A and B, form A is where a user to logs in to my system (with four main items: username (combo box), password (textbox) and two buttons) and form B is where the user can change their password (with four items: username (username (combo box), new password (textbox) and password verify (textbox) and a button that checks everything and updates the password).
Form A has two buttons, one button can log the user into the system after typing in their correct username and password credentials, and the other button gives the option to change their password also after typing in their correct username and password credentials (and the opens up form B for the user to change their password)
My question is, when the user presses the button to open up form B, what code could i use (or methods in access) that would set the username field (in form B) the same as in form A automatically without the user having to select it again?
All help would be much appreciated
Hi, I'm in the process of making a super simple database (3 - tables). I have run into a problem with two of the tables. The relationship between them is one -> many. Say, I have a record in the (one) table which contains a primary key that is also part of a compound primary key in the (many) table.
Ex:
tblEx1 - (1 side of relationship)
red(pk)
blue
yellow
etc...
tblEx2 - (many side of relationship)
red(pk)
purple(pk)
orange
etc...
If I create a record in tblEx1 and type in some BS for the "red(pk)" field, and I then go to tblEx2, fill in all the fields, and also type in the same BS for the
"red(pk)" field, and come back at a later date, and want to change the value of the "red(pk)" field in both those tables for a certain record, it will not allow me. It doesn't matter which one I go to first. Would I have to delete the relationship everytime to be able to change the value for the "red(pk)" field in either table?
On a related question. In the above example when your doing data entry I'm not sure if I'm doing this right. It seems odd to me that I would have to type in the field for "red(pk)" in both tables, isn't their a way it can automatically figure out to put the same value from the first table into the next one since thier in a relationship.
Sorry if the above is confusing, and stupid. I'm just asking cause I did a whole bunch of records and I have to modify the name of the field which is the primary key, and I don't want to have to delete all the records and re-enter them; that would be a big time waster. Any help is appreciated.
in my assignment, I am told to change my prior query by continuing to display the sum, average, and pledge numbers. what is required, is for me to display these totals by the names of the pledges, not just a grand total. how can I sort the query by name?
View 1 Replies View RelatedAre there any tricks or formats out there that make updating a time easier. I have a date field (Formatted: short time and input mask: 00:00;0;_)
When I put in the original time it does great. When I try to change the time I have to delete the old time, go to another field then come back and put in a new time. If I do anything else it rejects and beeps (annoying) and tells me that I am not using the proper format.
Well, problem I should know how to solve! Or at least be able to find in the "search" But...... niether..... So this should be a simple one...
Have a form with a ClientID combo.... If this record is changed I want a warning message before... So I decided to do it as a function then call it on change...
Private Function ChangeClient()
Dim Msg, Style, Title, Response, MyString
Dim Cancel As Integer
Msg = "You are about to change the Client for this Project!" & Chr(13) & "Do you want to continue ?"
Style = vbYesNo + vbCritical + vbDefaultButton2
Title = "WARNING"
Response = MsgBox(Msg, Style, Title)
If Response = vbYes Then
MyString = "Yes"
ElseIf Response = vbNo Then
MyString = "No"
Cancel = True
Undo
End If
End Function
Now the problem is.... What event to call this on!?!?
It works fine on several events on a current record...
BUT... when it is a new record, and you pick the client from the dropdown, it sees a change and runs the function. That clear?
I was thinking of running a "If ... Then" statement so if it a new record the function will not be called.
Got to be an easier way to simply warn of a field change!
Ideas???
Thanks
I have a combo box with an SQL rowsource. How can I automatically select the 'next' value (through VB) within the same combo box?
Also, I will like to display a message like 'This was the last record' in case there is no 'next' value to go to.
Please let me know if i have given too little information.
Thanks a ton!