Cannot log in using WindowsID (was able to before)
I just bought MS Money 2007 Deluxe yesterday. The install went smooth,
without any issues. I registered a new WindowsID and was able to successfully
log into MS Money.
However, today when I tried to log into MS Money, the messge apeared that
the "Money was not able to recognize your WindowsID" or something like it and
that "You will still have access to some functions but will not be able to
make online updates".
Now I'm not able to make updates. Any idea what this could be? Is the
authentication server for WindowsID down or something?
See the post under Mon...Can't use Merge feature
If I have a postcard file I've already made on the
screen, when I try to pull up the "Merge" feature under
Tools, it is shaded grey and I can't open it. It insists
that I either form a new database list of addresses or
edit the one that I want to merge. I don't want to edit
the one I want to merge. I just want to MERGE it.
If, however, I have just a postcard template on the
screen (without it having been made into anything), I CAN
pull up the "merge" feature under Tools. It is not
How do I un-shade the "merge" feature?
To merg...Notes or comments in formula bar
I vaguely recall an article I read that mentioned I could
insert a note or comment into the formula bar. Can
someone tell me how to do that? I'm not talking about
Example: If I were to have A1+B1, there's a trick that
will allow me to add a note within the formula bar such
as "this formula adds apples and oranges."
=A1+B1+N("Type Note Here")
>I vaguely recall an article I read that mentioned I could
>insert a note or comment into the formula bar. Can
>someone...Numbers in a text field-can I add them up?
Hi everyone! Using A02 on XP.
I have a table of data with survey response fields that contain a 0,1,2,3,4
or 5. However, the fields are formatted as text, not numbers. I need to add
up certain blocks (Items 1-6, Items 7-23, etc.) and then do some averaging.
I cannot change the field types from text. Must I append to a new table or
can I do something right in my query?
I've got one field in my query like this: ES:
My result is: 553453 or 554444, etc. I want: 25 or 22, etc.
I would really appreciate any help or advice. Thanks...I've got a formula for stones and pounds
I've got a column that displays a series of weights in stones & pounds (both
in the one cell). How do I get a chart to recognise and display in the same
What is the format of the cells with stone & pounds
It is best to enter such values a 10 3/14 and format the cells with # ??/14
best wishes from one who is INT(275,14) stone & MOD(250,14) lbs
Bernard V Liengme
remove caps from email
"mikelenno" <firstname.lastname@example.org> wrote in message
news:5AD608FA-5367-4CED-AD76-1F54228EFDBA...Restore Exchange 5.5 on 2000 using ArcServe
- Windows NT 4 Server SP6
- Exchange 5.5 SP3
- ArcServeIT 6.61 with Exchange Agent
I'm trying to restore the Exchange information (database, mailbox...
everything) on another computer.
That computer has
- Windows 2000 Server SP4
- Exchange 2000
- Brighstore ArcServe 9 (build 2020) with Exchange Agent
Now the situation: I need to verify that the backup was made correctly
(entirely) in order to confirm the total validity of the backup (to validate
my disaster recovery plan) and to update to SP4.
I tried to find documentation with both Microsoft (for Ex...Timestamp value of GINA window presentation
I am currently troubleshooting slow logon times for a client with computer
infrastructure spread across the globe. Before I start invesagating I want to
create a baseline for logon times.
I have modified the clients logon script to record when it starts and when
it ends. I am using the computers tick count to record how long the computer
has been on, but realize that there is a space of time between the user
authenicating to the computer (control-alt-delete) and when the logon script
starts, if the customer turns his computer on and then leave for an extended
period of time I ...Setting series values on Excel Chart
I'm struggling very hard in getting beyond this error when trying to use VB to generate a chart from data previously inserted into the sheet.
Unable to set the Values property of the Series class.
The code works absolutely fine in XL2007 but I am having to port it back to 2003 and the inference is that its empty values that cause it to hiccup - something I cannot avoid.
My code is:
1. Retrieve selected data from database and place it at the top of the sheet
2. Add The Chart
3. Iterate through the data (amount can be variable depending upon user inputs)
For j as i...data value in Form field if no table entry
I have a form with a field which pulls through and concentenates 2 fields
called [ContactFirstname] and [ContactLastName]from my table
There are however some customers for whom I do not have names and therefore
instead I would like Sir/Madam to appear in the field in the form
I think I have seen this done somewhere using ELSE? but can't find it
Any help/ideas gratefully received
Perhaps something like this:
Nz(Trim([ContactFirstname] & " " + [ContactLastName]), "Sir/Madam")
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access use...Summing distinct rows in same cell
Sorry for the bad title I'm not sure hte best way to sum up this issue.
Fruit Price Total
Apples 0.69 40
Bananas 0.34 38
Lemons 0.55 15
Oranges 0.25 25
Apples 0.5 10
Pears 0.59 40
Almonds 2.8 10
Cashews 3.55 16
Peanuts 1.25 20
Walnuts 1.75 12
Apples 0.5 5
Given the data above I'm trying to sum the totals for only the Appl
rows. So basically I need to search the Fruit column find the row
that have "Apples" and then sum their corresponding Totals, giving m
55. I've been playing with this for hours with Lookups and Indexes bu
am not really getting anywhere. Also, I can...How to use structured reference (ListColumns) in VBA
I want to do something simple...loop through a range retrieving values one at
time and taking action on that value. This range is an Excel 2007 table
column. Easy enough...BUT I want to use structured references to a table
column by NAME, not numbers. I don't want to define new names, just use the
table column headings. I've found ways of doing it with quotes, but that's
not structured....the names in quotes do not change if the table heading is
changed by the user.
The formulas change if the table column heading is changed, but I want it to
change in VBA to...Save As using contents of Cell in Name
Can someone help with code that changes the "save As" file name to
combination of the original File Name + the contents of a cell, an
saves file in same folder as the original.
E.G. Original File Name= Timesheet
Cells B1= Location
Cell C1 = Date in format 3-5-2004
Cell A1 = concatenate(B1,C1)
Fle Name will therefore be "Timesheet Location 3-5-2004"
The other problem is with the date. When concatenating, how do I forma
the date to avoid it looking like "Location 38051"
Any help much appreciated
Message posted from http://www.ExcelForum.com
for c...IF / SUM
I have a spreadsheet with 17 rows, each representing a project name. In
the columns, I have 2 cells for each week: Est and Actual. At the end
of each row, I would like a row total for Est and another for Actual.
As there are 20+ weeks represented, I cannot select the cells that have
the criteria I'm looking for without using a more complex formula than
SUM. Any ideas?
The spreadsheet looks like this:
Project Name Apr 3-9 Apr 10-16 Apr 17-23 Total
Est | Actual Est | Actual Est | Actual E | A
Project A 20 | 22 40 | 37 25 | 26 85...Conditional sum
Can you help?
I would like to sum a matrix according to a condition in a row and in
different condition in a column. I know how to do this one dimensionally
(either in the row or the column) using sumproduct, but what about two
Let me give an example, number of widgets produced each week by each type of
A B C D
1 weeks>>1 2 3
2 Type 1 10 15 11
3 Type 2 20 5 10
4 Type 1 5 12 21
So, I’d like the formula to be a...Error- Project is used by another user -Please select another proj
Please see the subject line, when im trying to open a particular project.
it gives me following error.
I checked the current users, there are no users. Apart from me.
There are some non PA users,i tried to remove them from activity.
inspite of me removing them from activity, im geting the same error.
There is a stranded user in PA000001 table. You need to clear this
> Please see the subject line, when im trying to open a particular project.
> it gives me following error.
> I che...Excel formulation to automate values
I have a little problem on arranging a small multi-worksheet excel here.
Let me explain in a short way then give some details on it.
I am trying to make an offers recordsheet which has two worksheets in it. One
for products(and their base prices) and an offer sheet. I would like to use
a bit dynamic data here. So when I type the name of the product excel would
give me the price from other worksheet.
Prices worksheet is something like:
1 Product BasePrice
2 mouse 5
3 keyboard 8
And the ...Using Excel in Mac office 2004 with Microsoft/Mac 2008:Analysis toolpack
Although I am disappointed with Office 2008 for Mac because of the
Analysis toolpack, I figured things out quite recently that I can
install my Mac office 2004 and use the excel package that contains the
Analysis tool pack. How? ...... let me show you:
1. Insert your CD for Mac office 2004
2. When it open on your desk top, two options will be given to you to
download the software
(a) Office set-up assistant, and (b) Microsoft office 2004.
3. CHOOSE MICROSOFT OFFICE 2004 (Drag the icon onto your desk top) and
will start to run/download.
4. When done, this will appear as ...How to obtain enumerated attribute declarations from a DTD using MSXML & VB?
I have a VB (VB6, not .NET) application that reads an XML file (using MSXML
v3.2 parser); the XML file contains a reference to an external DTD.
The DTD has numerous enumerated attribute declarations like so:
MyAttribute (One | Two | Three) "One"
The VB code needs to generate dynamic pick-list for all the attributes that
appear in the DTD as part of a data-entry application; each dynamically
created pick list should contain all the allowable values for the attribute
as defined by the DTD (and presented in some kind of multiple choice control
like a comb...Using Excel spreadsheet as input to Access
I posted this in the New Users forum but only got one answer, so
thought I'd try here as well.
Like so many others, I am an Excel newbie. I was a mainframe COBO
programmer in another life, but that was a few years back
My manager would like me to write an app that will take tracking dat
from an existing Excel spreadsheet (generated by our system) but onl
use a select handful of columns as input to a new Access database tha
I will create.
I'm guessing that I can either a) create a new edited spreadsheet to b
used as input to the Access database or b) use the Import wiza...HELP
We have an application that is used by over 8000 people worldwide. One
of our users is just starting to have the following problem:
Run-time error '-2147467259(80004005)':
Method 'Add' of object 'CommandBarControls' failed
I have read that this problem can be caused by trying to open the file
in Internet Explorer. The user has told me that she has tried opening
MS Excel and then the .xls file and she still gets the same problem
when the file is trying to open. She is the only one that has had this
problem. Could there be something wrong with her Excel settings or som...Formula for ageing debt
I'm trying to do a spreadsheet so that when I put a debt amount in the first
column, after 10 days it will automatically move to the next column and move
on every 10 days till a 60 days column where it gets added to any amount
already there. Can anyone clue me up to a formula to do this?
Barnie Gumble Esq
You will have to devise a way to associate the date of initial entr
with the entry itself, then it is relatively simple to do - could yo
have a lookup table on a separate sheet that returned entry dates fo
all amounts, BUT the amounts would have to be unique, ie n
duplica...formula to get sheet name
can a formula retreive a worksheet name or does it need to be macro based?
This formula that takes care of the possible situation whereby you have only
one sheet in the workbook and its name is the same as the workbook's. Note:
CELL("filename") will only work if the file has been saved at least once and
if the file is opened in a different language system, the argument
"filename" will need to be changed manually to the corresponding word (e.g.
in Spanish "nombrearchivo"):
=LOOKUP(REPT("z",255),SUBSTITUTE(MID(CE...Using Risk+ with MSP 2007
We use Risk+ as a risk simulation tool. We have discovered that it works
approximately 20 times SLOWER in MSP 2007 than MSP 2003. Has anyone else run
into this problem. If so, is there a remedy?
My hunch this not a generic issue, but surely best that you consult with
the Risk+ people on this.
On 02/03/10 18:08, Tom Mc wrote:
> We use Risk+ as a risk simulation tool. We have discovered that it works
> approximately 20 times SLOWER in MSP 2007 than MSP 2003. Has anyone else run
> into this problem. If so, is there a remedy?
W...Using subtotals as single data entries
Sorry about the subject--I couldn't figure out how to describe it
I have a large file (16,000 records) of amounts billed by roughly
10,000 service providers. A number of these providers have multiple
office locations, so each record is unique to a specific office
location. In other words, a provider who billed from 3 different
office locations will have 3 entries. Each provider has a unique
provider ID number, which stays the same regardless of which office
location he is billing from.
I want to be able to subtotal the amount billed by each provider for
all their office locations...Assign values for one column to another.
I have in column T certain numbers and texts that that I require to assign a
value to as below, in the adjacent column. Again any pointers would be much
Well, imagine that two-column table occupies cells Y1:Z20. Put this
formula in U1:
and copy down.
Hope this helps.
On Oct 14, 4:26=A0pm, Celticshadow