Forms :: Change Background Color Double Click Event?

Jul 13, 2015

I am using a continuous form and would like my users to be able to change a field background color to a light red by double-clicking. The user would also be able to change it back to white by double-clicking again.

The code I am using (below) changes the field background color for all records. I need my code to only change the field color of the current record and cannot seem to find how to do that. The field name is [System_CurrentStatus].

Private Sub System_CurrentStatus_DblClick(Cancel As Integer)
If Me.System_CurrentStatus.Backcolor = vbWhite Then
Me.System_CurrentStatus.Backcolor = RGB(234, 154, 160)
ElseIf Me.System_CurrentStatus.Backcolor = RGB(234, 154, 160) Then
Me.System_CurrentStatus.Backcolor = vbwhite
End If
End Sub

View Replies


ADVERTISEMENT

On Click Change Form Background Color?

Apr 30, 2006

I searched around but i couldnt really find or atleast understand how to do what i want to do. I want upon the user clicking on a checkbox for the background of the form to change to a set color?

View 8 Replies View Related

Forms :: Event Procedure For Double Click

Mar 24, 2014

I am having a problem in my access database. I have a a form called Compliance Register. When this window opens it lists all of the requirements of a particular department. There is an ID and Source ID(this field can contain the same number such as multiple 17's). The descriptions match up to what is supposed to be shown. However when I double click on the item, it brings up a Compliance Status window. This is where things go wrong.

It shows the status listed as the first Source ID that matches the number, but does not seem to also be matching up the ID as well It must match both ID and Source ID since Source ID can have the same number multiple times down the list..

Here is what is under the Event Procedure for the double click.

Private Sub ListRequirements_DblClick(Cancel As Integer)
On Error GoTo Err_ListRequirements_DblClick
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Compliance Status"

[Code] ......

Under stlink criteria, i need it to not only pull the ID, but it has to have a "AND" Source ID. I need it to pull the record that matches BOTH numbers.

View 9 Replies View Related

Forms :: Textbox Background Color Change Dependent On Value

Oct 3, 2013

I have a question related to a textbox on a form.

In my table (tbl_data) I have a field named Rating. This can be anything from 1 - 10.

On my form (frm_input) I have a textbox (created using the wizard so at the moment I'll call it txt_Rating).

What I would like to know how to do is:

If the value in the textbox is 0-5 leave the background colour of the textbox white with black font.
If the value in the textbox is 6-7 turn the background colour pale yellow with black font.
If the value in the textbox is greater than 7.1 turn the background colour Red with white font.

View 3 Replies View Related

Forms :: ListBox - How To Change Selected Row Background Color

Mar 24, 2014

I have a listbox and whenever I clicked on a row it will highlight black background and white font color. How can I disable this or change the formatting?

View 2 Replies View Related

Forms :: Double Click Event Of Form Header

Nov 17, 2013

I want to add an event on Form Header when double click it will filter the values, which i did with macro, but could it happen on second time double clicking it it refreshes whole as original?

View 2 Replies View Related

Forms :: Change Font And Background Color Based On Date?

Mar 28, 2013

I would like to change the Font and background color based on dates.

-I have a text box (Training Event) on a form populated from a field (Training Dates) in a query.

- I need the font and/or the background in that text box to change to red when the date is 12 month past, yellow 11 months past, white 10 months past and green for 9 months past.

View 3 Replies View Related

Forms :: Selecting A Record From Listbox - Double Click Event

Jan 3, 2014

I would like to select a record on an already open form called "form_candidates" using a search facility but can't get it to work.

In "form_candidates" the data settings are set to "yes" (filters/edits/deletions/additions) and data entry is set to "no". On opening, the form is set to go to a new record.

In this form I have a button that opens a record search form so both forms are now open. I enter the first few letters of the surname into a text box, press a button and the listbox is populated.

In the doubleclick event of the list box I have the following code:

Dim CandID As Integer
CandID = Me.List4.Column(0)
DoCmd.OpenForm "form_candidates", acNormal, , "forms![form_candidates]![Cand_ID]=" & CandID

So I double click on the record, the candidate form is being filtered but the record isn't being shown.

View 3 Replies View Related

Forms :: Continuous Form - One Field Change Background Color / Current Record

Jul 28, 2014

in a continuous form i want to click on one record and have the one field change the background colour to highlight it. When I use the code: Field. BackColor = vbYellow it changes the background on all the records. Is there a code to say only for the record with focus?

View 1 Replies View Related

Forms :: Change Image Back Color On Click

Apr 30, 2014

I have images in my form, say, Image1 and Image2 . The default background color for all of them are white. If the user click image1, the background color has to be red. If the user click image2, the background has to change to red and the image1 retains its default color ( White ).

I have six images to loop through these. Image1 to image6.

View 8 Replies View Related

DAP Help!! -- How To Change Color Of Background

Sep 21, 2006

I have a Data Access Page that I need some help with some of the code.

I need to do a comparison to see if the TimeStamp Control is less than one hour old. If it is, it should have the background turn red. If not it should stay white.

Form = BLine_Messaging
Control = TimeStamp



Code:<SCRIPT language=vbscript event=onload or=window><!--If (BLine_Messaging.TimeStamp.value > DateAdd("H", -1, Date)) THEN BLine_Messaging.style.backgroundColor="white"else BLine_Messaging.style.backgroundColor="red"end if --></SCRIPT>

View 1 Replies View Related

Way To Change Background Color

Aug 26, 2015

I have installed Windows 10 & Office 13.The Background color of MS Access 13 is white in color which is irritating. Is there a way to change the background color?

View 7 Replies View Related

Double Click Event

Jan 17, 2005

Hi,

I have a form which has a tab control on it. The form itself is based on 1 table (tblCustomers). The tab control has 2 pages.

Page 1 shows 6 fields from tblCustomers.

Page 2 of the tab control shows 2 embdedded forms. Those forms are based on queries created from tblCustomers. one shows records with a date entered into one of the fields, the other shows records that have no dates.

What I want to be able to do is when I see a company name in one of the ebedded forms (Page 2), I want to be able to double click that record and it switches me back to Page 1 and shows the the related details of whichever company I double clicked.

I have changed the double click event in the emdedded form and using the builder to create something. I also added a setfocus command as I read about that somewhere (but i have no idea what it does). Through this I managed to get it to switch from Page 2 to Page 1 when I double click, but it only ever takes me to record 1 regardless of which company i double clicked.

i may have this deisgned totally wrong so please feel free to point me in the right direction.

any ideas?

thanks in advance

View 1 Replies View Related

How To Change The Background Color Of A Selected Row

Oct 25, 2005

:confused: <b>Hi all, can Access highlight the selected rows in table just like the spreadsheet in Excel??

Many thanks,

View 3 Replies View Related

Change Background Color Of Text Box?

Aug 26, 2003

I need to change the background colour of a text box after a change to the field has been made?

ie.

Make: IBM (Background Color Grey - Default)

User makes a change to Make ..

Make: Toshiba - (Background Color changes to Yellow )

I'm trying to code this with the OnChange option on the TextBox but can't see to find the right code.

I was using Application.SetOption"Background", colour value with no success

View 2 Replies View Related

Forms :: Double Click Event - Form Showing 1st Record Instead Of Selected Record

May 8, 2014

I am new to access and I recently encountered a double click issue

My form loads perfectly on double click event but it shows the first record instead of selected record.

My search is based on a PersonID but each PersonID has different WorkID that I wish to display on double click but it always shows the first WorkID instead of my selected record

I have tried changing the filters in the form properties but it still doesn't work for me.

Here's my code:

Private Sub SearchResults_DblClick(Cancel As Integer)
DoCmd.OpenForm "WorkForm", , , "[PersonID]=" & Me.[Searchresults], , acNormal
End Sub

[Searchresults] draws information from my Query

Query information:

PersonID... WorkID... Type......Location
1234..........1............Paint .....Address A
1234..........2............Electric...Address B
1234..........3............Floor..... Address C

View 7 Replies View Related

List Box Double Click Event Please Help

Feb 12, 2006

Please see attached database

Main form is frmPatients

If you click on the main form called frmpatient you will see 2
text boxs one called Primary Insurance the other Called Secondary Insurance

Above those text boxes are to hyper links which open the list box


What I'm trying to do is if a user double clicks the name of the Insurance
From the List Box it will insert that Name of the Insurance Into either
The Primary Insurance or Secondary Insurance Text Fields

I do not Want to Use combo Boxes because I have about 1,000 Insurances in my database.


Please Help

View 3 Replies View Related

General :: Change Access Background Color

Aug 18, 2014

I'm using the changebackgroundcolor.zip sample that I found here at Lebans site. URL....I'm trying to find a way to keep the color that I picked after the database closes. I tried to follow the example here URL....but couldn't get it to work.how to get the color to stay on the color that was picked from the dialog box?

View 1 Replies View Related

Modules & VBA :: Combo Box Does Not Want To Change Background Color

Mar 1, 2015

I have some code to check a combo box if a date field is filled in, then the combo box can't be empty.I can make the error message appear, but the combo box does not want to change color and it does not recognize any other than value..This is the code that I have, and it does not work like I wish it could.(I took the database over from some one else and need to make improvements on it. the field names where not created by me).

Code:
Private Sub cmbCurrentStatus_AfterUpdate() '<<<<<<<<<<<<<<<< Working on >>>>>>>>>>>>>
If IsNull(Me.[STEP 1 4 check current status]) And Not IsNull(Me.[Checked__date_]) Then
MsgBox "Checked (date) can't be empty if Current Status is filled in!", , "Incomplete Form!"
Me.[STEP 1 4 check current status].Value = RGB(255, 0, 0)
Else
Me.[STEP 1 4 check current status].BackColor = RGB(255, 255, 255)
End If
End Sub

View 11 Replies View Related

Cant Work Out Double Click Event For Treeview 6.0

Dec 11, 2007

HI all

I have managed to populate a treeview with some menu items I required and it looks great but I now need to get it to do something. How do I get a tree view value (selection) to act as a variable in routine. e.g. if my tree look like this.

Menu
¦
- Compaint management
I
I----My compaints


When I "double click" on My Complaints I want it to a open a specific form. One I know how to do one action I should be able to figure the rest out for myself.

Thanks everyone. :-)

View 2 Replies View Related

Change Background Color Of Form Based On Data

Mar 6, 2008

Just wondering... is this possible.

I have a database with 200 clients. If a user pulls up a record and the customer's insurance has expired, is it possible to change the background color of the form so that this automatically alerts the user that this customer needs to be contacted and the record needs to be updated?

Or are there any other suggestions that may serve the same purpose?

View 1 Replies View Related

Modules & VBA :: Report Background And Foreground Color Change

Jun 21, 2015

how to change background color of MSAccess Reports using VBA? How can I do border coloring. What are the vba codes for all color options like light green, light blue etc. How to change the font type to bold etc using vbaI did some changes to text box coloring in Detail Section on format click event.

View 3 Replies View Related

Queries :: Change Background Color Of A Query Cell If Certain Criteria Met?

Aug 14, 2015

Is it possible to run a query and have the background color of the query field be highlighted if a certain criteria is met?

I'd like to use the expresion builder if possible.

For example if the values in field A and field B do not match, then field C should be a yellow background.

If this is possible, how is it done?

View 1 Replies View Related

Change Field Background Color Based On Query Results

Jun 24, 2014

I would like to change the background color of a field that is the result of a Unique Values query. I am trying to get a list of invoices where all the line items are approved. I can't seem to get it to work the way I want because if even one invoice line item is approved it will show up as approved.

Is there a way to change the background color of the invoice field to red if ANY of the Approved line items are = False

View 7 Replies View Related

General :: How To Load Data From Listbox Double Click Event

Aug 22, 2014

Is it possible to load the data in input from by double clicking on data from list box ?

I have single form on which both input form and read-only form is present. as i used visible property to display or not accordingly.

User enters the data from input form. (It has been done)

User go onto read only form where combo box and list box. from drop down values load into list-box. (It has been done)

Now double click on any record then it should re-directed on input form with loading the data in editable mode for updation purpose. ???? (How this step will be done) ?

View 9 Replies View Related

Reports :: Opening Form Based Off Of Double Click Event On Report

Aug 15, 2013

I have a main Form "Client" that shows details such as Representatives, phone numbers, status, etc. I also have a main report "CRM" that is a nicer summarized table version of all of my Client form entries.

The "CRM" form will be used by others in my office to see what clients we are contacting, etc. What I want to be able to do is have someone open the CRM form first. If they want to see even more specific info (not everything is included in the report, as that would be too messy), I want them to be able to double click the Client's name on the report and be taking to the corresponding entry on the Client form that shows more details.

Right now my code for the Report which is not working is the following:

Private Sub Client_Name_DblClick()'double click on a client name in the reportDoCmd.OpenForm "Client", acNormal, , "[Client_Name]='" & [Client_Name]'this should open the Client Form to the record of the same client that was double clicked on the reportEnd Sub

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved