Forms :: Changing Background Colour Automatically

Jun 16, 2014

Here, what I am trying to learn, that background of the form change its colour automatically after sometime let say 1 min or after 2 min

I find the link on the web where more than 500 colour code are available, but not sure, how I can use [URL] ....

I can put this command on form_load()
Me.Detail.BackColor = ?????????
but question is how i can bring other colour into loop

Plus, if the user want to do any work on the same form, will this loop also allow the user to do any work, I mean form should not be stuck up in the loop of changing a colour...

View Replies


ADVERTISEMENT

Changing Field Background Colour

Mar 31, 2006

I'm opening a form in snapshot view and would like the background colour of all the fields in the form to be a dark colour to show that it is in snapshot. the user then clicks Amend and the background colour would change to something lighter to show they can amend the record. Is there any way of on the OnClick event of the Amend button change all the fields (and there's lots) at once without having to name them all individually, ie:

Me.text1.background = whatever
me.text2.background = whatever

Thanks

View 2 Replies View Related

Forms :: Change Textbox Background Colour Pending Value Of Two Textboxes On Form?

Jul 9, 2013

I have a form with two textboxes that get their values from two different queries that counts records from table. If textbox1.value equals texbox2.value the textbox2.value back ground colour is green. If they are not equal textbox2.value goes red. Itried with using conditional formatting, but it doesn't work all the time as the form is not updating when it is opened.

View 4 Replies View Related

Tab Background Colour

Apr 26, 2006

This should be an easy one for somebody. I'm a newbie to access and I'm experimenting with a tabbed form. My problem is if I create a new form with (say) two tabs, the area to the right of the tabs(where more tabs would be inserted) is white and I don't know how to change it to blend in with the rest of the page. Hope I'm making myself clear.:(

View 3 Replies View Related

Background Colour

Oct 18, 2006

Hi
We have created some forms using (in some cases) the form wizard.
As you may know you have to select a "Background Style" when using the wizard.
Now we want to change the background from one of these styles to a colour - but when we select it in Properties and try to apply it, it seems to flicker but does not seem to have any effect.
Can anybody help us out please ?
many thanks
ajm

View 1 Replies View Related

Change Background Colour !

Jan 24, 2007

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

View 4 Replies View Related

Tab Control Background Colour

Apr 17, 2007

Hi all,

I have been searching for a setting that enables me to change the background colour of a tab control on a form. It may be something obvious that I have missed.

Changing the type to 'transparent' and setting the form background colour does not seem to work.

Any ideas?

Cheers,

Rob

View 5 Replies View Related

Unbound Subform Background Colour

Jun 27, 2006

Hi guys,

Something that's been bothering me. I have a unbound subform which acts as a placeholder for other subforms rotating on it (by changing the SourceObject), that way all the relevant subforms appear in the right place when required. It works great except, it's this great big white box and there's no option to change the background colour anywhere. I would like it to be either transparent or have an option to change it to the same colour as my main form it sits on.

Any way to do this?

View 2 Replies View Related

If NULL Then Change Background Colour

Aug 26, 2004

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!

View 4 Replies View Related

General :: Remove Background Colour When Outputting To PDF

Mar 20, 2014

I have a form with subform that uses colour as background colour for all fields on the form, and also a very light background for the whole form. This outputs very well to PDF, retaining all of the layout etc.

However, consisting of over 100 pages I do not want any colour at all in the printed report, no do I want the colour converted to black or grey. Inkjet cartridges are just too expensive!

Is there an easy way to remove all colour before printing or do I have to design another report?

View 2 Replies View Related

Forms :: Changing Environment Field Automatically In Report?

Feb 15, 2015

I have an Access database (.accdb) that has table, form and report. The field in all are the same. The user interacts with the Form only and enters data to it. Table is a back-end thing and no-one goes to it. However, in Form there is a button that when pressed, prints the report for that relevant form/record which we then give to customers.

Now, I have a field in report (like a signature field) that mentions the name of the user who printed that report. Lets say, Mr X did the data entry and then printed the report and gave it to the customer. After that customer loses the report and comes back for a copy of the report, but now Mr Y is at the desk and issues the report. Obviously Mr Y doesn't have to do the data entry again because record is there and Mr Y has the access to it, so he just presses the print report button and prints the report. What I would like is that the signature field should update itself if anyone else (in this case Mr Y) accesses the database and prints the report for that specific record.

View 3 Replies View Related

Changing The Colour Of A Textbox

Dec 5, 2006

Is it possible to change the colour of a textbox, after clicking on a command button?

View 1 Replies View Related

Changing The Colour Of An Item In A List Box

Sep 13, 2006

HI all, the objective is to grey out an item within a listbox, where the id number is the same in another sub form. The sub form is called contacts and the list is called list15. the unique id that is linking the two is SWD.

HELP...:confused:

View 1 Replies View Related

Colour Changing Fields In List Box

Mar 16, 2008

Hi there guys,

I need a little help on a little situation. Basically, my client for my school project wants to be able to see graphically if orders sent to their bookstore have been processed or not. So i suggested a change of cololour of the fields.

Now I have created a Form containing the orders as they are stored in a list box, (both already processed and unprocessed orders), now I want to be able to allow each item in the list box to be either Red (if unprocessed) or green (if processed) so the user can see which ones they need to deal with. Im guessing this would take some VB, but if anyone could help me, I would really appreciate it :).

