Why is Actual Work updated when entering time into Work Field?
We're using MS Project 2007 and seeing that sometimes when time is entered
into the Work field for a task, that task's Actual Work is updated to the
same value entered in the Work field. This happens to multiple resources,
but only on some of their tasks and not on others. For example, for the
weeks of 1/24 and 1/31, whatever hours I schedule (enter in the "work" cell
in the Resource Usage View) for a given task also appears in the "actual"
The tasks are setup up differently. Some are Fixed Work, some are Fixed
Duration. I believe all have the e...Help! Install Key Doesn't Work!
I have been happily using Microsoft Money Deluxe (version 17.00.1414) for
over a year. I purchased a new computer several months ago and installed
Money from the same install file (downloaded from Internet). I ignored the
activation notice for weeks because I was too busy to fire up the old
computer, but now am trying to activate it and it keeps failing. I used
Belarc Advisor to retreive the install key from my old installation, but for
some reason this install requires a key with a different format. The old
format is xxxxx-xxxxx-xxxxx-xxxxx-xxxxx, but the new installation requir...Emails Receiving time in Inbox Differs
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: pop
Hi, <br><br>I wonder if anyone can help me with this. I realised that my incoming mails received in the in the Inbox, the time received is different from actual time received. Meaning, the timing in the inbox shows the time that I download the emails. IS there a way to resolve this?
...Excel 2003 spreadsheet. I enter the any number and it is entered.
If I enter a number into a cell it is put in like a decimal. For example, if
I enter 10 it is put in as .1 500 is entered as a 5
Goto Tools>Options and on the Edit tab you should see The Fixed Decimal
Places box checked. Uncheck it.
"maryu" <firstname.lastname@example.org> wrote in message
> If I enter a number into a cell it is put in like a decimal. For example,
> I enter 10 it is put in as .1 500 is entered as a 5
> Thank you
...Onkey vs Macro Short cut key
Is there a benefit to using the macro short cut key in macro options vs
coding a key combo using Onkey?
rgarber50's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11350
View this thread: http://www.excelforum.com/showthread.php?threadid=385952
I don't think there is a huge difference but with the macro options approach
the shortcut is almost always there. For instance it takes a macro to run
to set the Onkeys but not for macro options. And to extend ...Calendar entries with macros
My wife makes 6 types of appointments repeatedly.
I figger 6 macros:
add the type of appointment at the selected time
change the color
set the lenngth
set the reminder time
Any one have some examples of such?
...Filter records by date in subform by date entered in mainform.
Hello, I've spent 3 days trying to understand what I'm doing
wrong.....Here is the summary of my problem.
I have a form named 'frm_EfficiencyStats' and a subform within the
form named 'qry_Total hours subform' (the subform is based on a
query). The form contains a text box (for date) which is bound to a
I would like to be able to enter a date in the text box on my form,
and display the records in the subform based on the date I entered in
the text box. The subform will only pull records from my table based
on the date.
Here are th...produt key
i got the cd microsoft office 2003 but when i try it ask me for a 25 digit
product key could you pls help me
The product key should be with the CD.
(remove nothere from email address if mailing direct)
in message news:0E585FDC-301Eemail@example.com...
> i got the cd microsoft office 2003 but when i try it ask me for a 25 digit
> product key could you pls help me
...How to get two different grouped pivot tables from the same data table?
I have one data sheet that looks like this:
Date Value (=80)
From the data sheet (Data) I have created a pivot table grouped by
months and years (Pivot 1) with the sum of value. That is no problem.
But later when I create one more sheet where I want the data to be
grouped by weeks (Pivot 2) the grouping changes in Pivot 1 to weeks
Does anyone know how to get around this? How can you get for example
get one pivot graph showing the sum per week and one per month in the
same Excel file using grouping on...how to enter simple list and sum
using excel 2002 with an xp sp2 system
how would I enter a simple list of positive and negative numbers and then create a
cell with the sum of these values?
if the list would look like this
the output would look something like
In B1 enter =A1
In B2 enter =B1+A2
Copy down to B5
Gord Dibben MS Excel MVP
On Wed, 16 May 2007 06:34:13 +0300, "John" <firstname.lastname@example.org> wrote:
>using excel 2002 with an xp sp2 system
>how would I enter a simple list of positive and negative...License/Install key- how to change....
Does anyone know how to change or delete the software key (ID)? I've installed Office with a key that was accidentally installed on another machine, so I have a duplicate, and I can't run both at the same time. I've purchased another license, but can't see how to get rid of the old key.<br>
I've tried to uninstall/reinstall, but that does not delete the software ID- does anyone know how to do this?
Office 2008, see here:
Office 2004, see here:
http://www.mcgimpsey.com/macoffice/office/pid.ht...How do I declare a function whose output is an array?
My current workaround to this problem is to declare the function as
Public Function xyz(abc as Range) as Variant
'klm is an array
xyz = klm
This works efficiently enough, but I would like to tidy up my code by
eliminating all non-explicit declarations.
Furthermore, can someone tell me what exactly the difference between an
array and a range is? For example, if I declare the function as
Public Function(abc() as Double) as Variant, how will that make a
difference? Is there any advantage of one over the other?
Will functions like Rows.Count or Application.Count ...Resource Units for Tasks entered in PWA differs than tasks entered in Project 2007
I have an ePM user asking why if he enters a project task in PWA does
it not check the resource max units allocation the same way as when he
enters a task in Project Professional.
You have a project where resource A is 50% allocated. When you create
a task in Project Professional for this resource, the resource
allocation is set to 50%.
Create a task under the same project in PWA, submit and approve the
Open project professional and view the task information for the task
entered in PWA, why is the resource allocation set to 100% instead of
50% set for th...IF Function with Text values
Hi, I can't seem to get the IF formula to work with my spreadsheet. I have
two colums one with user login the other with surname and i need to pick the
surname out of the user login and i can't get the IF true or false to pick
out the surnames, any help very much appriciated.
use something like
> Hi, I can't seem to get the IF formula to work with my spreadsheet. I
> have two colums one with user login the other with surname and i need
> to pick the surname out of the u...Enter formula by code.
can anyone help. I cant seem to get this to work.
I keep getting run time error 1004
application or object defined error.
Public Sub TLIdentify()
finalrow = Worksheets("INV Bookings").Range("B65536").End(xlUp).Row
Worksheets("INV Bookings").Range("AV26:AV" & finalrow).FormulaR1C1 =
Regards and Thanks for any assistance.
Francis Brown...Entering a dollar amount w/out having to enter the decimal
What is the formula to have Excel automatically enter the decimal so all I
have to enter is the numbers?
It's one of the options you can specify. In Excel 2007, it's:
Excel Options...>Advanced>Automatically insert a decimal point
"Julieanne" <Julieanne@discussions.microsoft.com> wrote in message
> What is the formula to have Excel automatically enter the decimal so all I
> have to enter is the numbers?
I have a table of data as below. There are more Customers, and more dates'
worth of data, but they won't fit in this window. For a number of our
customers, we change delivery routes during the week in order to optimize our
shipping capacity. Basically, I am trying to see for each delivery route, on
a given day, how many of the same customers are on the same route. In other
words, when one customer changes from one route to another over a date range,
do other customers switch to the same routes on the same days?
Cust # Rt# 8/27/2005 8/29/2005 8/30/2005 8/31/2005
...How can I show different bar colors in the same chart?
I have 2 different data groups in the same month for a 3 month period. I want
to show the same data groups for all three months in the same color. Example:
I have an "in" total and an "out" total for Nov, Dec and January. I want to
show all "ins" as blue and all "outs" as red. This would be for a bar chart.
If I put the text "in" and "out" in B1 and C1
In A2:A4 I have month names : Nov, Dec and Jan
In B2:B4 I have in values and in C2LC4 I have out vlaues
Seelct A1:C4 and make a bar chart
The Out data is red, the In data blue
Can y...How do I stop dates from being entered everytime I enter a number
Everytime I enter data in a box (ex: ages 5-9) I then press enter to go to
the next cell and it automatically puts in may 9 . I have tried putting in
general in formatting cells and it still does it. can someone help before I
shoot this pc out the window? I am making a population pyramid with males
and females and their ages.
Kicking and Screaming
You can precede your entry with a single quote...
....or format your cells as 'Text'.
Hope this helps!
In article <64AE5219-035D-46E3-9488-5D01F6B012FA@microsoft.com>,
Kicking and Screaming <Kicking and...Userform to be referenced by different VBA Project?
How can userform in Project_Accounting be also referrence in Dynamics_GP or
Open the Dynamics Go in VBA click Tools --> Reference --> Mark SmartList
as reference to your current Dynamics GP
With this you can refer any Project Accounting Form under dynamics.
But VBA In Dynamics dosen't support Circular Reference.
for Ex: You can have reference from Dynamics to Project Accounting.
But again you cannot goto Project Accounting VBA and give the Reference to
Dynamics VBA (this is not supported)
Hope this helps
&...Odd Mailbox behavior
I have a user that has mailbox rights to her boss's mailbox. In addition,
she has been granted full delegation rights thru his Outlook (2k3). All
emails reside on the server, until Archiving performs its cleanup.
Issue: The boss has subfolders under his inbox (all reside on server, no
pst minus the Archive pst). He calls and requests that his admin assist move
emails from his inbox to a subfolder. The email moves, but is gone the next
day. If the boss performs the move, the email does not dissappear.
What has been done:
- verified she has full mailbox permissions on the...entering time #2
wondering if there is any way to do this...
I have a column formatted for time as in this format 12:00
when entering a time it is cumbersome to have to enter the hour, then a
colon, then the minutes.
Is it possilbe to simply enter a 4 digit number such as 1245 and have it
show up as 12:45 ??
thanks so much... I've found this group to be irreplaceable...
glen in orlando
Enter your times without colons in column A and put this formula in column B
and format column B for "Time" in the form you want it.
"Glen i...Entering data
Please help me enter data into cells that seem to be
In article <email@example.com>,
"Alicia Contreras" <firstname.lastname@example.org> wrote:
> Please help me enter data into cells that seem to be
Tools > Protect > Unprotect
Hope this helps!
...Install version 10 on different server from version 9
I've got some questions on GP licensing. Can we can have multiple installs of
the GP back end? How is the Dynamics GP license granted? I know we have
multiple client licenses, one for each desktop, but what about the server
portion? Can we have multiple servers?
We've got about 3 companies under a parent company who has a GP 9 license
with "Software Assurance". We were sent the GP 10 install CDs and product
2 of our companies are already on GP 9 running on a sql2000 server, but we
won't be able to upgrade them to version 10 for another year due to some
int...Date Function in query
I have two tables. One is INVOICES, the other is "INVENTORY. Each has a
DATEMODIFIED field. The dates in INVENTORY are formatted dd/mm/yyyy
hh:mm:ss. Yet dates in INVOICES are formatted dd/mm/yyyy without any time
stamp. The Date() function as query criteria works on the field formatted
dd/mm/yyyy but does not on the other. Both fields are filled by code. Both
tables have the DATEMODIFIED field formatted the same in the design grid.
Why is one table saving dates with the time stamp and the other table is not?
Sorry, I forgot to tell you that I am using Access 2007.