Row Colours In Report

Oct 25, 2004

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 Replies


ADVERTISEMENT

General :: Logo On Report With 2 Colours One Word

Apr 20, 2014

I have a company logo that has 2 colours to its name

I want to put that logo onto me report. I have tried but I am unable to do this

company name APICAPACITORS, API IN RED CAPACITORS BLUE ,is it possible without making 2 words

View 1 Replies View Related

Tab Colours

Jul 7, 2005

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 1 Replies View Related

Colours

Feb 24, 2006

Is it possible to create a combo box showing colours. I don't mean the wors Blue, Red etc I mean a list of actual colours?

View 14 Replies View Related

Auto Colours??

Nov 18, 2005

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 2 Replies View Related

Scroll Bar Colours

Jun 23, 2005

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 1 Replies View Related

Access And Form Colours

Feb 28, 2005

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 3 Replies View Related

Alternative Colours In A Form

Mar 15, 2005

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 1 Replies View Related

Colours In Continuous Form

Dec 20, 2006

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 4 Replies View Related

Very Basic Question - Form Colours

Apr 3, 2005

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 1 Replies View Related

Changing Button Colours In Access

May 19, 2006

Does anyone know if the command buttons in access 97 forms can be changed?

thanks

View 4 Replies View Related

Reports :: Format 25% Of Records With Different Colours

Apr 30, 2014

How do I format:

First 25% of records - Gold
Second 25% of records - Green
Third 25% of records - Yellow
Fourth 25% of records - Red

View 4 Replies View Related

Relate List Of Colours To Unique Product Id

Jun 13, 2007

Hi.

I want to select a product then be able to select a colour from a list that relates to it.

I want the colour lists to be different for every product. (clothes)

Whats the best way to do it?

Thanks

Jonny

View 4 Replies View Related

Background Colours On Forms Other Than Normal Options

Aug 1, 2005

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 3 Replies View Related

Mouse Move Event To Lighten/Darken Colours

Dec 8, 2006

Hi guys,

i saw a sample DB here somewhere but cant find it now...on the mouse move event (when hovering on an image) it made the colours lighter (as if someone has shone a light on the button). Just wondering if anybody knows the code for this event?

thanks

View 2 Replies View Related

Forms :: Choose Custom Colours With Conditional Formatting

Sep 6, 2013

I'm using access 2003. I've got a textbox placed ontop of an image that I want to make it seem to disappear on a conditional format.

The back color property of the textbox I want to set is "13160660". How do I choose this colour when applying conditional formatting as I only seem to be able to choose from the swatch of 40 default colours and no option to define custom colours.

View 4 Replies View Related

Forms :: Allow User To Change Form Colours And Captions Each Year

Jul 28, 2014

My database has a front end that uses forms to allow the user to navigate within it, each year we create a new database which is based on the previous year's database but with all the variable information removed.

Within the database each form has a caption that starts with '2014-15' then goes on to say the form name.

Most of my forms also have a yellow background, (last year it was pink).

Both these areas were set up so that each year our users can distinguish between our databases, as they may have last years and this years open at the same time.

What I would like if possible is to know whether I can get a user to change both these things from within a form. So something along the lines of a button that when clicked would check all form captions and if within the caption it finds 2014-15 then change it to 2015-16 (or whatever the user specifies) but keep the rest of the caption.
I would also want the same type of thing to happen with the colour so again within the background of the forms, if you find colour X then replace it with colour Y.

If this can't be done within a front end form, then could it be done behind the scenes, and if so how would I go about doing it?

View 2 Replies View Related

Does MS Access Report Support Hide/Show Fields At The Report View Time?

Aug 19, 2007

Does the MS Access Report support Hide/Show specific fields according to parameters or even by click?

View 3 Replies View Related

General :: How To Make A Report Using Crystal Report Direct From MS Access Form

Jun 3, 2014

I'v looking for since a couple months a go to make a report direct from access form using crystal report but i havent found it yet. I'v tried this code and its giving me errors. " run time error 1004 method range of object _global failed "

how to make a report using crystal report direct from ms access as front end application ? is it possible to use crystal report ?btw i use database sql server 2008 and MS Access 2007 as my frontend application.here's the code that i'v found and gives me an error

