Change Forecolor
Jun 24, 2005I have a basic question
I want to change the forecolor of a text box when another text box or possibly a Yes No box is true.
Can you tel me the correct way to code this.
ADVERTISEMENT
Forms :: Text ForeColor Of ComboBox Fields
Aug 27, 2013I am working on a database project using Access 2010 and encounter some ComboBox text color problem,
The form has a ComboBox that displays the Supplier Name. The Combo's source control is Supplier ID in the Products table which joints the Supplier Table containing the Supplier Name. To display the Supplier Name only, I use a column count of 2 (for VendorID and VendorName) and column width of 0";2" so as to hide the SupplierID.
VBA is used to dynamically change the ForeColor and BackColor (via the Control Property ".ForeColor" etc) of the text in the ComboBox and TextBox. This works well for all TextBoxes and the ComboBoxes with direct data from the Products Table. However, for the ComboBox of VendorName, the BackColor can change but the ForeColor always remains as black. I have tried using the Format query such as "[White];@;[White];@" which works on the TextBox and other ComboBox (with direct field data from table), but the situation remains the same on this ComboBox which uses join-table reference via the VendorID.
Changing The Forecolor Of A Command Button Accroding To An Event
Apr 18, 2006Can someone give me a jump start with code for changing forecolor...
On one form (form 1) I have a command button (cmd34) which has its text in Black (forecolor 335543)
On another form (form 2) I have a checkbox (chk45)
When the check box is checked I want the text on the command button to change to red (forelolor 255).
1. Where do i put the code? On the second form (On Close) or on the first form (On Open) or ???
2. Is the code something like
If me.chk45=true then
Cmd45.forecolor=255
Or am i just making that far too simplistic?
Forms :: Change Button Color After Data Change
Apr 5, 2014I am trying to change the button color on a subform if a related form data changes.Main form is products with a continuous subform with serial numbers of products i.e, serial number, location, price and a button to add addtional issues if there are any for this particular serial number (this will open up another form related to the serial number so I can add an issues if there are any).The reason I would like the button to be a different color is so I can quickly see if there are any additional notes been added to the serial number. Just in case you may ask why not add the field to the continuos form is that the issues and be quite lengthy and there may be lots of serial numbers on the form
2346 location warehouse price 29.99 (button - green)
2347 location shop price 29.99 (button - red)
Change One Form Causing Change Other
Jul 2, 2005I have not done much work in later version of Access. Now I found if I change a design in one form and similar forms (names are different) which are linked to the same tables got changed as well without openning them up and making changes. Is this something new with Access 2003?
Thank you very much for help.
Change Field Value On Change Of Other Field In Form
Apr 2, 2008What I want to do is following.
In form ASSIGN(fields are takedate and inout) ,if TAKEDATE is different then 0 then set value of inout field to 1
My VBA knowledge is poor cause i dont think this should be hard
thanks in advance
Change Log In.
Jan 4, 2006Is it possible to switch log on
ie from within a db, opened as one username and password decide want to run db as other user , rather than close the db and reopen it (entering new usrname and password) , can I build a form where you just enter the new username and password, and continue running the db as the new currentUser?
Thanks Paul
Many-many: Change To 1-many?
Aug 4, 2006Hi, hope someone knows the answer to this one...:p
We started a new business and built a db for expecting our work to happen a certain way, but now find it's very different and need to change the structure before it's too late to fix. Can someone please take a quick look at this idea & tell me if it's likely to cause major problems down the road?
People send in applications for specific groups/clubs. We thought they would arrive separately, so we set it up to enter each application and then add them to the Group listing one by one. TblApplication is a many-many with tblGroup, with junction tblGroupAppl. (People can be in more than one group.)
As we go along, however, we are finding the opposite: all the individual applications are being sent together by the club and so now we could actually turn this into a simple 1-many with tblGroup as parent and tblApplication as child. It seems like it would be much easier with queries and such if that extra step could be eliminated.
If I go through and put the GroupID on each record of tblApplication, can you see anything I might be inadvertently wrecking with this approach?
Any ideas/suggestions would be most appreciated!!
Thanks, this forum is amazing.
Name Change
May 9, 2007I am using access 2003 and have a database with over 1500 rows
I have many queries and reports relating to this database
One of my agencies changed their name and I want to know what is the best way to change the name in the whole database, including queries and reports
Change Bg
Jan 18, 2006Hi,
I have a form with a subform that is set to continuous.
I have a field [Info][.RemovedP]. What i want is if RemovedP = -2 then i want the bg colour of JUST that record to be changed.
The default is blue, so what i will then get is blue bg for all the records accept if the RemovedP ='s -2, it will then be red.
Hope this is clear enough.
Thanks
k0r54
On Change
Oct 7, 2006Hi,
I have a form with 6 field boxes - What I want to do is - on change of any of the fields value will change the background colour of all the fields in that record.
When I go to the next record all the fields will be their original colour until I change the value in any of the fields again - however if I am browsing the records - no colour change takes place.
I do not know how to code this:confused: - I would appreciate any clues to solve this.
Many thanks
Cliff
Key Has To Be Change In All The Tbl
Dec 2, 2004I want to add a form that will let me take a clients unique Key and change it to the # that i want and with the click of a button have it cascade to all the other tables. with relations ships set it wont let me make any changes. any ideas on how to tackle this.
View 4 Replies View RelatedChange Log
Oct 2, 2007Hi all
Is there a way to capture all my changes to a database into some kind of change log??
Add/change The Name Of A Control...
Apr 7, 2006Just wanted a little help please. I have about 100 option boxes on a form and I want to be able to change the names of the option box and its label. I want to name them from 1 to 100 sequentially. (i.e. option1, option2 ...).
When I create the controls it automatically names them option0, option2 etc. and label3, label5 etc.
I was going to change them via some code but I don’t know how to refer to a control in a form from design view.
Can anyone help please?
Thanks
Red
Change A Reference
Apr 29, 2005I need to change the reference "Microsoft Access 9.0 Object Library" in Access 2000 with the "Microsoft Access 11.0 Object Library" but I can't de-select it 'cause it's used by the program. Another problem is that I tried to import the 11.0 copying the file and when I select it from the panel control it seems to import without problems, but when I search it in the list, the 11.0 doesn't exist.
How can I import it?
How Do You Change Primary Key?
May 31, 2006How would I go about changing the primary key to a different field in a table? :o Thanks for any help!
View 2 Replies View RelatedChange Database Name
Sep 14, 2006Hi
This is going to be very simple so someone !!!
All Iwant to do is change the name of my database.
Currently it is called 'Test' and I now want to call it by the proper name.
I have changed the icon name that is displayed in Windows Explorer and also on all the forms within the database properties window.
However the name 'Test' still appears at the top of the main Access window!!
How do I change this so that it says the new name?
Any help would be appreciated.
Thanks.
Change Of Primary Key
Jun 28, 2007How do I reassign a new PK for may tables.. they're already related and there about 2,000 records on the Main Table and like 6000 records on the related table.... I used a wrong PK and I want to create a new (long Integer Auto-Number) but I don't want to lose what I've done already.
View 7 Replies View RelatedChange Query
Jun 21, 2005I am creating a database that is going to import excel files once a week. Most of the data will be the same every week, but some may change slightly or new records may be added. I need to create a query that will show all the changed/new records that are imported from the excel file. i would prefer to use as little code as possible if at all. I am pretty much a novice when it comes to queries so any suggestions would be appreciated.
View 1 Replies View RelatedChange Grouping
Sep 19, 2005Can you help me.
I have about 2000 records with Part Number XXXCOGxxxxx. This Should be C0G. Ex:
SPN
RPE122COG101K
RPE122COG681K
RPE122COG101K
RPE122COG681K
GRM40COG100J
GRM40COG100K
GRM40COG101J
GRM40COG150J
GRM40COG220J
GRM40COG221J
GRM40COG271J
GRM40COG470J
GRM40COG471J
GRM42-6 COG100J
GRM42-6COG220J
GRM42-6COG472J
What to write a query to change just the COG portion. Can you tell me the formula?
Thanks
Chris
How To Change Variable Name
Oct 20, 2005Hi:
In SQL:
How to change the variable name?
For example:
query1:
I have a input, which is [Please enter the value 1:]
Then,
I want to use this query, but different values.
I want to put [Please enter the value 2:]
In SQL, how can I write?
Select [Please enter the value 1:] As v1, Please enter the value 2:] As v2 from combine
Union
Select * from query1
Union
Select * from query1 where [Please enter the value 1:] = [Please enter the value 2:]
How To Change Row In Query
Jul 20, 2007Hi
How is it possible to change row in query column title?
I have query which look like this:
[number] [start time] [end time]
1224345 12.6.2007 13.6.2007
I want that my query should look like this:
[number] [start [end
time] time]
1224345 12.6.2007 13.6.2007
Change Value To Text
Feb 7, 2008Hi,
I have an option group on my form. In my query it uses numbers like 1, 2, 3 and so on.
Is there a way in the query to show say Done where 1 and Not Done where 2 and so on.
On my reports I use the following
=IIf([Status]=1,"Not Satisfied",IIf([Status]=2,"Partially Satisfied",IIf([Status]=3,"Satisfied",IIf([Status]=4,"Waived",IIf([Status]=5,"Client",IIf([Status]=6,"Attorney Consult",IIf([Status]=7,"Attorney Approval")))))))
I am exporting the data to EXCEL and the numbers mean nothing to the end user they want to see what it represents.
Thanks.
Fen How
Change Name Format
Feb 11, 2008The DB this info is pulled from stores the NAME field in all caps.
My query returns the name like= JAMES JONES
Is there something I can do to change the name format to James Jones?
SELECT
[OPEN CASES].CASE,
[OPEN CASES].[MEMBER#],
[CLIENT TABLE 2].NAME,
[CLIENT TABLE 2].A1,
[CLIENT TABLE 2].A2,
[CLIENT TABLE 2].ADD INTO [MEMBER CASE TABLE]
FROM [CLIENT TABLE 2] INNER JOIN [OPEN CASES] ON [CLIENT TABLE 2].MEMBER = [OPEN CASES].[MEMBER#]
WHERE ((([CLIENT TABLE 2].RELATION_CODE)="C")) OR
((([CLIENT TABLE 2].RELATION_CODE)="S") AND
([CLIENT TABLE 2].MEMBER_CASE_STATUS)="A"))
ORDER BY [CLIENT TABLE 2].ADD;
Using SQL To Change Txt Box In Form
May 10, 2005In the form that I am working on, I have a number of text boxes that are filled with a query telling me which people are scheduled to work a shift. I also have a text box (I may need to make this a sub form, but would prefer not) where I want a list of all available employees for the specific shift to show. When I click, I want to see the list, so that I can make changes if needed and only chose those employees that are available for the shift.
I have:
Private Sub Ctl8a_4pb_Click()
Me!txtAvailEmployees = "SELECT tblAvailabilities.Date, [First]+" "+[Last] AS [Full Name]
FROM tblAvailabilities INNER JOIN tblStaff ON tblAvailabilities.EmployeeNum = tblStaff.EmployeeID
GROUP BY tblAvailabilities.Date, [First]+" "+[Last], tblAvailabilities.Shift1
HAVING (((tblAvailabilities.Shift1)=-1))
WHERE tblAvailabilities.Date=[form]![frmScheduleEdit]![CalDate];"
End Sub
I get a syntax error. Is is even possible to pass SQL in a manner as this?
If it is, where would I be messing up?
On Change Question
Aug 11, 2006Greetings
I am grappling with a problem with some code I have put into On Change of a field
I set up the field with the following code;
Private Sub Location_Enter()
Dim sqltext
sqltext = "SELECT tbl_Data_Vessel_Barrel_Position.Position "
sqltext = sqltext & "FROM tbl_Data_Vessel_Barrel_Position WHERE (((tbl_Data_Vessel_Barrel_Position.InUse)=No)) "
If IsNothing(Me.Location) Then
Me.Location.InputMask = ">LL00000"
Me.Location.RowSource = sqltext
'Me.Location.LimitToList
Me.Location.Requery
End If
End Sub
This works fine as but the On Change command I use;
Private Sub Location_Change()
Dim db1 As DAO.Database
Dim rst As DAO.Recordset
Set db1 = CurrentDb
Set rst = db1.OpenRecordset("tbl_Data_Vessel_Barrel_Position")
rst.Index = "PrimaryKey"
rst.Seek "=", Me.Location
rst.Edit
rst!InUse = "0"
rst.Update
rst.Close
Set db1 = Nothing
Set rst = Nothing
End Sub
Must assume that the field has been changed is some way.
Can anyone spot or suggest how to rectify this problem.
Thanks
~rbinder