Recent content by substitute

Thanks for the response Linney. I had tried most of that including the OSK. I've actually just fixed it. A bit of a "doh!" moment really. I booted safe mode and established that the keyboard events were OK there. From there I used selective boot to narrow down the options and eventually found...

Hi all. An "interesting" problem! We all know that if you press a key and hold it down it "autorepeats", hold down "w" and you get "wwwwwww". Now, if you look under the hood you'll see that the application gets a series of events. A single press gives "keydown keypress keyup" and if held down...

You've said what you need to do - create a macro. There are two options: 1. Create a separate query for each table operation and then create a macro in the database window that just consists of a load of "OpenQuery" lines. You can use a condition including the DCount() function to check you...

Obvious answer, have you hidden the query but in your 2003 system you've told Access to show hidden objects?

Both Roadkill and Derpate make useful suggestions - thanks Derpate for pointing out I don't actually need a drive letter and thanks Roadkill for suggesting disconnecting the actual folder as well as the drive letter - I'm trying that one tonight to see if anything happens. What I've actually...

I have a batch file which copies a set of files from a Windows 2000 server to another server. The file runs nightly as a scheduled task. The basic procedure looks like: net use l: /delete net use l: \\server\share\folder password /user:domain\user /persistent:no xcopy e:\files l:\ /c/y I've...

You could use formula auditing. Show the formula auditing toolbar (right click a blank area of toolbar and select it) then select the cell and click the "trace dependents" button. Excel draws arrows to all the cells whose formulas depend on that cell (or shows an "off worksheet" symbol if the...

Thanks Techy, I'm getting the general idea and hopefully the new parent's IT guys can do what is required. The original "two domains on same network" strategy was tried because had it worked there would have been no disruption, and it almost does work, except for the random authentication...

The message seems to be that there could be problems with the current setup. I don't know about this stuff, I've only ever worked with a single domain system. However, if I point the right people in the right direction I'm sure they can solve it. The reason the server was left on its old...

Sorry for a long question. I hope it is interesting enough to merit reading! Thanks to a takeover of our business and integration of IT systems we now have two AD domains on the same subnet. The old domain ("olddomain") had two servers, both domain controllers (primary and backup) and 45...

I did wonder about things like mailbox size, but the fact all users hit the same problem together, even though some have huge mailboxes and other tiny ones suggests otherwise. As for OWA, I have several users on Blackberry and as long as the service provider sets them up for internet mail...

I've still not found a resolution to this problem so am in the process of purchasing Blackberry phones (which work fine with OWA/Activesync) instead. Shame Microsoft can't make Windows Mobile work as well with Exchange as RIM can make Blackberry work! Ian

Blackberry can sync email with Exchange server using Outlook Web Access (OWA), if you get it correctly configured initially. There seems to be a configuration difference between an Enterprise Server Blackberry and a non-Enterprise Server (or Internet email) device that can only be done by the...

As dhookum says, the problem is rounding. The results you show are actually correct, but rounding makes them look wrong. The problem is inevitable. Take a case where you have three inks in proportion 1:1:1. The real proportions are 33.333333333333... percent but rounding to two decimal places...

Xlbo That is just about the most amazing thing I've seen in Excel since someone showed me SUMIF (15 years ago). I never thought of putting a formula in a range name definition. And a great formula too. Using CountA to measure the extent of an area - didn't think of that either... The world has...