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!

  • Congratulations TouchToneTommy 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: *

  1. iansmithwolves

    Oulook inbox addresses

    Hi I have a number of bounced emails in my inbox. Is it possible to extract the addresses from these and export them to excel? Thanks and merry Xmas Ian Wolves England
  2. iansmithwolves

    GROUPING ACCESS 2003 QUERY

    I have several items with the same name in an access 2003 query, ie several enteries for the same company. Is it possible to group them under one heading as is possible with Crystal? Thanks Ian Wolves ENGLAND
  3. iansmithwolves

    access

    how do i find identical entries of 10 letters or more in a query?
  4. iansmithwolves

    Removing rows from excel

    Hi Is there a macro which will remove every other line from a spreadsheet? I have one which has a row between each row of data which needs exporting to another one without the spaces. Cheers Ian Smith Wolverhampton England Happy Christmas
  5. iansmithwolves

    unwanted parts of excel

    I have a spreadsheet and I want to get rid of unwanted rows and columns from the screen which are not part of the actual spreadsheet. Can this be done? Ian Wolves England
  6. iansmithwolves

    Deleting Unwanted Cells in Excel 2003

    Hi I have a spreadsheet and I want to get rid of unwanted rows and columns from the screen which are not part of the actual spreadsheet. Can this be done? Ian Wolves England
  7. iansmithwolves

    inverted screen

    Hi, anyone help? I am working in Windows XP and using Office 2003 and have a problem. If I CRTL,ALT and Down Arrow my screen becomes inverted and the mouse works in the opposite direction to that which it is supposed to. Have I caught a virus or is there another expanation? Thanks Ian Smith...
  8. iansmithwolves

    email calendar

    I am using Outlook 2003 and want to sent the contents of this and next months calendar to another user, not at my site. Without using export (which I believe will export the whoe of outlook is there a way of achieving this. Ian Wolves UK
  9. iansmithwolves

    Hyperlinking whole document

    I need to be able to put a hyperlink into an excel workbook so that when it is clicked the whole page automatically becomes an attachment in outlook, or if this is not possible automatically sends the page to the recipients. I am using Office 2003. Thanks Ian Wolves England
  10. iansmithwolves

    Form to populate letter

    I need to be able to link information from one page that will automatically populate fields in a letter. ie. Page one has spaces for name, address, age etc. This information will then populated the relative fields in a pre-written letter, which can then be printed with all the blank fields...
  11. iansmithwolves

    Conditional Formating

    I need to highlight certain text in Crystal 8 by putting a coloured box around the text so that it appears as highlighted when exported to excel. We have a list of outcomes; visit vet now, visit vet tomorrow etc I want to highlight visit vet today withinn a yellow box. How please? Ian Wolves UK
  12. iansmithwolves

    Changing order in field

    I have a field with user name in (surname,first name) format. Is there a formula which will change it to (firstname, surname) format Ian Smith Wolves England
  13. iansmithwolves

    text search

    I have a field in a database which is free text. I need to search this for key words. Is there a formula that will filter all entries that contain that word, ie all entries containing the word clinical
  14. iansmithwolves

    Cross Tab

    CR 8.5 Is it possible to get the main row headings central, both vertically and horizontally in a cross tab, ie so that they appear in the centre of the first column, which is appended to several rows in subsequent columns.
  15. iansmithwolves

    zero at start of number

    Excel 2000 I need to put a phone number, 0845 into excel. How do I format the cell to show the initial zero?
  16. iansmithwolves

    Re calculating number from percentage

    Office 2k Excel I have a spreadsheet with total numbers in several rows broken down by categories by percentage. I do not know what the numbers the % represents. Is there a simple formuala that will convert all of the %'s into numbers ie Column 1 Column 2 Column 3 Column 4 25%...
  17. iansmithwolves

    Blank Page

    How do I getrid of a blank page at the begining of a report?
  18. iansmithwolves

    Not Used Filed

    I am runnig a report which show the number of times an agent had used a certain field in a database. If that item does not appear I get a blank report. What I want is a field which says "Item not used" on the blank report. Any help please would be appreciated.
  19. iansmithwolves

    Name order

    My database gives names as surname, firstname. How can I format them to come out as firstname,name?
  20. iansmithwolves

    Day function in cross tab

    I need to set up a cross tab which list dates by name only so that I can analyse by just the name of a day. If I format the date to just the name and export it to excel, the full date reappears. Can I write a formula in Xtal that just brings up the days name, which can then be analysed using the...

Part and Inventory Search

Back
Top