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 strongm 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: 47redlands
  • Content: Threads
  • Order by date
  1. 47redlands

    Novice to SQL ,, need helpt to exclude some rows

    Novice to SQL need to help with coding I have a population table and I want search the countries that are big by area or big by population. select name, population, area from world where population >250000000 or area > 3000000 The above SQL code does this, however I only wish to Show the...
  2. 47redlands

    how to match random letters to numbers

    I have a column lets call it A, in column A there is 9 random letters A to I e.g. I E D H F A c B G in column B I wish to have numbers that match the random letters from column A, e.g. A = 1, B = 2, How can I do this?
  3. 47redlands

    PowerPoint problems, long words are broken up in text box

    I am editing a MS PowerPoint emailed to me from a Chinese friend. When I type text in the text box it does not start a long word on new line and this causes problems. If I were to use a new PowerPoint (MS PowerPoint 2010, so not the one given to me by Chinese friend) for example if I write "My...
  4. 47redlands

    spreadsheet say N/A error when I click on the data validation

    Why does my spreadsheet say N/A error when I click on the data validation for medical cost: Medical cost Medical cost 1 Medivet Medical 2 Confused.com Medical 3 Angel Dog Medics On the animals spreadsheet the data validation wroks for Medical cost 1 Medivet but when i change the data validation...
  5. 47redlands

    Formula is not behaving as i wish it to do

    I am carrying out a Microsoft Excel exercise. It is for National Insurance. The current national insurance rate ranges in the following manner; If you earn more than £110 a week and up to £844 a week, you pay 11 per cent of the amount you earn between £110 and £844. If you earn more than £844 a...
  6. 47redlands

    Mircosoft Excel, printing solution

    I have drawn the layout of my room in Excel, so excel cells are different furniture in my room. I use a projector to display the room, on the projector the layout is fine, however when I print it out, the left and right are on the opposite side. Imagine when you ask the question "is it to my...
  7. 47redlands

    photoshop picture has turned black and white

    I am using Photoshop Cs5. I am creating a poster and my poster has turned black and white. When i look in the channels my red, greem and blue channels have gone!. How can I get it back? Thank you in advance.
  8. 47redlands

    change name on comments, not working as it is supposed to.

    I am using Microsoft Excel 2010. When I enter comments it has my name on the comment 47redlands, when I click off, or go to safe the spread sheet, or go back to excel after saving, the comments on 47redlands changes to Author. How do I keep it so the name on the comments stays 47redlands? I have...
  9. 47redlands

    learning to program java with games

    I wish to teach Java programming to my young nephew. He wishes to go straight into game developing. Is there any open source/shareware java games with graphics front end? I want the game to have graphical front end from the start so all I teach my nephew is game logic via “if statement”...
  10. 47redlands

    windows 8 CitrixOnlinePluginWeb is not working

    I work remotely from home sometimes and I use Citrix client. I have just purchased a new laptop and it has windows 8 installed. I have tried to install CitrixOnlinePluginWeb and CitrixOnlinePluginFULL both fail and I do not know what to do: Citrix online plugin application There is a...
  11. 47redlands

    MS Access query returns 60 records I wish to change so it returns only 15 results at a time.

    I am using MS Access. I have created a MS Access query. The query returned about 60 records I want to only examine about 15 results at a time. How can I change my query to do? Thank you in advance
  12. 47redlands

    text attach to path all sorts of problem

    i am using fireworks cs5. previously I have used fireworks 8. These are the problems I am encountering. I am creating a logo. I am using the eclipse tool to draw a perfect circle. I am using text tool to write logo name. I then attach the text to the eclipse tool. Now problems occur. For...
  13. 47redlands

    Fireworks 8

    Fireworks 8. Appologies as I could not find a fireworks 8 forum on this site. On fireworks 8, How do I get text to stay on one line? Sometimes no matter what I do the text does not stay on one line but there is a carriage return. Thank you
  14. 47redlands

    printing speaker notes to pdf

    I have created Microsoft powerpoint using 2010. I have speaker notes. I want to print the speaker notes to pdf. So thus I go to view tab --> then choose Notes pages then file --> print --> [choose pdf] however it does not print the speaker notes. Why????? How can I print speaker notes to pdf...
  15. 47redlands

    changing a field from one table to another

    Apologies, I put this original message in the wrong subject area. I am using MS Access 2010 and have normalised the table via Database tools --> analyze table and split a large table into smaller tables. The problem is I accidently put the title field into product table. I have taken off the...
  16. 47redlands

    novice to pivot tables

    MS Access pivot tables. I am new to MS Access pivot tables. How do I create bar charts in MS Access to show data of how many sales? Thank you in advance
  17. 47redlands

    MS Access input mask

    Hi I have created a database and it will hold clients name and address including postcode. I wish to put an Input Mask for the postcode. By default the postcode for MS Access is >LL0 0LL MS Access writes "every postcode follows the above format". For example Cambridgeshire CB4 2XC, Hampshire...
  18. 47redlands

    change owner to author in comments

    Hello I am using excel 2010.when I write a comment it starts with the owner. I want to change this. When I write a comment on an excel cell I want it to start with the authors name or start with a blank comment. How can I make this happen? My project involves working with excel and writing many...
  19. 47redlands

    Please help lost cool animation

    I created a really good flash presentation on Flash CS4. I optimised the animation by going to File/publish setting/ then flash tab I reduced the flash player to 8 and I think to Action Script 2. I opened the flash today and found lot of my flash animation has been lost. Please help how do I...
  20. 47redlands

    home network cannot access wifi router from garden

    I have wifi router network at my house. I have a long garden and at the end of the garden their is a summer house which I often use. I have an Toshiba and HP laptop both laptops have excellent signal at home. However when I am in the garden my Toshiba laptops does not always give the best...

Part and Inventory Search

Back
Top