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 Mike Lewis 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. AdamRicko

    Replace formulae works but need to dump the data rather than linking from the origional column

    Forgot to add the attachment! IT Support Comptia A+ Comptia Network +http://www.mediafire.com/view/?sswp3eeeoypaq29#
  2. AdamRicko

    Replace formulae works but need to dump the data rather than linking from the origional column

    Hi All, I'm trying to trim/replace a column down to 40 characters. I can use =REPLACE(B1,41,50,"") Which gives me exactly what i want, but it is reliant on the origional data still being available. I need some kind of way to trim/replace down to a maximum of 40 characters either with the...
  3. AdamRicko

    How do you learn new stuff?

    I find the best way to learn new skills is from other people that are competent in said areas. For example i work in a small IT department (3 Full time staff, 3 sites) and we outsource a lot including network support. We have network guys in quite regularly but sometimes they need help when...
  4. AdamRicko

    Windows Photo Gallery - Damaged or Corrupted

    Hi Folks, I have some users on Vista that are getting an error in Windows Photo Gallery when opening pictures. "Photo Gallery can't open this picture or video. The file appears to be damaged or corrupted" These pictures are deffinately not corrupt. They get the same error if opening from a...
  5. AdamRicko

    For our Newer Members

    Adam - Because it is my real name. Ricko - Because it is my real nickname. I work as a IT Support Technician and work at a large regional brewery in the northwest (UK). Currently living in Manchester, aged 23. :) IT Support Comptia A+ Comptia Network +
  6. AdamRicko

    Word 2007 Template Compatability Issue with Word 2003

    Hi Macropod, Thankyou for your advice. The problem I was having was resolved by using the 'Legacy Formfields'. Feel a bit stupid for not noticing that in the first place. But thank you for your help all the same. :) AR IT Support Comptia A+ Comptia Network +
  7. AdamRicko

    Word 2007 Template Compatability Issue with Word 2003

    Hi Everybody, I am currently creating a simple word 2007 template with form fields and protection on the rest of the document. I have created this but it will not work in office 2003. I have tried saving in compatability mode (As a 2003 document) without any luck. I have been doing some...
  8. AdamRicko

    'Take a nap' or 'Have a nap'?

    Im going to have a shower" sounds much better than "Im going to take a shower" . What you going to do, run off with the shower head? IT Support Comptia A+ Comptia Network +
  9. AdamRicko

    HDD wont boot, but otherwise seems to work

    With the error message "Unable to locate boot disk, please insert boot disk and press ENTER" it sounds like a problem with the MBR on the hard drive or the ide controller as you stated yourself. Have you tried resseting the Bios to default just incase something you have missed? Tried to run...
  10. AdamRicko

    What AV did you change to is you were using Symantec AV?

    We use Sophos and can honestly say we have not had any infected machines in over 2 years. Also use there web filtering and is very efficient. IT Support Comptia A+ Comptia Network +
  11. AdamRicko

    computer screen jumping up and down-Total Novice

    I used to have a problem with my old CRT where a speaker sub was next to the CRT and it changed the colour(green ish) the closer the sub got. (sub had a built in supply) IT Support Comptia A+ Comptia Network +
  12. AdamRicko

    Matsonic ms8147c Drivers

    Don't meen to be rude in any way, but why would your religion forbid you from that? Offtopic i know, just curious. IT Support Comptia A+ Comptia Network +
  13. AdamRicko

    Personal Antivirus (Spyware)

    I can confirm a quick download of superantispyware and jobs a good one. i ran it twice with a reboot inbetween as it still picked up bits on the second scan. CR2008 - SQL server 2005 New CR User
  14. AdamRicko

    Conditional Report Header

    Hi All, I am trying to conditionally show a title (Taste Guide) conditionally if the taste guide field is not null on that particular page. i have tried adapting a variable count i got in a previous post. Here is what im doing currently. Page Header - @Taste guide text whileprintingrecords...
  15. AdamRicko

    Reset running total on a new page

    Hi, That works a treat for a running total page reset, but is not exactly what im looking for. Im trying to conditionaly show "^ Whilst stocks last" in my page footer if "^" is shown on current page. "^" is in its own field. See below for what im currently doing. Formulae to show "^"...
  16. AdamRicko

    Reset running total on a new page

    Hi All, As the title sais, is their a formulae so a running total will reset on every page? I have tried a few different things but have been unable to get this to work. Any help regarding this matter would be greatly appreciated. Many Thanks, AR CR2008 - SQL server 2005 New CR User
  17. AdamRicko

    trimming an item description

    Yep thats working a treat to get rid of my alcohol volumes. allthough i cant get it to work in conjunction with my other formulae. trimleft(mid({FRL_LIVE_Item.Description}, instr({FRL_LIVE_Item.Description}," ")+1)) and if instr(extractstring(strreverse({FRL_LIVE_Item.Description}),'','...
  18. AdamRicko

    trimming an item description

    BEFORE 500ml DOUBLE HOP (Re Marstons) (UK) NRB 5.0 275ml MACKESON NRB 3.0 30Ltr VELTINS 4.8 275ml HOLSTEN NRB 5.0 330ml CORONA EXTRA NRB 4.6 FLEURIE PIERRE PONNELLE 2007 BOURGOGNE ALIGOTE RENARD 2006 GIGONDAS CHAPOUTIER 2006 OLD COACH ROAD SAUVIGNON BLANC 2008 BUSHMILLS SINGLE MALT 10 YO...
  19. AdamRicko

    trimming an item description

    I have some item descriptions that have an Alcoholic volume at the end of the description. I need to supress the volume as this is being shown elsewhere on my report. But note, not all descriptions have the volume at the end so simply cutting the last 3 digits wont work. e.g. CARLING 4.0 But...
  20. AdamRicko

    Altering description of products

    Cheers folks, tried all 3 and they all work :) Greatly Appreciated, AdamRicko

Part and Inventory Search

Back
Top