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 Replies


ADVERTISEMENT

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

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

Populating Form - Combo Box Or Alternative?

Aug 28, 2006

If any one can make a suggestion it would be great. I have a list of names with phone numbers, addresses and emails. I thought I could use a combo box to select the name and and have the other date associated with it come up in the appropriate boxes set. I can't get it to work. Does any one have any suggestions on how to make it work or another method that can be used. The out come I want is to allow someone to pic name from a list which will then set the phone number, address and email correct. Ideas would be great.

Thanks Tracey

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

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

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

Alternative To Replication?

Dec 15, 2005

I am having multiple user problems with access 2000 quite frequently, and I thought that replication would solve this, as it stands however its proving difficult to get my hands on the developer edition, just wondering, is it worth the hassle to get it, or is there an effective alternative to replication?

View 6 Replies View Related

Is There Alternative For This Code

Feb 22, 2006

The following is loaded in a query:

The field is called CS:
Like [Enter Specialist Last Name Only] & "*"

It works ok, but of course if you don't type anything it will bring all the records up for view, and I don't want that to happen. Can I do something that won't make that happen?

View 4 Replies View Related

DDESend Or An Alternative

Jan 23, 2008

I want to be able to use something like DDESend for putting data into word bookmarks. I already have several instances where this is done with code but I need some others with a simple thing like DDESend.

The problem I have with DDESend is when the form opens a box pops up asking if the Word file is to be opened. I tried with code to first open the Word.doc file and then have the code open the form with the DDESend text boxes but that ends opening two instances of the same Word.doc and the screen all quivers:D

If I just open the form in question and then click OK to open the Word.doc, then close and reopen the form (but without closing the Word.doc, just shrinking it) then all is well. But it is not practical to do that for what is wanted.

Any ideas or an alternative to DDESend. An alternative would need to be simple like a DDESend in text box as it requires someone to be able to easily change field references.

View 2 Replies View Related

Alternative To Listbox?

Oct 9, 2007

Hello

I am designing a database in which I have used a lot of listboxes sourced to tables. I need to run queries on the listbox results but this doesn't always work due to the listbox/query issue, (found on this forum).

Is there an acceptable alternative to listboxes as the only thing that I can think of is to use checkboxes which would make the data entry for the end user interesting? (The only way around this would be to have individual databases for each person, this defeats the objective of having a database...)

Many thanks

Loopster

View 3 Replies View Related

Alternative SQL Query

Jun 19, 2007

I have a query worked out with the exact result I'm looking for, but it's kind of slow. Can someone find another way to write up this query?SELECT EID, ShortName, ClassID
FROM (
SELECT Employee.EID, Class.CID, Class.ShortName
FROM Employee, Class
) AS Temp1
LEFT JOIN [Class Attendance]
ON (Temp1.CID=[Class Attendance].ClassID) AND
(Temp1.EID=[Class Attendance].EmployeeID);The inner (green) query pairs every employee with every class they could possibly take (cross product). Then that query is joined with the attendance table to show who has taken which class. If a class hasn't been taken the ClassID will be null like so:EID ClassID ShortName
=========================
111-11-1111 1 ISM
111-11-1111 2 ABC
111-11-1111 BGP
222-22-2222 ISM
222-22-2222 2 ABC
222-22-2222 3 BGPSo is there an easier way to get this result?

View 4 Replies View Related

IIf Or An Alternative Function.

Nov 23, 2007

In a table with 5000 records there is a field named "products" with 800 differents products (product1, product2, … product800).
I want to create a new field in a query and mark 100 of these products as "Not available" and the rest 700 as "Available".
For a small number of products I can do this in QBA, using IIf function.
E.g. Products not available:IIf([products] ="product5";"Not available"; IIf([products] ="product10";"Not available"; IIf([products] ="product22";"Not available";"Available"))).
How can I do this for 100 products
Thank you.

View 3 Replies View Related

Alternative Printer

Nov 6, 2006

I wish to send a report to the PDF printer driver but DO NOT wish to switch the default printer settings. Having found some helpful code on this forum that changes the default printer to the PDF driver, prints the job and then reverts the default printer back to the original printer device.

I am still using Access '97 and although in the code, the default printer does revert back to what it was originally, the Default Printer status 'tick' no longer appears under Start/Settings/Printers.... Consequently, subsequent print jobs outside of Access go to another device and not my DEFAULT printer.......???

Any ideas would be gratefully appreciated.

Oh - in case I wasnt clear - I want to do this in code NOT using the Print dialog box.... !

View 1 Replies View Related

MS FlexGrid Or Alternative

Mar 14, 2006

Hi,

Can I use MS Flexgrid in MS access ? When I try to use it, it shows I need licence. Is there any alternate method to use flexgrid or is there any alternative ? Basically, I need to facilitate edit and save option for users. Urgent help required ?

View 6 Replies View Related

Alternative To Application.FollowHyperlink

Jul 28, 2005

Hi!

I have a helpfile that I want to open on a Event. But when i use Application.FollowHyperlink I get an annoying warning (the file can contain viruses or in other ways damage your computer) so I wonder if there is another alternative to Application.FollowHyperlink?

Thanks,
Johan Hjalmarsson

View 1 Replies View Related

Help Needed With Security Alternative

Jul 28, 2006

Hi

I have a custom login screen created for my database and a table with access levels for different users. I am trying to assign user permissions so that certain buttons on the switchboard are visible/not visible dependent on the user security level. As the login screen and the switchboard are on seperate forms, is there any way I can do this??

I've been pulling my hair out since last night so any help at all would be appreaciated

cheers

View 8 Replies View Related

Workgroup Security Alternative?

Apr 21, 2005

I was looking for free access add-ins through a search engine when I came across this site. I'm not sure whether or not some of the more seasoned programmers have seen this, but so far it looks like a less confusing alternative to the security features that access comes with. I'm not in any way advertising this, and I haven't tried it myself yet, so I can't speak about how good or bad it is, but it may be something worth looking into. Here are the links:

http://www.accesswizards.com/Downloads.html This lists the add-ins that are available from this particular site.

http://www.accesswizards.com/SecDetails.html This is the "read me" information about the security add-in.

View 1 Replies View Related

Can't Create MDE File - Alternative

Dec 7, 2005

I have tried to create an MDE file for my database but can't figure out why it will not let me. I can't don't think I am over the limit in open TableIDs. I have 76 Forms and 91 Tables.

I am setup with two databases - the database with the data is on the server. Is there any other alternative that I can do other than putting the mdb file directly on the client. And if not is there a way to stop the mdb file from constantly growing in size.

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

Subdatasheet Not Sufficient, Please Give Alternative

Dec 28, 2004

What I am doing, is I have various products with 5 basic fields. I then wanted to add an array of text fields to 2 of those original 5 basic fields. I attempted to do this with a subdatasheet, however, a subdatasheet is not record specific, is not directed to a specific field, and really does not do anything that I want.

Say that the basic field is ProductDescription. I want one column of fields to correlate to it, like below.
ProductDescription
Is blue
Is large
Is heavy
Is strong

Each product will have a different amount of varying descriptor fields. Once understand how to incorporate this with my project, I then will need to understand how to add the subdatasheet to a report easily. Thanks for any help,
-SethTherrien

View 3 Replies View Related







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