Dim CR As New CRAXDRT.Application
Dim rep As CRAXDRT.Report
Set rep = CR.OpenReport(Range(" ??? ")) * i getting error in this line, what should i do to fill it ??
rep.ParameterFields(1).AddCurrentValue "Boston"
rep.ParameterFields(2).AddCurrentValue "Cars"
rep.Database.Tables(1).SetLogOnInfo "tool", "db_tsel"
rep.ReadRecords
rep.PrintOut promptUser:=False, numberOfCopy:=1 ' promptUser:=True doesn't work

View 2 Replies View Related

Forms :: Open Report Button To Select Data From 7 List Boxes And Present In A Report?

Aug 13, 2015

I have a form with 7 List boxes linked to 7 Query's which in turn are linked to a table. Each list box if for a particular trade.

I am trying to select a person or persons from each List box and then have them sent to a report. I have Code to do one list box, but do not know how to link all boxes with code to a 'Open report' button.

The code I am using is as follows:-

Private Sub cmdOpenReport_Click()
On Error GoTo Err_cmdOpenReport_Click
Dim strWhere As String
Dim ctl As Control
Dim varItem As Variant
'make sure a selection has been made

[code]....

View 9 Replies View Related

Reports :: Filtering Report To Only Show Current Month Report?

Nov 16, 2014

The aim of what I am doing is to create a monthly statement to give to our intermediaries that shows the commission they will receive each month for the deals they have referred. I have managed to create this report, HOWEVER I can't figure out how to filter out which month I need, so I a report for Jan, Feb Mar etc... The idea is that at the end of each month I need to run the report so only the latest month shows...

View 3 Replies View Related

Modules & VBA :: Programmatically Alter Detail Of Report Then Use That Report As Subreport

Jun 26, 2013

I have a report which programmatically sets the value of some labels based on its own internal logic for each line of the detail section of a report. This all works fine and dandy, using the Detail_format event, and accessing detail.controls.item(x).caption.

HOWEVER, when I then embed the report as a subreport (which I need to do), I goes wrong. Here, I get the values of the last row of the detail repeated in every previous one. I'm suspecting because the parent report has its own 'detail' (I've tried giving the subreport its own distinct detail name).

View 1 Replies View Related

Reports :: Hide Report Footer Based On Report Data?

Dec 21, 2014

How do I hide the report footer based on the report's data ?

I'm trying to hide if number of users = 1

The report's data is a query built inside the report's RecordSource, not a self standing query.

View 10 Replies View Related

Reports :: Unfiltered Report Footer Totals On Filtered Report?

Apr 10, 2014

I've done this once entirely by accident and can't seem to duplicate it...

I have a report. It has the following:

Report Header: Logo and title
Department Header
Supervisor Header
Group Header
Detail
Department Footer: Totals
Report Footer: Overall Totals for all departments

Here's my question.
I have combo boxes on my main form that filter this report. The combo boxes are referred to by the query that runs the report. How do I get proper unfiltered overall totals in my report footer?

View 4 Replies View Related

Reports :: Join Smaller Report On The Back Of Main Report?

Apr 18, 2013

I have a report that displays incidents, their details, consequences and a photo. Among the details is a severity rating high medium or low, I have been asked to make the report shorten the records which have been given a low severity (because it takes up as much space as the more important/severe ones).

The only method I can think of is to use the onformat event, to shrink and make invisible all the fields that I don't want to see if the severity field shows 'low'.

View 3 Replies View Related

Reports :: Select Records From Report To Populate Second Report?

May 24, 2015

We have a shift log that includes both personnel actions during any given day as well as operational actions. (We recently switched from a word document to an Access Database to allow multiple users to input events while another has the logbook open already (which you couldn't do with Word))

At the beginning of each day, my manager reviews the previous days log and forwards up pertinent data (some personnel, some operational) to our higher authorities. Is there a way to allow him to select which records he'd like to include on that higher-authorities report straight from the local-level report?

I'm not a fan of allowing him a "Save As" feature because that kind of defeats the data integrity purpose of an events log where he could save as an RTF and then edit any of the log entries without any checks or balances.

View 2 Replies View Related







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