resource usage 01-13-10
Is it possible to display remaining work in the right hand Pane? I can
display it in the left hand pane (the table section) but can't seem to
find in the right hand pane (the timephased area).
eg. I want total remaining work for each resources for each month
lk50's Profile: http://forums.techarena.in/members/87282.htm
View this thread: http://forums.techarena.in/microsoft-project/1292777.htm
Nope. Remaining work is not a time...Unable to update public free/busy data
A user recently had Office XP installed with Service Patch
1 installed. We run Exchange 5.5 with up to date patches
There are a number of other users with same Office XP
installation that are not experiencing any problems,
however this one user, sometimes several times during the
day, receives the pop up Outlook message "Unable to update
public free/busy data. Operation Failed". It does not
appear to be affecting day-to-day operations. There is no
pattern to when the message pops up. Outlook is open all
day, and the user moves between other Office applications,...Truncate a field
I have a report based on a query and only want to show the first 550
characters in the field (set as a memo in the table) because the report is
getting very long showing all the historical statuses. How do I do that?
You should be able to use the Left() function like:
=Left([set as a memo], ...number of characters...)
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
> I have a report based on a query and only want to show the first 550
> characters in t...Update field names using a query
I have to do a daily import from our accounting software. I have queries
created that update a lot of the information that I need. However, I was
wondering if there was a way to do a Make table query or an update query that
I can rename the field names instead of me mannualy doing it each day. After
I clean the data, I have to export it into our leads database and the field
names have to match.
There are about 15 fields in this import that have to be renamed every day,
I was just wondering if I could write some kind of query that could update
the field names for me.
Thanks for any in...Finding an external update
I have a workbook that when opened, asks if I want to
update it from external worksheet.
It is probably a hangover from a copy and paste. What is
the easy way to find the offending cell(s)so I can delete
any external reference?
One way is to download and use
Bill Manville's excellent "FindLink" utility ..
It's available at Stephen Bullen's page:
GMT+8, 1� 22' N 103� 45' E
"Nolan" <firstname.lastname@example.org> wrote in ...about resources and the using
GC removes objects when the GC decides so because C# is managed.
At the bottom I have a code snipped.
The book I read say Always call Dispose() on Pen objects or use the using
feature on the Pen object.
I mean C# is managed so I can't understand why I should dispose the Pen
object. GC should take care of this.
The reason is probably that I mixup memory and resources. GC take care of
free memory but not resources.
I have some problem to understand why I must dispose the Pen object here
because I see the Pen object as
any object such as a Person or Car.
So my first qu...added line won't update accross sheets
having multiple sheets in a workbook the first four sheets updaye the fifth
sheet. If I add a line the new line will not update to the other sheets. is
there anyway to make this work?
You're saying that you have formulas on the fifth worksheet that refer to
cells on the first four worksheets and that when you make an entry in a cell
on one of the first four sheets to which no formula in the fifth sheet
refers to, that a formula does not magically appear there? If that's what
you want you're going to have to create new formulas yourself on the fifth
sheet, or copy existing ...Subject line "Updated:" annoying
I don't know about anyone else, but I find that the length of a calendar item
Subject line is precious. Particularly when viewed in a calendar grid or on
a synced mobile device. I want to be able to recognize a meeting in the
first 20-ish characters. I will often re-edit my copy of meeting invites to
fit my context.
Therefore, I do not like Outlook's behavior of prepending "Updated:" to
meetings that have been changed by the inviter. I know the meeting was
updated when I accepted the change. (No I don't allow that to automate).
Is there a way to s...MCSD Resource
I have found a resource providing answers for examination questions
being helpful in certifying for MCSD....
...problem with arrangement of fields in address block
my merge results look like this:
I am not able to click in and add spaces or punctuation. the address box
formatting seems to be non-existent. Nor does matching fields have any effect
on the data. please help me!
What version Publisher are you using? What data program are you using for the
merge? If you are using Excel have you titled the fields?
"jankappes" <email@example.com> wrote in message
I want to use a consistent shape in many pages. Is there a
way to create a master copy such that when I update the
text on a master copy all copies are updated. I created a
new stencil and new master but updating the master doesn't
seem to update the copies (after i save the file).
You have to update the master in the local, or "Document Stencil"
Every Visio drawing contains a "hidden" Document Stencil, that carries
copies of masters from "external" stencil files. When you drag a new shape
into a drawing, the master gets copied from the external .v...Test on Type in Resource Center
In Project Server 2007 SP2
In the Resource Center of PWA, I'm trying to filter on the resource's Type :
Work, Material, Cost
But the system reject any test on these words. It seems it's waiting for
Have you any idea to test on this Type field?
Even though the Type field displays text data, the underlying data is
actually numeric. So, you have to test for the following numbers in your
Work resource = 0
Material resource = 1
Cost resource =2
Hope this helps.
Dale A. Howar...Resource Capacity Planning
I'm looking for an Excel application that illustrates resources availability
by week over time (3-6 months)
Click Software > On-Line Catalog > Excel Software > Management Software
Scroll down and look for "Scheduler" (free excel file)
"Paul Hipgrave" <firstname.lastname@example.org> wrote in message
> I'm looking for an Excel application that illustrates resources
> by week over time (3-6 months)
...Converting resources in Exchange 5.5 to be compatable with Outlook 2003!
We running a NT4 Enviroment with Exchange 5.5 and and clients such as
Outlook 2000 and 2002 originally this was Inbox but over the years we have
uppgraded. OS's are 2K and XP. All working fine untill we starting
installing Office 2003 with Outlook 2003 and now we canot use resources like
calendar in Exchange 5.5 we can happy create new ones. Does anyone have best
way of upgrading resources to be compatable with Office 2003. In a about 4
mounths we going to Exchange 2003 but untill then I need a quick fix :-)
Thank you very much,
Are you referring to automatic bo...How do Resource Groups relate to Resources
I am trying to figure out the linking table / GUID that connects Resource
Groups to Resources/Users. Does anyone know what table in CRM connects
There isn't one. The group membership is defined in an XML document that is
stored in the Constraints field of the ConstraintBasedGroupBase table (which
is linked to ResourceGroup by them both having the same primary key value)
David Jennaway - Microsoft Dynamics CRM MVP
> I am trying to figure out the linking table / GUID tha...Using combobox results when bound field is null
This combobox is a list of all the teachers, and also displays the number of
children, and the number of families assigned to each teacher. Some
children do not have a teacher assigned yet.
The drop-down list, and the query it is based upon, correctly displays a
null in the Teacher column, and the correct count of children and families
in columns(1) and (2).
However, when I look at the value of cboTeachers.Column(1) or
cboTeachers.Column(2) in the Immediate window, the Locals window, or passed
in a Message Box, they all show up as null values.
I'd like to get a coun...Resource file (rc) units
I am currently trying to port a MFC app to the wxWindows API.
My problem is I would like to convert a rc file to the wxwindows resource
format but I don't understant units used in MS file.
IDD_LECTEUR_DIALOG DIALOGEX 0, 0, 679, 471
STYLE DS_ABSALIGN | DS_SETFONT | DS_MODALFRAME | WS_POPUP | WS_VISIBLE
FONT 8, "MS Sans Serif", 0, 0, 0x1
CONTROL "",IDC_PANEL_CENTRAL,"Static",SS_LEFTNOWORDWRAP |
LTEXT "",IDC_STATIC_PANEL,36,138,593,195,0,WS_EX_...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...Date calculation on 2 fields
I have a query that calculates captures a date filed 20 days after the date
which is entered. It then gathers all the dates after the 20 days has been
calculated. I need to code another date field that doesnt grab info 45 days
past the date.
Example: works now
user - puts in date 1/28/2010
query - subracts 20 days from that date = 1/08/10
query - then gathers all the dates after 1/8/10.
Need - To look at another date field and make sure no data is gathered 45
days from the date in field.
Are you talking about two separate queries, or a single query with two
...Calendaring / Resources in 2K7?
Is there anything for resources built into E2K7? Are we still to use some
sort of auto accept?
On Thu, 14 Sep 2006 09:19:02 -0700, Dan
> Is there anything for resources built into E2K7? Are we still to use some
>sort of auto accept?
Much of that will be built-in:
Yep - works well, too. I blogged about the Calendar Concierge capability a
http://winzenz.blogspot.com/2006/06/exchange-2007-calendar-concierge.ht...Help with SQL Table/Field
I am trying to run a purchasing report that includes item #, qty ordered, qty
shipped and qty canceled as well as promised date and PO#. I have all the
data I need except for the qty shipped on each line. I've found all the data
I need in tables POP10100 and POP10110. Can anyone help?
The QTYSHPPD values are in the POP10500 table...
Microsoft Certified Business Management Solutions Specialist, GP 9.0
Currently supporting: GP 9.0, SP2
> I am trying to run a purchasing report that includes item #, qty ordered, qty
&g...Update Links #2
hi. each time i open my workbook, Excel informs me that the sheet
contains links to other sources, would i like to update. is there a
way to know as to which cells are linked to external sources?
When you have formula links in an Excel Workbook (destination) to another
Excel Workbook (source) you will be asked if you wish to update links in the
Workbook (destination) each time you open it. This can be painful when you
always want, or don't want, links updated.
It isn't hard to find links without a macro. Simply use Edit|Links and
you'll usually be able to see the first ...How to release resources hold by Creating Rescue Recovery process
In Windows XP SPK3, on IBM Laptop T60.
I followed the instructions to create the rescue/recovery CDs. At one
point, there was a window screen telling me to wait while it was extracting
needed files. So, I waited. After more than 10 minutes (I thought), the
window screen went away, then NOTHING was shown to tell me what to do (I
supposed to get the window screen to tell me using the CD drive and insert
blank CD, ..., etc.). I waited another 20 minutes and still nothing was
shown. So I REBOOTED the system and retried the procedure. This time, after
I clicked "creating...Cannot update Publisher 2000 deluxe, even manually
I have tried to update Publisher 2000 after installing, uninstalling, and
reinstalling. Neither the office update site nor the manual download file
will work. The office update does update Word 2000, part of Works Suite
2001. I have even uninstalled Works and reinstalled Publisher 2000 by itself
and it is not recognized. The manual download update tells me that the
update has already been installed when Word is present (and already updated),
and tells me that the expected version of Office component is not present
when Publisher is installed by itself. Any ideas?
Are you getting a...How to get the resource from Resource Only Dll
if(hr == NULL)
MessageBox("This is not working");
MessageBox("This is working");
here, i am try to get the image(gif) resource,which is stored in the dll(for
example testdll.dll). Where as image resource type is "GIF"
And resource ID is 504. But i am unable to find the resource.
But when i try this
Where i have also stored an BITMAP file, and tried find the resource . i
have succeded in th...