Search results for query: *

Last night my PC locked up and when I finally got it to reboot I got a Dialog box on my screen with the following message : "To test your e-mail connection, please enter your e-mail password". There was a box for me to enter the password and two buttons "OK" and "Cancel". The title bar of the...

I have some VBA which successfully creates a pivot table but three of the fields use custom lists for a sort order. How do I get my pivot table to sort the agerange, servrange and salrange fields according to my custom lists as defined in Tools > Options > Custom Lists? Any help would be...

That sounds like a much better method, any tips on how to go about it? What I want to end up with is the contents of the string that is found in a string variable and all the above rows deleted. Thanks

I have an excel spreadsheet containing a list of text strings in column A. What I want to do is write a loop to delete all rows until I find one that matches a specific pattern. The pattern is only part of the text string, not the whole line. I have this so far...

Thanks, I'll pass that information on and tell him to give it a try.

Can anyone tell me what this executable is please? My friends virus checker picked up a virus last week which it seems to have successfully removed (unfortunately he didn't make a note of the virus name) but since then on boot up he gets a message saying the hlcwshz.exe is not found on the C...

Couldn't find any WINSERVS files at all, but downloaded Spybot and it picked a couple of things up. Hopefully that's the last I'll see of that pesky window. cheers!

Often when my PC boots up, it halts with a blank Windows interface (ie no icons or task bar) but a blank window headed Purity Scan. When I check the Task Manager this program is reported as 'Not Responding'. If I kill it, the pc continues to load as normal. This doesn't occur every time. What...

Hi, there may be an obvious answer to this question, but is there an Excel equivalent of the Word Normal.dot template where I can save my increasing library of VBA UDFs so they are available to every new worksheet I open? Currently I have a template called UDFLibrary.xlt which contains them...

Brilliant, that's done it, thanks a lot Paul :-)

Thanks, this was helpful, but I find that Expr3 is sometimes a minute short - possibly to do with rounding errors of the INT function? I'm getting closer to a working solution though.

A correction to my original post - the fields are in Short Time format, not Short Date as I originally stated. I don't know if that makes any difference...

I have a table of flexitime data which contains four fields AM Time In, AM Time Out, PM Time In and PM Time Out. All the fields are of type Date/Time and are formatted as Short Date so they appear as 08:45, 13:56, etc What I need to do with a query is find out the number of hours and minutes...

Thanks everyone who responded, we have resolved the problem. No errors were found with the memory, but running the scanreg /fix worked. The system now scans the registry at boot without error.

Thanks for all these ideas. We'll try them all and let you know if we have any success!

Has anyone seen this problem before, and have any idea how to fix it? Two of my friends running Windows 98 SE are experiencing this problem - we suspect a possible virus. On start up I get a blue screen with messages on the bottom saying "Backing up registry" and "Restoring...

I had Norton Antivirus 2003 Professional installed on my Windows 98 system. I upgraded to XP Professional yesterday and found my NAV would no longer work. I found the error on the Symantec Knowledge Base - solution was to uninstall and reinstall the software. I uninstalled successfully but...