How to detect changes in a column?
If I have a table with sales forecast data (columns) like Customer,
Amount and Status, what would be the best way to track changes in this
table so I can compare my forecast week after week?
inomata's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=18938
View this thread: http://www.excelforum.com/showthread.php?threadid=493571
...MultiWorkbook Change Event Detection / Spell Checker
Excel 2003 or 2007. Looking to be able to force spell checking whenever any
cell content is is changed. I've been successful on a single workbooks by
adding Spell Check execution on Worksheet_Change.
I'm hoping to take this one step further - make it an 'Add-In' so the check
will run for any workbook. It looks like the Worksheet_Change event only
triggers for the host workbook so an 'Add-in' will not do the job.
Any suggestions to force spell checking on a change for any
workbook/worksheet I modifiy?
The way I would go about this i...Vista file dialogs
In spite of the fact that I have told Vista to never, ever hide the extensions of any
file, when using VS2005 under Vista I clicked on the "Add Existing" and was given a list
of filenames in the source directory, none of which had their extensions visible. What
did I miss, or am I just seeing some terminal brain damage by Microsoft (again!)?
I think Microsoft needs to get the message that when users start viewing systems with the
attitude "I wonder what they screwed up THIS time" they are in a death spiral.
Joseph M. Newcomer [MVP]
...A2007 problem on Vista multiuser DB
I have a A2007 application (ported from A97) running on Vista and
Office 2007 Pro. I use two computers in a LAN. The application itself
is devided into two DBs (program and data). I have installed the
program-DB on both machines and the data-DB on one (server) of them.
The same configuration worked well on the former systems (XP pro and
Now there come up the following symptoms:
Starting the application on the server workes fine. But when starting
the application on the client (when on the server its still open (and
at least one data bounded form is open) I cannot open any databo...Money 2007 Deluxe and Vista (Beta 2)
After having significant problems trying to get Money 2006 to run properly in
Vista, I decided to upgrade to 2007 yesterday. Now I can't get the install
program to run. After a successful download, the installer fires off and
imediately returns the message:
"This program has been damaged, possibly by a bad sector of the hard drive
or a virus. Please re-install it."
I'm sure that the hard drive is fine and there isn't a virus. Any
suggestions? I saw elsewhere a suggestion to try XP SP2 compatibility mode.
That doesn't seem to work either.
I...Forms, tables, etc. open in separate windows, accessible from the MS Vista taskbar
How can I set Access 2007 up in order to have the windows (forms,
tables, etc.) open in separate windows, accessible from the MS Vista
taskbar? In short, I would like to have Access 2007 behaving likewise
Access 2003, regarding opening windows.
Thanks in advance,
I don't believe this capability exists in Access 2007.
You can have the objects open in separate windows within the object
workspace by doing this:
- Click the Office button
- Click Access Options (bottom left corner)
- Click Current Database category
- Under the Application Options section for the r...Word 2000 / Vista
Whilst I realise that this has been disscused before I would like some
I wish to install a brand new / never been installed before OEM version of
Word 2000 on a Vista machine.
Will it work !?
I have seen some some old posts that say yes and some with links for
compatibility advise but these are very old posts and the links do not work
Your help is and always has been very much appreciated.
Looking forward to your answer in anticipation
It should work, but it would not be legal.
Hop...detect and repair
my outlook 2002 had some hyperlink problems which were
corrected when i used the 'detect and repair' option in
help. now i have lost my addresses and all the e-mail
that was in my inbox. How do i recover these items?
Check this page for all you need to know:
Ben M. Schorr, OneNote-MVP
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
"Mark Conner" <firstname.lastname@example.org> wrote ...Duplicate detection detecting inactive records?
Is there any way to configure duplicate detection to not look at inactive
records? I can't find any way to set this on the rules.
...Microsoft Office 2000 and Microsoft Vista
I have Office 2000 and cannot seem to install the Service packs for it. I am
running Windows Vista Ultimate service pack 2 on the machine. Are the
Microsoft Office service packs compatable with Windows Vista?
You gave yourself permission to do this?
> I have Office 2000 and cannot seem to install the Service packs for it. I am
> running Windows Vista Ultimate service pack 2 on the machine. Are the
> Microsoft Office service packs compatable with Windows Vista?
These are the errors generated ...How to Detect and prevent CD burn
How can i stop to CD burn of any file from my system to CD.How to detect the
event of CD burn and how can i stop CD burn.Basically i want to secure my
file from CD burn.
plz reply soon.
> How can i stop to CD burn of any file from my system to CD.How to detect the
> event of CD burn and how can i stop CD burn.Basically i want to secure my
> file from CD burn.
You can restrict access to a file only to a certain users through
NT/win200 access privileges. You can encrypt a file and therefore
restrict access to a file on...LoadLibrary() fails in vista but works fine on XP
I'm surprised no one really encountered the exact problem that I've
now. I've the VC++ code that works fine on XP but simply hangs up in
Vista SP1. Here is the snippet.
HINSTANCE hInst = NULL; //
hInst = LoadLibrary("ThirdParty.dll");
Install third party dll on vista machine. :o)
Then again maybe the third party dll is looking for a dll that is not
installed on the vista machine.
"KK" <email@example.com> wrote in message
> Hell...My Computer not detecting my external harddrive
I have a IDE hard drive with USB casing and connected to my USB port.
The problem is the hard drive partitions are not shown up in My computer.
But My Computer->Manage->Storage->Disk management shows the hard drive with
3 partitions and all the three are healthy.I know there are a few bad sectors.
I am sure I have not made any changes in registry that prevents drives from
Please help me.
Do the partitions have drive letters assigned?
> I have a IDE hard drive with USB casing and connected to my USB port.
> The problem is the ha...Troubles with CRM client for Vista/Office 2007 german
I've tried to install the german CRM client on my Vista and Office 2007 Laptop. The install ends with the same error message like yours.
You had posted this at the end of December�, since 01/05/07 is there a new english download available. Is this a new version, are there any errors again?
Thanks for your support!
EggHeadCafe.com - .NET Developer Portal of Choice
Hi, i'm having the same problem with the latest client (dl'd it today) Any workarounds ?
EggHeadCafe.com - .NET Developer Portal of Choice
...GUID is not detected by server .& cannot go offline...SFO.
why is the server not detecting the GUID attached to the subject line of
email...what could be the problem...
Also i am not able to go offline ..I get an error Domain canot be contacted
or does not exist...
Thanks a million.
...open a new instance of excel for each file ? (Vista / Seven)
How under Vista & Win7 can we open a new instance of excel for each file ?
thx a lot people.
...Mic not detected
I upgraded from Vista to W7 when it first came out. I have just recently
realized that it apparently cut off the mic and I cannot record anything. I
can still hear cd's.etc. I did not discover this until I tried to send a
video message to my son who just got deployed to Iraq. Dell customer support
has been useless thus far. Thanks for any suggestions as to how to fix this
On May 17, 11:51=A0am, "andy jones" <jandy78...@aol.com> wrote:
> I upgraded from Vista to W7 when it first came out. I have just recently
> realized that it apparently cut...Record is locked (deadlock was detected)
when trying to run a CM Transaction I get "A get/change next operation on
table 'CM_Transaction' deadlock was detected. when I click on more details i
am given the following. [microsoft][ODBC SQL Server Driver][SQL Server]
Transaction (process ID 77) was deadlocked on thread | communication buffer
resources with another process and has been chosen as the deadlock victim.
Return the transaction.
currently I have ensured that no one is logged in. I view the odb.dex_lock
table in the tempDB and cleared it. At this point I can run a reconciliation
with no errors where I ...WMP 11.0.6002.18111 runing OS Vista 32
I have alwayed used WMP to play my MPEG2 files which have on my computer
awaiting DVD production. I tried to load Roxie Easy Media Creator Suite 9
onto my computer to give my another avenue of DVD creation. After reboot I
was informed by the computer that it had blocked a driver trying to load from
Sonic MY DVD which was interfering with WMP. Realizing there was going to be
a compatability error I removed Roxie Suite and then went to play my MPEG
files to be certain no harm was done. WMP now refuses to play the MPEG files
and gives an error code "C00D11B1". How can...Microsoft CRM does not work with Vista and Office 2007 Offline
We are using a trial version on Microsoft CRM. Our operating system is
Vista-32 and we are using Office 2007. Our laptops get synchronization error
messages whenever we try to use the laptops offline. Our Microsoft reseller
has opened a case with Microsoft but we need this to function offline now.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microso...Money Plus with Vista
I am a Quicken 2007 user. I have a new computer with Vista. Quicken and
Vista do not play well together, therefore, I am inquiring about Vista and
Money Plus. Any compatibility issues? Also, I notice (on the Money website)
that the Quicken converter only works through Quicken 2006. Any one have any
further info on that. Thank you.
In microsoft.public.money, SE Louisiana wrote:
>I am a Quicken 2007 user. I have a new computer with Vista. Quicken and
>Vista do not play well together, therefore, I am inquiring about Vista and
>Money Plus. Any compatibility issu...Cannot detect previous login you need to run frontstep crm at least once
We have a user who was on extended leave for a few months
and now when ever he opens up outlook 2000 sr-1 on his
computer (Windows 98se) he gets a message that "Cannot
detect previous login you need to run frontstep crm at
least once. Front step outlook extension will be
disabled for current outlook session." When I say OK you
get another message that "The add-in "psExcExt.dll" could
not be installed or loaded. This problem may be resolved
by useing detect and repair in the help menu. Unable to
load "psExcExt.dll" you may be out of memory or out ...Where does Vista hide my docs/settings when taking drive out of computer??
Hi guys, I think Vista does some weird complicated thing with user
data - today a tech installed Win 7 on a new hard drive and gave me
old hard drive to transfer stuff across. I've got it plugged in to my
USB port. I can find all my old program files, etc, but all of my
and settings are gone.
There is no directory called Users/Jo (which was the address on my
Last time I had to reinstall Windows the tech had to install the old
drive on a particular machine to get my data off - we thought that
because Vista SP1 crashed and destroyed the mach...detecting which control has focus
I have an application that I am writing and I need to be able to detect
which control has focus (I am using edit controls). I figured out how to
set the focus by creating a member control variable and using the setfocus()
function, but how do detect which control has focus? There is a getfocus()
in the control member variable, but I have been unsuccessful in using it? I
am using the PreTranslateMessage(MSG* pMsg) function to detect when the
Return key is pressed and then I automatically go the the next edit control,
but I want to do different code depending on which Edit control has focus
a...Search facility in Vista
Why is it that if I put a 2 or 3 string phrase in the Visdta search facility
I get hundereds and hundreds of search results, most of which couldn't
possibly have the words in them? (i.e. I don't find it much help)
It was OK in WindowsXP, it got f-d up in Vista, sorry.
Best solution is:
Their AgentRansack is free, and FileLocatorPro is $40 or something.
FileLocatorPro will find strings within ANY file and is used by FBI, CIA,
UPS, large transportation/shipping hubs, large data mining companies, etc.
Again, WindowsXP had enough of own ability to s...