Search results for query: *

I need to pull a series of dates into days, months and years: ie. 25/01/03 into 25, 01, 2003 in 3 columns. I can get 25/01/03 to display as "January" by choosing a custom format (mmmm), but the underlying value is unchanged. If I "paste value" I get 37646. Is there a robust way of turning that...

Thanks. That's better now. It now ignores the invalid values, but interpolates a straight line instead. Different question, maybe, but can the colour/style of part of the line be changed to show that it is Invalid. Ideally, I'd like it to remove that section of the line altogether, but I'm open...

I am plotting a graph of x vs y, where the y value contains an IF statement. It tests whether a certain value is valid, and if it is not I have it displaying "Invalid". My output is therefore a series of values with a few "invalid" cells. My problem is that when I plot this, Excel assigns these...

Idea 1 worked a treat. Many thanks.

I have a bit of a bug that has appeared in my Word document. I am using my company's template for formal reports, but at some point (i think while I was pasting in a table) black lines appeared half an inch from the top and bottom of each page. They are totally inaccessible to me, whether in the...

Thanks CMP. Working nicely. I've changed vbYellow to RGB(255,204,0) to match with the Gold colour I'm using elsewhere. Only problem is that it gets very confused if you try to apply it to a merged cell. Oh well, we can't have everything!

Is there a way of having two different colours in an excel cell? I am assessing some data using red/amber/green traffic lights, but I would like a way to indicate red/amber or amber/green. My thought was a diagonal divide across the cell with one colour in the top left and one in the bottom...

I have a cumulative chart, which shows the total attendances at a certain type of event over time. I want it to show attendance going up step-wise when each event happens (ie. holding at 6 people, and then jumping straight to 9 people). Instead, it makes a straight-line slope between each...

I had a similar thing happening when I turned tracking on. It would beep, an envelope would arrive, but the "Message delivered" message would already have been moved to my deleted messages folder.

I am outputing data from Access into Excel in order to show how the data changes over time. I have produced a Chart in excel to do this, but I don't want to have to change the data range every time I re-generate the data in the spreadsheet. Can Excel automatically fit the data range around the...

How can I alter the colour that hyperlinked text appears as in Powerpoint? At the moment, regardless of the original font colour, the hyperlink text looks purple (turning to yellow after it has been clicked, which is really bad for presentations).

Many thanks. It worked a treat.

My database stores people and the events they have attended. I have a group of 100 people in the database and want to count the number of events each has attended. I have the total list of people in "People list", a list of events in "Events table" and a linking table (which has rows that store...

Is there a command that refreshes a dropdown list? I am adding new entries into form A and I want the new name to appear in the list in form B without having to close down the form and reopen it.

On opening a form, I would like the cursor to be in the "Name" text box. Is there some code I can put into an Open event to do this? Also, is there a way of automatically placing some text in that same text box? I have a main form that opens an "Add user" form if the name that is put into the...

Many thanks everyone. Put the If loop in the OnUnload event, using BuilderSpec's Cancel = -1. Seems to work beautifully now.

Thanks all. I have tried FancyPrarie's way. However, after clicking OK on the message box it still seems to close the form. Am I doing something wrong, or do I need to insert something to undo the "Close" operation?

I have a text box in a form that I want to force the database user to change. I have put a default value in the box (Clock No.), and in the "on close" event I want to put an IF loop in so that when you click on the cross in the top right corner it checks if the text box still says "Clock No."...

I want to be able to do the following: type a new entry into a datasheet column, which brings up a form when that enty is not found by using the "Not in list" event. On closing that form I need some code that renames the entry I have just types to, say, "Name". Is there a way to write code that...

Is there a command that will allow me to bring up a query that shows only one occurrence of a name? The form it is looking at has the same names occurring repeatedly. Also, is there a way of getting the same query to count the number of occurrences, so that it sas something like: Person A, 5...