Search results

Think i have understood this a little better now. The colours are listed further down the vb code so is it just a case of changing the 'colour no' in the function. ie.. =COUNTCOLOR(A5:I5,6,FALSE) - yellow =COUNTCOLOR(A5:I5,8,FALSE) - Turquoise etc... Thanks

Thankyou very much for that, bit mindblowing for someone of my level but thanks for this, it has helped no end I am very grateful. I can see how it is currently set up for colours Red, Blue and green. Is it easy enough to add other colours as and when they are needed?. Do i have to amend...

thanks for the help I tried to write it in the VB editor and then writing the =countcolor function in the cell but i am out of my depth of knowledge on excel. I would really like to know what it is that i am doing wrong (probably lots!). I have attached a sample form of the sort of thing i...

Hi thanks for the link. I have looked through it and think i understand that the query eg: =COUNTCOLOR(A1:A10,3,FALSE) may be what i am after as all i have is a straight line of different colours and wish to sum them, however when trying this calculation the spreadsheet doesn't seem to...

Morning all I was wondering if it is possible to count the number of (different on occasions) coloured cells within a spreadsheet. ie... Our company has a spreadsheet with a calendar and operatives colour cells 'red' if on annual leave, 'yellow' if on Training etc..... I was wondering if...

Thankyou neileg I have managed to successfully upload the data thanks. By daisy chain do you mean MON,TUE,WED etc..... I needed to report the information daily so this was the way i believed to be correct!. HOw would you of recommended this be done?. Thanks again Nathan

here is the database

Attached is a sample database and a sample of the data i am trying to upload. I have tried reformatting it etc and cannot get it to upload. Is it possible and if so how do i go about it. Regards Nathan

Thanks for the reply, I have tried that too and with no success. I have all the columns sorted and with the correct Cell format but for some reason i just cant upload the y/n fields!. Thanks again

Afternoon I have set up a table with the fields set as Long Integer and 2 decimal places. I have created a form to input into this field but for some reason the form will not allow me to input a decimal figure ie 1.50 etc..... When i input 0.50 it rounds it down to 0. WHen going into the...

Hi I had a similar issue some weeks ago and i was told to try: Private Sub Form_AfterUpdate() Machine1Endfigure.DefaultValue = """" & Me.Machine1Startfigure & """" End Sub Worked for me, not sure if its exactly what your after but no harm done if not. Regards

Morning. I was wondering if anyone could possibly assist me. I am trying to upload data from Excel into Access tables. I have successfully uploaded all the data apart from the Yes/No field. I have tried putting Y/N and Yes/No and neither is correct. Is this possible to do and if so what...

Cheers That has resolved my issue perfectly. Thanks to all

Where do i find the bound field in the form?? When i go into the form design i can only see the bound boxes that i am using. the field i want to delete is not one i am using and is hence not visible. Should i be looking somewhere else? Thankyou for your help

Hi I have created a form using the data from a table. When creating the form i have not used all the fields from the table. I have gone and amended the table by deleting a field i no longer require and now when i launch the form it asks me for a 'parameter value' for this field that no...

apologies Should be now!

Afternoon I have a problem that i am unable to resolve and asking for some assistance. I have attached a database whcih has my problem. If you click on the form 'Input HAVS Information' and when inputting a new record you will notice that the first 3 input boxes are carried through to the...

Thankyou for the guidance it was very useful. However i must be doing something slightly wrong with regards the comboBox field. I have written the following code: Private Sub Form_AfterUpdate() OperatorID.DefaultValue = """" & Me.OperatorID & """" Clock_Number.DefaultValue = """" &...

Afternoon I was wondering if it is possible to maintain the detail of some of the fields within a form (When inputting data) when you select to move onto the next record. i.e. If you have four fields. (all fields are selections from a combo box. ie Days of the week) Field A: Monday Field B...

Thank you for your help. I have got to expand this database to inputting time information daily with you suggesting thinking high and narrow rather than short and wide Maybe i could ask for your opinion on how it is best to achieve this?. I basically need to amend the 'HAVS input' form to...