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...
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...
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...
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 +
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 +
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...
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 +
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...
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 +
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 +
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 +
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
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...
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 "^"...
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
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}),'','...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.