Row Colours In Report
I got the following code from:-
http://www.microsoft-accesssolutions.co.uk/alternate_row_colours.htm
This is to give me alternating row colours in report detail section but cannot make it work.
Please could someone tell me where I am going wrong?
Not sure where to put the bit "Private m_RowCount As Long"
The Rest apparently goes in the report detail section OnFormat event.
Private m_RowCount As Long
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
m_RowCount = m_RowCount + 1
If m_RowCount / 2 = CLng(m_RowCount / 2) Then
Me.Detail.BackColor = 15263976 'Change value to the color you desire
Else
Me.Detail.BackColor = 14811135 'Change value to the color you desire
End If
End Sub
Thank you Guys and Gals.
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Tab Colours
Hello. I have just added some tabs (pages) on one of my forms. The problem is that the background is gray and I cannot seem to change it. How would I go about changing the background colour of each seperate tab(page)???
View Replies !
View Related
Auto Colours??
Hi all, Is it possible to have different colour fonts in forms automatically? i want the user to add numerical data into the form but the middle numbers must automatically be coloured red. these numbers are then matched to stickers in the same format for easy identification. it should look like this 878802 any suggestions? Many Thanks Sam
View Replies !
View Related
Scroll Bar Colours
Is it possible to change the colour of scroll bars in subForms? Seems odd that you can easily customise all the colours, yet have to settle with a horrible looking grey scroll bar! Any help or a 'work-a-around' to the problem would be welcomed. Thanks
View Replies !
View Related
Access And Form Colours
Hi there, I have being creating some forms with Access 00/02 and I have come across one for me particular strange and somehow annoying item “Colours”. My question here now is, how would it be possible to use instead of the say ”Back Color: 65280 numbering” a colour scheme similar use in web design i.e. hexadecimal or where at least could I find a list of colour numbering??? as used in Access. Thanks aktell
View Replies !
View Related
Alternative Colours In A Form
Hi I've got some code from http://www.lebans.com/alternatecolordetailsection.htm It allows for alternate bands of color to be displayed for alternative records in Forms in Continuous View. I've looked in this forum for other alternatives to this but the only ones that are available change the background of a control rather that display a whole row that is filled with colour. So therefore the background of the row is say in red, the background of the text controls are in red. I've managed to put the code into my form and download the class. The only problem is that I can't seem to set the colour in the actual class file - it's all a little bit confusing! Can you help? Pleaseeeeeeeeeeeeeeeeeeeeeee........... :D You can download the sample database from http://www.lebans.com/alternatecolordetailsection.htm :)
View Replies !
View Related
Colours In Continuous Form
Hi, I have a continuous form which has a combo box limited to green, blue, yellow, red, purple and N/A (for blank). It is possible to make the back ground colour = what is entered into the combo box? I have been searching and searching and have seen conditional formatting everywhere but it wont help as i need 6 options. I only have basic VB skills and usually can only hack and change not write from scratch:o Anyone able to help me please.
View Replies !
View Related
Continuous Form Background Colours
Hi, I have created a continuous form, and using conditional formatting I have mde the background colours of the cells change due to their value: <2 2<[value]<4 >4 The code I have seems to work but the whole column of values are the same colour depending on the top entry, other cells are the same colour even if they are different values. If I click on a cell of a different value, then the whole colum changes again to the criteria of that particular cell. I cant seem to work it out! Can anyone help!!?
View Replies !
View Related
Colours Change To Monochrome For One User Only!!
I have designed an Access 2003 application that has several forms with different coloured backgrounds. I also have warning text messages in red. Most users can run my application without any problem. However, one user gets what is an almost monochrome version of my interface. The red text comes out as black. The coloured backgrounds are either white or light grey. She is running Windows XP on a Dell laptop. Display settings are for 'true color'. I have not had the time to do a side by side comparison with a 'normal' PC, but I suspect that some websites are displaying with fewer colours than normal on her laptop, so it may not actually be an Access issue. Any suggestions as to what might be causing this effect? David
View Replies !
View Related
Very Basic Question - Form Colours
Hey, Got a simple question really... Designing a form and I have boxes where the data is entered. The form background is grey and i would like the data boxes to be grey as well, unless the box is "active" meaning its selected. ive done it for one form but i can't remember how on earth i would do it on another from i need to do. Many Thanks
View Replies !
View Related
Background Colours On Forms Other Than Normal Options
I'm wanting to get a very, very pale shade of gray as the background colour for an Access form, as well as for several text boxes on it. This is so that users can distinguish editable regions (white bgs) from uneditable ones (light gray bgs). The default colours that pop up in the menu choices are too dark for this. I've tried using a tiled image for the background of the form, which works fine. But I'd like my uneditable textboxes to be selectable (so users can copy data) whilst being that colour too, which can't be done. Therefore I'm looking for either the number code for a very very light gray colour (Access' default lightest is "12632256") or some sort of translator tool to let me know how on earth these numbers relate to anything in computing -- I mean, what do those numbers represent? Are they html=no, hex codes=no, rgb values, no... I mean, how is Access coming up with those numbers? I've tried just getting a light gray using trial and error and can't figure it out (even ended up with lime green at one point - very nice on the eyes lol). Anyone shed some light on this? :rolleyes: :D
View Replies !
View Related
Send Outlook Email W/ Report Attachment Only To Names On The Report
I have an Access 2000 database that tracks employee performance review dates. The employee table houses the employee name, employee id, their Group Leader, and Team Leader. Another table houses their employee id and performance review dates. The report shows employees, grouped by a combination of Group Leader and Team Leader, who are past due on their performance review dates. The report displays all the fields mentioned above and is built on a query. What I would like to do is send an automatic email to any Group Leader or Team Leader whose name appears on that report when it is run. I toyed around with automated emails a bit and was able to create a macro that worked, but it would have required me to list every possible GL or TL name, thus they would all get the report. However, I only want to send an email to Team Leader Joe Smith if one of his employees, and thus Joe Smith's name, is on the report. If he's not on there one month, he shouldn't get an email. Any recommendations on how to accomplish this?
View Replies !
View Related
Send Report, Receive Report, Update Info.
Hi In MS Access. I know how to send the report in rtf format. Suppose I send the report to the someone, then the guy add data, and send back to me, I want to update the info. in the database, so how can I retrieve the report from E-mail to the database. Thanks a lot. Thanks.
View Replies !
View Related
|
TRACKER
