Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: cpc34
  • Order by date
  1. cpc34

    Excel - Convert a full date into just a month

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

    Making break in excel line, not giving zeros

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

    Making break in excel line, not giving zeros

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

    Unwanted lines at top and bottom of Word pages

    Idea 1 worked a treat. Many thanks.
  5. cpc34

    Unwanted lines at top and bottom of Word pages

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

    Two colours in a single excel spreadsheet cell

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

    Two colours in a single excel spreadsheet cell

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

    Excel: Want chart to be steps, not slopes

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

    Outlook 2000 indicating new e-mail but there is none

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

    Auto-size data range for Excel Chart

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

    Powerpoint: Changing hyperlink font colour

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

    Display all people, even if they have attended 0 events

    Many thanks. It worked a treat.
  13. cpc34

    Display all people, even if they have attended 0 events

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

    Refresh drop-down list

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

    Jumping straight to a particular text box

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

    Forcing user to enter something in a text box

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

    Forcing user to enter something in a text box

    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?
  18. cpc34

    Forcing user to enter something in a text box

    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."...
  19. cpc34

    Renaming datasheet entry using VB code

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

    Filtering Multiple Entries

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

Part and Inventory Search

Back
Top