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...
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:
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.
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.:(
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
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.
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.
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.
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!
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?
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.
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.
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
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.
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'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.
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.
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.
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.
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.
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?
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.
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.