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...

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...

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...

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 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).

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...

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...

I am trying to find a way to get my database to recognise that a person I am adding to event D is the same person that attended event A. At the moment, when I put Joe Bloggs into a subform under Event D, it is generating a new Personnel ID, rather than realising that Joe Bloggs already exists...