Search results for query: *

Both of the times are formatted in "HH:mm:ss" i need to *idealy* make it work out to the second. When i minus one from the other i can see it has worked out the correct time, (i.e. 00:16:00) however when i try to get it to evaluate the result to see if it's longer than 15 mins, it's always...

Hi Guys, i'm trying to write a piece of code which simply works out if one time is longer that another. Say for example a one variable is 15 minutes ("00:15:00"), and another is 16 mins then i would like to be able to workout that the second is longer and is 1 minute longer. I've tried : If...

Thanks Matt, I'll give that a try! David

Hi All, I was wondering if it was possible to get VB to add a computer to a domain as is you were doing it through the network properites dialog? Thanks David

Z, Your a GENIUS!!! Many Thanks mate, your post really helped ! (or was it the cystal ball???? ) :) Dave

Cool Thanks Z... i'll try that when i get in from work.. your right again, it was columns, not rows (my excuse is that it was 6am when i posted this!) I'll let you know how i get on...

HI Chaps, i'm having a bit of trouble with this function! what is needed now if for the row to be added in the following way: in month 2 B1+B3 in month 3 B1+B3+B5 etc... so it doesn't add the column next to the last one, but skips one column each time... Thanks for your help guys

Skip, Your right...! Thanks Guys! :)

Thanks all for your help! I'll give those hints a try, hopefully the index function will work! Zathras: This sheet is for a business year, so month 5 (may) is month one, and Month 1 (Jan) is month nine, i already have a vb script to sort that out, so i will just feed that variable into the...

Yes, your right, it was my typo... I need to add across rows, so should be A1+B1+C1 sorry about that. Thanks Z for making me realise!!!

Hi All, Is there a way of working out how many cells should be added in a formula based upon the month number. So for example if the month is 1 then the formula should be =A1 if month is 2 the formula should be =a1+a2 if month is 3 the formula should be =a1+a2+a3 etc etc i just can't work...

It looks like the outlook.exe /cleanreminders worked - it just took some time to work!

Hi all, I've got a couple of users here who are having troubles with Outlook 2000. When appointments are set in the calendar the reminder doesn't show. I have checked the following things: 1, user is actually setting the reminder 2, Reminders are turned on (Tools, options, advanced options...

Thanks for your reply... the user has teken his laptop home now so i can't work on it, but your tips are very handy i'm sure i'll use them very soon! Thanks Again Dave

it's got 39% free space... i ran contig again and defragmented the drive - it now reporting an average file fragmentation of 1.0005 per file. if i re-run MS defrag it still shows this fragmented area. i've run hard drive diags to confirm the HDD if fine, all ok.

I'm having a similar problems - When I Defrag a users laptop the image representation of the drive shows massive fragmentation at the end - if I drag again it just shifts the fragmentation around! I've tried the utils but with no avail, any idea's?

Hi, Is there a way to get the server to email a specified address when the machine has booted up? The server is Win2k, with Exchange 2k installed. I'm sure there's a way to do it hidden in all the options, but i can't work it out! Thanks for your help in advance Denz

We had a problem here with one of our HP 5500's where the Colour matching was incorrect. the OHT sensor clean didn't work so tried updating the Firmware and now prints perfectly. you can download the firmware from HP and simply use the DOS "Copy" command to sent the update, very...

ah cool.. that worked... i knew it was something simple. Thanks

I have a Main Form with 3 Combo Boxes and a Sub Form, when selections are made from the 3 Combos, the Sub Form updates, and fills in some Text Boxes. Once these Text boxes are filled out in the Sub Form, I want the 3 combos to fill 3 Global Variables, and one of the Text Boxes in the Sub Form to...