Search results for query: *

I thought about the dates maybe being in the wrong format so I formatted the cells as dates - still no luck. As for why it has to be done in the PT, well it doesn't really. I am building this pivot for a bunch of non-techy users who simply want to be able to hit a button to refresh the data...

I have tried simple arithmetic date subtraction, days360 function and the datedif function. I think it must be that I need to convert date formats to a number first? What confuses me is that any of these methods work fine on the source data.

I have a pivot table with 2 date fields in it (as rows). I want to add a calculated field that simply tells me the difference (in days) between those 2 dates. No matter what formula I use to calculate the date difference, the field always returns zero for all rows. I must be misunderstanding...

I realise now this is what I should have been doing all along! I wasn't aware of the function of the mirror task. Thanks for your time. Will.

I have recently upgraded my clients from McAfee 4.5 to 7. The only way I could find to get AutoUpdate to run correctly on each client was to download the whole of 'ftp.nai.com/commonupdater' to a central server and point the clients to it on their repository list. This worked fine (although it's...

I've tried everything I can think of to remove the protection on the tables, with no success. I even moved the whole application onto a purpose built Windows 3.11 machine with a FAT filesystem and the tables were still read only. I think the only option is to re-write the app in access and...

Thanks Mac, The entire data folder has a read only attribute. When I remove the attribute, it reappears immediately. I have checked the inherited permissions (NTFS) and have given 'everyone' 'full control' of the folder and subfolders. Even then when I remove the read only attribute it...

I have a very old database application, originally installed on a windows 3.11 machine, using the Paradox 7 runtime files. The app was initially installed in around 1995 , long before I was involved. I have no installation disks for the application and the company who wrote it no longer exist...

I have heard of such main-memory databases but not used them. My guess is that there is nothing to stop you creating a ramdrive and moving databases into it but you must remember that most databases are designed to journalise transactions and write them back to the disk. This is often a low...

Unfortunately I don't have norton SU but problem solved with bcastners advice. I didn't even know that menu item was there! Nice one. Thanks guys.

Why not just search ALL hard drives/zip drives for *.dbx files ? If you don't find any then you have lost your mail - sorry. If you do find any (doesn't matter where they are) then create a folder called c:\mail (or something similar) and copy all the .dbx files into it. Open OE6 and click...

What I need to do is get a list of print drivers that my machine is using. By this I mean that I need exact details of the driver version and manufacturer. I know I can get this by printing a test page to each printer but is there a quicker way ? By the way all my printers are connected by...

When did it start ? Did you install some software that caused this ? I have a vague memory of seeing this before and I'm fairly sure that a re-install of the SP did the trick. Sorry I can't be more specific. Will.

To change netbios settings in Windows 2000: Right click 'My Network Places'choose properties. Right click 'Local area connection' choose properties. Highlight TCP/IP and choose properties. Click advanced button. Select WINS tab. At bottom of page there are settings for NetBios. Cheers, Will.

Broadband connection is irrelevant. You need some form of lan name resolution. You say when you ping you get a reply so there is no physical or logical reason why you can't connect to the other PC. It's just that when you type '\\sue\desktop' your PC doesn't know how to translate 'sue' into an...

1. Direct parallel - your machine is capable of communicating with another PC by using it's parallel port. You can connect a special parallel cable between 2 PC's. 2 - 5. These are virtual ports that your PC sets up to handle communication over a WAN (Wide Area Network). For example if you...

You are really looking for an intrusion detection system I think. 'Unknown' IP's will probably touch your network all the time if you have any PC's with internet access. I have used several programs in the past to monitor network activity. Ethereal (for windows or Linux) is a good free network...

A couple of things occur to me. First, check what Xemus says about what is set to run at startup. Second, how do you know the CPU is using 100% constant before you open task manager? You only get a CPU level indicator after you open task manager. Third, my guess is that something is set to run...

The workstation uses DHCP but this should not require authentication. I'm going to put a sniffer on his machine overnight to see where it goes on it's midnight wanderings. I just know this is going to turn out to be something really boring when I find it (although I don't know why that should...

Chip H, Not currently using Netmeeting but have done in the past. Why do you ask ? Will.