PS, if you do provide VB could you please explain a little of whats going on as i have to annotate all the code I use and im not too profficient in VB

Thanks a lot

Dan

View 1 Replies View Related

Changing Colour In Datasheet View

Jun 27, 2006

Well, I got asked to do this with a datasheet view today, and I found after searching the forum that I'm not sure how to do it, and no one else seems to have done this either.

Basically I need to flag a row in a datasheet subform dependant on if a date field is more than 1 month ago and if the status field is set to pending. I looked at conditional formatting, but that only seems to let me set a condition on a single field at a time.

Any help would be appreciated :)

View 4 Replies View Related

Changing Text Colour Of Labels On Activate

Nov 23, 2005

Hi, im working on my school project for A2.

When the user clicks on say; the customer ID dropdown menu, i want the label text on the right of it to get darker (make it more visible). How can i do this?

(i have attached a picture of my form)

thanks, Robin

View 2 Replies View Related

Changing Command Button Text Colour.

Jun 30, 2006

Hi all,

I'd like to change the colour of the text in a command button when the user click the button, but for the text to return to it's original colour when the botton pops back up.

I'm assuming you use the following commands:


Private Sub cmdClose_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
*******CODE********
End Sub

Private Sub cmdClose_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single)
*******CODE********
End Sub


But I'm not sure as to how I would enter the correct code.

Any help would be appreciated,

Best Regards,

Aaron

View 2 Replies View Related

Lookup Field / Combo Box - Changing Colour Of A Cell?

Mar 7, 2012

I have a Lookup field/combo box and want to have the cell colour change if a certain word is chosen. if not then the cells stay the same.

i.e., if "cancelled" the cell turns red, if any of the other two options are chosen, then leave as is.

View 3 Replies View Related

Changing Background Color Of Tab Form

Apr 5, 2005

Hi,

I have design a form using the tab control. I need to add in color to make it more professional. Is there a way I can do it. I realised the filled /Back color icon is faded in color in design view.

Appreciate any help in this. Thanks.

View 2 Replies View Related

General :: Changing Font Colour Of One Record In Access Database

Jan 12, 2015

I would like to get a third party to edit a database and record those edits by changing the colour of the font. I know this can be done in layout mode, but it changes the font in all records, I only wish to change the font colour in one record, how I can do this, without changing all the records in the database.

View 3 Replies View Related

Changing Background Color Of A Record Based On Yes / No Value

Jun 26, 2013

I am rebuilding a file that deals with a lot of active and inactive accounts. I would like to change the inactive record to a yellow or red when a check box is marked. It has been about 15 years since I have written any macros or VB functions.

View 5 Replies View Related

!!!changing Font Colour - Simple Question, Quick Response Required If Possible!!!

Feb 14, 2006

i have a text box which displays the current stock level of an item, when the current stock level reaches 1 i need the font to change colour from black to red.
for example, if the stock is 2 - font is black
if one item is sold the stock will become 1 - font changes to red

how do i go about this? any help is VERY VERY welcomed and muchly appreciated. thanx alot.

View 2 Replies View Related

General :: Changing Column Colour In List Box - Alignment For Cells Data

Jan 7, 2014

How can change column color in list box and also how to make alignment left or right for cells data.

View 1 Replies View Related

Reports :: Changing Background Color And Text Format Simultaneously

Sep 8, 2013

How do I change the background colors and text formatting in all of the reports in one database at the same time? If this is not possible, is there an easier way to change the report formatting without going through every report?

View 2 Replies View Related

Changing A Field Automatically

Dec 7, 2004

hiya... he's my problem........

i have 3 tables: tblVolunteer, tblMedicalCondition, tblVolunteerMedicalCondition.

in tblVolunteer i have: volunteerID, volunteerName, HEALTHY (yes/no)

If a volunteer doesn't have a record in tblvolunteerMedicalCondition, i would like the HEALTHY field in tblVolunteer to default to 'yes', and if they do get a related record in tblVolunteerMedicalCondition, i would like the HEALTHY field in tblVolunteer to change to 'No' automatically.

How do i achieve this please..????

many thanks for viewing!!

View 1 Replies View Related

Changing A Field Automatically

Dec 7, 2004

hiya... he's my problem........

i have 3 tables: tblVolunteer, tblMedicalCondition, tblVolunteerMedicalCondition.

in tblVolunteer i have: volunteerID, volunteerName, HEALTHY (yes/no)

If a volunteer doesn't have a record in tblvolunteerMedicalCondition, i would like the HEALTHY field in tblVolunteer to default to 'yes', and if they do get a related record in tblVolunteerMedicalCondition, i would like the HEALTHY field in tblVolunteer to change to 'No' automatically.

How do i achieve this please..????

many thanks for viewing!!

View 1 Replies View Related







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