IIF statement to hide a graphic
How can I use IIF statement to display or hide a graphic?
If by Graphic you mean a chart. Try this it will hide charts on a
page if a condition is not true.
If Range("B1").Value = 1 Then
ActiveSheet.ChartObjects.Visible = True
ActiveSheet.ChartObjects.Visible = False
...Resource Update does not update location field
We have one person create a meeting request for a resource and some other
users. Then if someone else goes and modifies the meeting request resource
for the location, the location field does not update. But if the original
creator does the same process, it works fine and does update the location
...Update Links-Excel 2003
I am new to Excel 2003.
I have a file B which is linked to file A.When i open file B i get a
message asking whether to update/Do not update links.Whatever option i choose
i get a Value error in all the linked cells of file B.
This is happening only in the case of this particular file.In other files if
i choose not to update then my values remain intact and i dont get any error.
xl2002+ likes to recalculate any workbooks that were created in previous
versions. In earlier versions of excel, if you answer No to the update links
prompt, the existing values are kept...Why are my RSS Feeds not updating
I have three Microsoft feeds, one is Microsoft At Home , one is Microsoft At
Work and the last is MSNBC News. They are in my subscribed feeds list but do
not update as they do on my desktop.
Are they still listed as subscribed when you go to;
Tools-> Account Settings...-> RSS Feeds
If so, removing them and then adding them back might help to revive them.
You can also export the RSS Feeds to an OPML file, remove the subscriptions
and then import the OPML file again.
For details see;
Robert Sparnaaij [MVP-Outlook]
Coauthor, C...Questions on format of Select statement
SELECT tblCalls.ColTime, tblCalls.colProblem,
tblCalls.colResolution from tblCalls, in dbCallLogs
WHERE tblCalls.colResolution from tblCalls,
in dbCallLogs where tblCalls.ColTime >= #12/1/2006# <= #3/2/2007#
ORDER BY tblCalls.ColTime DESC;
I want to know if this is right? I notice in some queries the table name
before the column name is missing? Also when do you have to put in the
database name? Is it the same in Access as SQL Server? I want the most
recent first. I want those records betweeb 12.1.06 and 3.01.07.
On Wed, 21 Mar 2007 13:30:07 -0700, Janis <Janis...Windows says it can't check for updates!
I go to check manually - nothing! I have my settings on automatic updates.
What do I do now?
> I go to check manually - nothing! I have my settings on automatic
> updates. What do I do now?
You come back and give some details on your operating system and whatever
problem you are having (like "Windows _____ with Service Pack _" would be
good, exact messages you get on-screen when you try to update, how you are
trying to update in detail, anything you have tried in order to fix the
problem yourself, etc.)
If you need some he...IF statement that yields a value based on a formula
Help! If cell B12 >= 0, then I need the answer to be calculated based on the
formual "B12 * .40". If cell B12 < 0, then the answer is zero.
How do I do this?
Click yes if helped
"barbara h" wrote:
> Help! If cell B12 >= 0, then I need the answer to be calculated based on the
> formual "B12 * .40". If cell B12 < 0, then the answer is zero.
> How do I do this?
> barbara h
...Visio 2002 Service Pack Update
Microsoft has released an update to Visio 2002 Service Pack 2 that corrects
the problem with file sizes increasing after being saved in Visio 2002 SP2.
The fix is posted as a hotfix patch that gets applied on top of Service Pack
2. You can get the update here:
This posting is provided "AS IS" with no warranties, and confers no rights.
Mark Nelson [MS] wrote:
> Microsoft has released an update to Visio 2002 Service Pack 2 that
> the problem with file sizes inc...Money 2007 Deluxe and SP1 Update
When I start Money 2007 I am told there is an important update (or something
similar) and to click OK to download. I click download and it appears to
Then when I restart Money 2007 I am told the update failed and to try again.
Running XP Pro SP2
MS is currently having a problem with the download updating I suggest
contacting them at 1-866-834-8741 or waiting a couple days and trying again
for now you can click Cancel
"RHinNC" <rhinnc@[get rid of this] hotmail.com> wrote in message
> When I start Money 2...Need a help for updating many tables !
Hi, All !
I need a thought for hepl !
I have 4 tables related together through a field(ContNo).
But there are some reasons, I use temporary value for recording ContNo
field. After that I want to update the temporary value by new value.
Is there any way to do this fastly ?
I thought about using VBA Openrecordset for each Table and update
ContNo field through a form.
Any ideas to solve this problem ?
Thanks for ur time.
On 9 May 2007 03:20:34 -0700, firstname.lastname@example.org wrote:
>Hi, All !
>I need a thought for hepl !
>I have 4 tables related together through a field(ContNo).
>...Problem With Update Prices
I have MS Money 2002. Yes this is an old version, but it worked fine for
I did have the problem in late December with Passport/LiveID servers down,
but waited patiently for the problems to resolve.
I have just noticed that the Update Prices feature has not worked
successfully for me since December 7, 2007. Due to roundoff errors, when I
download my retirement contributions from my mutual fund website for each
paycheck's contributions (employer's and mine) to my retirement plans, I
have to make slight corrections, and this has been effectively manually
updating prices for...updating Mac Office X
I attempted to update my version of Microsoft Office for Mac OS X
from the downloads on the Mactopia site.
The latest version is 10.1.5.
Before installing 10.1.5 I was required to install 10.1.2 and then
I did this and all the installations appeared to be successful.
However, after installation, MS Word crashed and would not open. On
looking at the Get Info for Excel it was recorded as Version 10.1.5 as
was Power point. Entourage was 10.1.4 and Word remained at 10.0, the
original version as installed from my CD.
I deleted the updates and reinstalled 10.0 and Word is OK.
Have repeated ...Update Status field by record selection
Table 1 Name: Bank
Table 2 Name: Ledger
1 Main form with 4 subforms (only having problem with 2 subforms)
1st Subform: UnMatch1 (query based on Ledger)
2nd Subform: UnMatch2 (query based on Bank)
Once my users verfied information from both subforms, they will decide if
those items match (by record) on the Status field.
I need to have a CmdMatch which can allow users to select particular record
and make update the Status to Match or UnMatch.
I did some research all day but only one that's close enough to what I wanted
is the following code:
Private Sub CmdMatch_Click()
Dim rs As...updating PST files...
I went to my power desk files and folder and found my outlook pst file. I
wanted to make a copy on a disk but i noticed that the date of this file is
from a couple of months ago. How do i update that file , before I make a
copy for storage?
Christine <email@example.com> wrote:
> I went to my power desk files and folder and found my outlook pst
> file. I wanted to make a copy on a disk but i noticed that the date
> of this file is from a couple of months ago. How do i update that
> file , before I make a copy for storage?
What do you mean my "update the file"...Use this important update for Windows
Content-Type: multipart/related; boundary="fsveuaegtt";
Content-Type: multipart/alternative; boundary="esrvjidpsty"
this is the latest version of security update, the
"October 2003, Cumulative Patch" update which resolves
all known security vulnerabilities affecting
MS Internet Explorer, MS Outlook and MS Outlook Express
as well as three newly discovered vulnerabilities.
Install now to protect y...Chart does not Auto-update anymore .Why?
I have a file that once I entered a value in an input cell the v-look up
grabs the data related to the input an displays that information. The chart
previously updated to reflect the new data once I hit return but does not
update without first saving the file. Is this a memory issue or something
jacked up in file/graph properties ?
Maybe check out Tools -> Options -> Calculations?
I'd guess it's something with the auto-update area of excel.
UofMoo's Profile: http://www.excelforum.c...XP Service pack3 KB936929 update
When I do an update for XP Service pack KB936929, after a reboot Iam unable
to connect to the internet but my wireless connection tells me that I have a
strong connection signal. To cure this I have to restore back to before
loading KB936929. Why will it noit klet me connect to the internet.
Windows XP Service Pack 2/3 Problem Solver
After 12 April 2010, XP SP3 your computer will NOT be offered ANY critical
security updates nor will Windows Update website be available until & unless
you get XP SP3 installed.
"Staffnurse&quo...Update table with data from rows with previous dates from specifie
I need to update a table where if a row contains a specified stat value I
need to change a date value to the date value of a row with the same subID
but a different stat value. My primary question would be if I need a cursor
to perform this operation or if it can be done without a cursor (Sql Server
2000 Tsql please).
In the sample data below if a stat value is in ('A', 'E', 'U') I need to
update that row - I need to update the date2 column with a date1 value from
the closest row with the same subID but the stat is in ('N', 'R') and ...How to delete phantom statement?
In M2007 I have a downloaded OFX statement for an investment account
that won't go away.
It says there are 2 transactions, but if I click on them, there are
none. If I try to delete the downloaded statement, there is no error,
but the statement does not go away.
I've tried repairing the file - no errors, but statement is still
there. I removed online services for that FI, restarted Money, and
set up online services again but its still there. I also had a few
new transactions come in, and the new statement downloaded fine, but
after it was processed the old statement is still hangi...IMF V2 /// Auto Update (Microsoft Update) does'nt work
on a E2K3 std US SP2 FE srv, IMF V2 auto update (Microsoft Update) does'nt
I have 2 Front-End E2K3 load-balanced servers.
On the 2nd node, the IMF auto update works fine but on the first node,
best practices from
been applied on the 2 nodes:
How to enable updates
After you enable the Intelligent Message Filter in Exchange System Manager,
to enable Intelligent Message Filter updates, you must create the
ContentFilterState registry entry. To do this, follow these steps:1. Click
Start,...Combo No Change and After Update Event
I have a combo box where the After Update event of the combo box is
used to reset another control on the form to Null.
Sometimes a user will want to reconsider his/her choice in the combo
box and make a different selection from what was there before. This is
OK as it triggers the resetting of the other control to Null.
My problem is - sometimes the user will revisit the combo box and
explore the other possible selections in the combo but eventually
settles back on the original selection with the result that the After
Update event is triggered and the other control value is scrubbed,
which i...Multiple IF statement replacements?
I need some help and don't know if it will be possible to get it to do
what I need. I am automating all my paperwork I do every morning and I
need a cell on a worksheet to decypher people's initials and translate
it to a name. here is a sample of what I have.
TARGET'!A21="LM","Liz&q...Update path to Dynamics GP 10 ..
The documentation says we can move from ..
8.00g73 >> 10.0
Is this refering to the version of Dexterity or Great Plains.
We are on ..
Great Plains .. 8.00g34
Dexterity .. 8.00m076
Thx a bunch.
That refers to your GP version. You need to download and apply a service
pack prior to upgrading to v10.
> The documentation says we can move from ..
> 8.00g73 >> 10.0
> Is this refering to the version of Dexterity or Great Plains.
> We are on ..
> Great Plains .. 8.00g34
> Dexterity .. 8.00m076
> Thx a bunch.
>...Update data from sql, using ODBC
I am preparing a model to be used by multiple users every week. A part
of the model is a list of active project in the company.
The project informations comes an sql database.
In the model I have a table, which should be updated when the
excelmodel is opened.
The users do not have access to the sql database. Is there a way to
set he table (properties, ... ) with the password stored in the model
e.g. the users do not have to know and enter the password.
Med venlig hilsen
...Update 979683 doesn't install correctly on WinSrv2003EESP2x64
The update 979683 is seemingly installed correctly on my W2K3SRVEEx64sp2.
But when I verify the 'hal.dll' component of the update is NOT updated.
The "KB979683.log" file states that "LoadFileQueues:
UpdSpGetSourceFileLocation for hal.dll failed: 0xe0000102"
I have verified that the 'hal.dll' is not updated in any normal locations
for 'hal.dll' under '%WINDIR%', it is still the old version.
I have seen from posts on other sites that the above error might occur when
MS engineering has done some kind of error in th...