Graphs in Other Files do not Update
I have a main file with graph (AP.xls) and several sub files with graphs
that are linked to the main AP.xls file.
The columns of the main file are in months and I often have to add new
columns for a new month. I find that if I add new columns using copy =>
Insert copied cells (the column is inserted to the left of the column being
copied), the graph within the AP.xls files is updated with the new
column/month. HOWEVER, when i open the other sub files, they aren't updated.
HOWEVER, if the sub files are opened together with the main AP.xls file, and
I insert the new column, t...UPDATE and SET w/ CAST (String Replace)
I have a text field column in SQL 2005 that contains HTML code. I
would like to update certain references in this HTML code throughout,
but am having problems. I know that I can't do a string replace with
the text data type, which is why I would like to cast it as
nvarchar(max). Any help would be appreciated. Thanks.
SET (Cast(HTMLData as nvarchar(max)) =
WHERE HTMLData like '%detail.cfm%'
"Daniel Reardon" <email@example.com> wrote in message
news:firstname.lastname@example.org...update a date cell only when worksheet is edited
Hi. is there a function that updates the date cell automatically only when
the worksheet is edited or something to that effect. thank you
This might help
Joe Black wrote:
> Hi. is there a function that updates the date cell automatically only when
> the worksheet is edited or something to that effect. thank you
...disable snap-to while dragging tab stops?
How do I drag a tab stop to arbitrary position without it snapping to the
tick marks on the ruler?
I tried holding down shift, ctrl, alt. None of them works. I even turned off
everything in the arrange->snap menu.
Set the tab to about where you want it, zoom to 200%, open the tab dialog and input
the number where you want the tab positioned, click set. The tab button can be
dragged to your toolbar by customizing. This is the best that Publisher can do...
Mary Sauer MSFT MVP
"p...Hyperlinks in outlook messages open with media player
Whenever i try to click a hyperlink from an email in outlook it tries to
upen it with media player.
Any help on how i can resolve this would be helpful.
A few days ago while trying to balance one of my accounts, Money would start
hanging and I had to kill the process and created a LRD file. My file is
only 12MB and it has been fine until recently. I am using Money 2007.
I should have put my system specs. I have a P4 3.8GHZ w/ 2GB RAM running XP
Pro. When I have Money open, I typically only have Messenger, a browser, and
sometimes Acroabat Reader running also.
> A few days ago while trying to balance one of my accounts, Money would start
> hanging and I had to kill the process and created a LRD file. ...blue stop screen 0x0000007E
stop error code after windows installs drivers. this is new hdd and mobo but
problem persists.oxoooooo7e (oxf748eobf oxf78da2o8,oxf78d9fo8....was doing it
with last mobo and hdd...help please!!!
thanks one and all for your helping hands
> stop error code after windows installs drivers. this is new hdd and
> mobo but problem persists.oxoooooo7e (oxf748eobf
> oxf78da2o8,oxf78d9fo8....was doing it with last mobo and hdd...help
That *is* a driver issue. You are installing the incorrect drivers or need
to contact the manufacturer of said ...Update attribute using ldp
I have written an ldf script which creates few custom attributes and an
auxilliary class which contains these custom attributes.
Also this auxilliary class is part of Users and OrganizationalUnit
Now I want to update the values to the custom attributes.
How do I do it using ldp?
I can set values for the inbuilt attrbutes without any issues, however
when I try to set the values for the custom attributes I get below
Error 0x20B5 The name reference is invalid.
----------------------------...recipient policy stopped working
I'm seeing an issue in my Exchange 2003 environment where an admin will
create a new account and the recipient policy does not populate the users
email address. This just started happening a few days ago here in the US...
It happened in our UK office last week but I thought that might have been
user error on the admin. We are in mixed mode with Exchange5.5, which we have
been for almost a year. I did how ever remove some old 5.5 servers but the
last one I removed was almost a month ago, so i don't think it would be that.
I know you need to ask this question so yes th...WMP12 Always "Updateing Media Library".
Does anyone know if or when MS is going to fix this issue?
Does anyone know of a current fix (other than going to WMP11) ?
On Mon, 30 Nov 2009 08:34:02 -0800, RReid
>Does anyone know if or when MS is going to fix this issue?
>Does anyone know of a current fix (other than going to WMP11) ?
Sorry which issue do you mean ? It's impossible to tell from your
description whay you're on about...
Cheers - Neil
Digital Media MVP : 2004-2009
http://mvp.support.micro...Online updates only working with credit accounts?
I have been struggling to get my account set up with automatic updates in
money 2006. I have set it up successfully for 2 credit card accounts. But,
when I set up brokerage accounts, they appear to connect to my accounts but
then say $0 (this occurred with 3 accounts: Etrade, Fidelity, anad Vanguard).
I searched the help/ user guides but found nothing about this problem.
My bank (Citizen's Bank) apparently does not allow for automatic updates. I
checked to see if Citizen's bank was on the financial institution list before
I downloaded the software, and it was, so I feel like...How do I stop a cc email to myself from going to deleted folder
Sometimes when I send an email, I want to keep a copy ofr myself. When I
enter my email address in the cc part, this always goes straight to the
deleted folder, even though I have my email listed as a safe sender. Any
On 13/03/2010 01:53, technochallenged wrote:
> Sometimes when I send an email, I want to keep a copy ofr myself.
Outlook automatically keeps a copy of every email you send in the Sent
There is no need to cc yourself.
"technochallenged" <email@example.com> wrote in
message news:D4...3197: The microsoft Jet Database Engine stopped the process because you and another user are attempting to change the same data at the same time
I have a fairly large (For Access - its slated to be transferred to
MySQL) backend that allows the user to use the database's front end
normally to store and retrieve data. However when I try to open the
database I get the Error "The microsoft Jet Database Engine stopped
the process because you and another user are attempting to change the
same data at the same time".
This isn't true because I have it on my local computer.
I've tried importing to a new DB file and I get the same error. The
original DB will not open to allow import (show table list) and show
er...I would Like to Receive the Windows Update Services for my Account
Thanks for your service... I would like to receive the Windows Updates for
unt at any time; please, take note about it.
> Thanks for your service... I would like to receive the Windows
> Updates for this acco
> unt at any time; please, take note about it.
I have taken note. Many others that are your peers likely will as well.
However - I would bet the question would be, "Why should we care?"
This is a peer-to-peer newsgroup - a foru...calender updates
Any suggestions as to how I can update the calender in outlook 2002 xp to
show bank holidays for years 2007/8/9pls ???
Dale <firstname.lastname@example.org> wrote:
> Any suggestions as to how I can update the calender in outlook 2002
> xp to show bank holidays for years 2007/8/9pls ???
See if this helps: http://www.outlook-tips.net/howto/missinghol.htm
...Stopping the scroll bar
Hi all, this is my first time. I don't know if this is the right place
for this problem but here I go. I have created a template of an
invoice the size of an A4 and would like to stop the scroll bar moving
both horizantally and vertically in normal view just as if it was in
print view. Is that possible through VBA and if yes what is the code
that I would need to achieve such task.
Thanks in advance
Message posted from http://www.ExcelForum.com/
Not too sure what you are after but you can remove the scrollbars with
<Tools - Options> and then in the View tab, at the bottom,...BEFORE UPDATE EVENT
I am very fascinated with the control one can have over what goes in by the
use of the BEFORE UPDATE EVENT of a control on a form or the form itself.
Unfortunately, I do not have the proper knowledge of how to use the procedure
so that I do not get error messages when I am entering data. Can anyone
recommend a good article I can read to get my feet wet?
On Oct 30, 11:34 am, Glint <Gl...@discussions.microsoft.com> wrote:
> I am very fascinated with the control one can have over what goes in by the
> use of the BEFORE UPDATE EVENT of a control on a form or...update query for continous form
with the following code i am trying to uncheck a box on my continous form as
it's closing and this does not work. my recordsource is ProdHistory and in
that table the record that i need to disselect everytime the form closes is
Select. can anyone help?
Private Sub Form_Close()
If Me.Dirty Then Me.Dirty = False 'Save first.
strSQL = "UPDATE ProdHistory SET Select = false " & _
"WHERE Select = true;"
>with the follo...Stop all macros
I have a button on a form, which should do different things depending on
1. The data contained within the current record;
2. Whether the current record is a 'new record';
3. Whether the current record is the first record in the form.
On click, an embedded macro is initiated. Each step in the embedded macro
has a condition and a corresponding 'RunMacro' action.
All the conditions are mutually exclusive, and each sub-macro has a final
step of 'StopAllMacros'. So the embedded macro should trigger one, and only
However, it appears that what is act...Update dynamicly a query field formula
Hi All,Is it possible to update a query formula by vba code?for now i found a solution by just building a dynamic query,but iprefer to have an option to update just one field with new formulafrom time to time,is it posible?...Stopping a Campaign Temporarily
My client has executed the campaign in Jan 1st 2006 and the end date is Dec
31st 2006. But he wants to stop the campaign temporarily from 15th July 2006
and again start it from 1st Aug 2006.
So what is that I need to do for this thing, i have never come across this
kind of situation before.
Thanks in advance.
...Unable to update free/busy data
A user received the following error message when using the
"unable to update free/busy data. Operation failed."
According to microsoft knowledge base there is a fix they
have been testing.
Does anyone know if this fix costs anything or if there is
another workaround this error message."
...Unable to Update Public Free/Busy Data...
my users all of a sudden started getting the following pop ups on their
outlook 2000 client, running on exchange 2003.
"unable to update public free/busy data. the contents of this public folder
are currently unavalable. either
the microsoft exchange server computer servicing this public folder is down
or the public folder has not been
replicated to this site. see your administrator."
i have to local exchange servers and two remote exchange servers, all set to
kb articles from microsoft only refer to issues on exchange 5.5
any help would be appreciated
El....Removable media drive
Running W7 on x64 HP Pavilion PC. Just installed an HP 1TB media drive in
the media slot. Every time the PC awakes from 'sleep', it re-finds the
media(J:) and tries to load the pictures stored there. Also use this for
backup so more than pic there. I turned off the autoplay so now it asks me
what to do for "Autoplay dialog".
What do I need to do to ignore that drive(J:) since it is never actually
On 5/12/2010 4:02 PM, DanR wrote:
> Running W7 on x64 HP Pavilion PC. Just installed an HP 1TB media drive
> in the media slot. E...does a querry update a table
I have just created another querry in my database, which has currency
values of parts which have been shipped. Previously I didn't have this
querry, but now I do, and I have noticed that the value which is in the
said querry feild does not update the main table I have.
In reality I suppose it can't at the moment, so how do I get this to happen.
To build the querry I added feilds from the main table and feilds from a
newly created table by using INNER JOIN to get the a calculation of data.
It is this calculated dated I want to go in a feild in the main form.