Search results for query: *

Tried as you suggested but all values in the column are change and not the relevant ones...

Excellent - I'm getting there using Longhairs recommendations! Thanks to all who contributed as well - Couldn't get the conditiona formatting to work by the way... I have to run the Macro on each inidivdual cell I click on? How can we now get the macro to check the whole worksheet on open?

I don't seem to be getting anywhere - I'musing Excel 97 if this makes any difference?

To be honest I'm just using activecell to test my code - What I really want to do is check the whole column when the spreadsheet opens without selecting a cell...

Oh yeah sorry - I meant greater than the system date - changing the '>' to a '<' doesn't make any difference either...

Here is the code I've got - unfortunatley nothing happens!!! Private Sub Worksheet_Activate() Dim Today As Date If ActiveCell.Value < Today Then ActiveCell.Font.Color = RGB(255, 0, 0) End End Sub

I'm fairly new to Excel VBA - I have a worksheet that has a column of dates. What I want to do is as follows; If the value in the cell (formatted as date, 14-Jul-05) is greater than the system date then I want to turn the contents of the cell to red and in bold? I can turn the contents of the...

Well thats my question - I realise they ll have to be deleted but I can't see any option for it on the exchange server(5.5 by the way) and the originating persons email account has been deleted... Other people included in the meeting cannot outright delete all recurrences

It sounds like another program is being run when you open word - I know with office 2003 there is a lot more integration from anti-virus software - Do you have any AV running?

A meeting recurrence was sent and the owner has since left the company. Subsequently that owner has been deleted and the meeting details cannot be edited, i.e. the date and time that were set up to recurr every week. Any ideas anyone? How can we change ownership? Ideally I'd like to delete all...

Not sure whether this is an outlook issue but a meeting recurrence was sent and the owner has since left the company. Subsequently that owner has been deleted and the meeting details cannot be edited, i.e. the date and time that were set up to recurr every week. Any ideas anyone? How can we...

Bit of a strange one - Was doing a bit of admin checking which users had the biggest email folders in exchange and came accross a user whose email folder is around 800MB but the user is not listed in the GAL or recipients list and does not have an associated account in AD? Any ideas how to delete?

I am aware that there are issues with WPA and Windows 2000 but I am hoping for a work around.. I run a network with both 2K and XP machines. My login procedure involves 2K and Novell authentication. My client XP machines will connect using WPA (after I changed the option that let Windows take...

Is there a way to do this completely with GP? Basically I want to set up an OU within AD and add those users who cannot be trusted with the internet? Is there one specific policy that I can do this with or is it a combination of a few? Tony Incidentally I have no proxy - we use a Cisco PIX.

If you suddenley heard a loud bang that was the penny dropping! Cheers James

That works - only 1 record is updated and the table is storing data as it should but I'm getting the following? (1 row(s) affected) (1 row(s) affected)

Cool - now I'm with you cheers for that! (Noobs eh!)

The second insert comes from the trigger on the table as it modifies the table" Should read; The second insert comes from the trigger on the table as it modifies the information.

The trigger does insert one row the problem is there are 2 update queries. The first insert comes from the user when they select their booking. The second insert comes from the trigger on the table as it modifies the table - code as follows; declare @from_day datetime declare @id_booking int...

The first record insert still does have booking issue in that dates were being stored incorrectly but the second record that is inserted i(after my trigger modifies it) is fine and the data is stored as intended without any errors. So there are 2 records inserted, the first is wrong, the second...