How can I write a formula to sum only the level 1 costs on my BOM if i have
multiple level 1?
...PS2007: My Tasks View
We are new at implementing MS Project 2007 Server. Within the desktop
application, we are using a simple project update plan (Actual Start,
Actual Duration, Remaining Duration, Actual Finish). I would like to
setup the My Tasks view on the server to allow similar updates. I can
add these fields and they are visible in the view but it does not
allow me to edit the Actual or Remaining Durations. Is there
something I need to change in the configuration to allow these fields
to be "editable" in the My Tasks view? If I use Actual Work and
Remaining Work, those I can change bu...Hooking/editing the caption of a dialog
I asked a couple days ago about ascertaining if a file was read-only
and got good help. Thanks to the responders.
If a file is a read-only file, I would like to communicate that to the
user of the dialog MFC app. My preference would be to get ahold of the
caption of the dialog that is being executed and append "Read only" to
the string. That's what Microsoft Word does - at least something like
When I create the dialog, I right click on it and select "Properties."
Then the string that I enter is put in a resource file.
Any ideas how to get ahold of that caption...using only partial of dropdown list
I have a named range of cells (called xcodes) in a single column that
is in the following format:
D123 - Department Text Description Here.
All entries have 4 characters proceeded with a description just as
above. The 4 characters are also unique.
What I would like to do is display the entire string but only the
leftmost 4 characters would be accepted as the value for that cell the
data validation is applied.
I have tried using the formula within data validation as:
=Left(range("xcodes"),4) but that returns an error. Any ideas how to
accomplish this? (Excel 2003 version).
On Apr 17...How to include new columns in list view Customisation
I wonder whether there is a way to include new columns in the list view
beyond the set of fields offered out of the box. For instance I am keen on
getting the Customer Prioirty field from cards to come on the Advanced
Distribution Transactions list view under the sales order teansactions on
I don't see a way to add Customer Priority in the Sales list views, but you
can definitely add in to the Sales Transactions SmartList. Not sure if that
helps in this particular case, as you may not be able to duplicate all the
filters from the Advanced Distribution Tr...Dropdown list question
How do I choose more than 1 value from a dropdown list? Is this possible?
For example if a, b, c etc are in the dropdown list, how do I choose a and
b so that the cell value will be a b?
You can only do this if you have ab as one of your entries in the list e.g.
> How do I choose more than 1 value from a dropdown list? Is this possible?
> For example if a, b, c etc are in the dropdown list, how do I choose a and
> b so that the cell value will be a b?
You can do this with programming. There&...BOM cost if mfg BOM entry window
I have GP 8 with manufacturing, in the BOM entry window a BOM cost is
I am using Average perpetual valuation method.
Can anyone tell me how this BOM cost is calculated? When I click the
calculator , nothing happens.
The BOM cost does not equal the sum of all the components.
Thanks in advance!
By the way, I am using multi level BOMs, and I need to know how the phantom
items fit into the calculation.
"Sheri Salomone" wrote:
> I have GP 8 with manufacturing, in the BOM entry window a BOM cost is
...Clearing List Boxes
I am working on a project in which one list box will populate the nex
through vlookups. The only problem is that if you change one of th
boxes previous to another it does not clear them therefore they contai
false values. Any ideas on how to make the boxes clear when selectin
any of the previous boxes
Kevin Willhoit's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2441
View this thread: http://www.excelforum.com/showthread.php?threadid=38012
I don't know! But I can...Keeping a table in a form editable and checking that fields are filled in before allowing a save
Firstly apologies if this is the incorrect forum but I was looking for
a general word forum and could not find one. Please point me to one if
I am trying to create a form where I want to specify what items need
to be filled in. (Review minutes from design reviews). I want to make
certain fields mandatory like the date, attendees and check list used
and want to block saving of the document with a warning until they are
filled in. Is there a way of doing this?
Also as a part of the review actions are filled in to a table.
depending on how many actions there are the table...Printing problem
This may also relate to scrolling. An Edit control under Win9x/Me can only
hold 65535 characters of text, whereas one under W2K/XP can hold over 2
billion. That has caused me a problem.
I've had users to try to drop more text into my Edit control (in an
EditView) than will fit in it. I worked around that by checking the length
of the incoming text against the buffer, removing lines at the top of the
buffer if needed to provide space, then putting the incoming text into the
control at the bottom. That worked, but I lose the text that is taken out of
The problem I have is that ...Access 2007 Runtime Bug
I have a combo control and have specified a "List items edit form". The edit
button appears fine when running a full version of Access 2007, but does not
appear when I distribute this to clients using the runtime version.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Ag...BOM Query for multi-level BOMs
We've been trying to use the Basic BOM With Standard Cost report to get the
details needed to set standard costs on some of our finished goods. The BOMs
are several layers deep with some sub-assemblies set as Regular BOMs and some
set as Phantoms. The primary temp table used by the report doesn't provide
this information (whether the sub BOM is regular or phantom). I've tried
adding the BOM Line table but have not come up with a join that gets around
what the primary temp table shows.
So, is it possible to create a view/query that can essentially recreate an
exploded BO...Edit View Problem
My form called "Jobs" has a Combo box that shows me my client list (from my
table "Clients"), I choose which client this job is for. The Client ID (PR)
is stored in my "Jobs" table but not the Client Name. When I open my "Jobs"
form in add view I see the Client Name but in "Edit" view I see just the ID.
I need to see the client Name instead. how do I do this. Thanks for your
help, in advance.
Added info, sorry. I use 2 forms based from the same table "Jobs". When I add
jobs I use my form "New Jobs" and when I edit ...Incorrect Balance Amount on Account List Page
The account list page shows the balance of one of my credit card's
incorrectly. If however, I click on the credit card account, it shows the
correct amount owed. Also, if I sort by unreconciled transactions, it shows
the incorrect amount listed on the account list page. I tried reconciling all
of these charges but still get the incorrect amount. Has anyone seen this
In microsoft.public.money, James wrote:
>The account list page shows the balance of one of my credit card's
>incorrectly. If however, I click on the credit card account, it shows the
>correct amoun...Forms, Fields, and Restricted Editing
[This post applies, at least, to Wd2007 and Wd2010.]
If I use the content controls under the developer toolbar, I can
restrict editing (also under the developer toolbar) so the user can
just tab through the places he/she needs to enter information. On a
different model, I can insert ASK fields and REF fields so that the
user enters information in response to prompts, and the info becomes
replicated at various places throughout the document. But it does not
appear that I can restrict editing *and* use ASK and REF fields in an
online form. So here's my problem: is it possible--...how do i make square bullets for a check off list.
Format - Bullets and numbering
MVP Microsoft [Publisher]
"howard" <firstname.lastname@example.org> wrote in message
...Pricing updates for a Manufactured BOM?
A new GP 10.0 Manufacturing client of ours says that it would be nice if
there were a utility in GP that updates the pricing of a bill of materials
based on price changes of a component in that bill of material.
Is there such a thing in GP Manufacturing? I know that GP Inventory has the
Price List Wizard but that does not work for the client because (a) the Price
List Wizard does not update a bill of material based on component price
change and (b) the client would like to change the price based on the profit
Aside from that question, is there even a utility av...Edit a word in many publisher files
> I need to change one word in a few hundred documents in Publisher.
> I can:
> open each file>Ctrl'M'>highlight and paste the text> save and open the
> This is very lengthy, surely somone will have some software to do bulk
> changes to a large numbr of files.Pleasehelp me if you can
...Edit my VBA code please?
I was wondering if there's a way to make this code for the workbook itself
not the worksheet.
The code worked perfectly on the worksheet, but when I tried to copy it into
the workbook VBA, and change the word "Worksheet" into "Workbook," it didn't
From: Private Sub Worksheet_Change(ByVal Target As Range)
Into: Private Sub Workbook_Change(ByVal Target As Range)
The workbook I'm working on contains about 30 worksheets and having the VBA
code copied onto each worksheet has considerably slowed down the file.
I was thinking that it ...Making changes in a drop down list
I have edited the Accounts form to reflect different payment terms/options. I
have saved the form, but the change does not appear when I go to fill out a
new account. I have checked the XML of the form and the changes are there but
never appear. What am I missing?
Publish your changes with CRM Deployment Manager (Root - Right Click -
Tasks - Publish ) Then restart IIS.
...Omit BOM in XMLDocument.save
How do I get the following code to not put the Unicode BOM in the file. If
the attribute ecoding=UTF-8 exists, it will put the BOM in the file.
objXMLDocument = New XmlDocument
'change the xml file
If you are persisting as UTF-8, then of course you will have the byte order
mark. Could you explain what the problem is with it?
One thing you could do is use an encoding like ISO-8859-1 if you don't want
&qu...PS2007 Risk list as a list template
An over zealous PS 2007 Administrator has changed the Owner column type in
the Risk and Issue logs. Having lived with the PS Queue errors for several
months (during which time lots of Project Workspaces have been created), they
now want to resolve the error. It's not as simple as resetting the 'type' to
'Person or Group' (sadly) as there seems no way to do this in the 'Settings'
page. I have created a list template from the supplied Microsoft Project
Workspace SharePoint template with a view to replacing the defective lists
and, whilst I can now cre...member initialization list
I'm trying to initialize a member (defined in a class) while constructor is
running but compiler complains for
Can you advise me on this please? how can I assing the Num to m_Num ?
CChild::CChild( int Num, CWnd* pParent /*=NULL*/)
: CDialog(CChild::IDD, pParent), m_Num = Num <==== here
// NOTE: the ClassWizard will add member initialization here
Thanks I got it! it should have a syntax as m_Num(Num)
"JSmith" <email@example.com> wrote in message
We are looking at migrating our manufacturing process into great plains by
adding the manufacturing, mrp modules into our existing GP v8.0 SOL 2000
I am just wondering how the BOMS would be imported...can you use integration
Last I looked there was not a manufacturing link from IM. However, there is
a direct to tables link that could be used. DTS might be just as easy.
BTW.....If you start using GP Manufacturing, check out our soon to be
released Manufacturing Cost Accounting book on our web site.
Richard L. Whaley
Author / Consultant / MVP
http://www....Message -- Worksheet xls. is locked for editing. What is this?
I cannot view or change the data in my worksheet because I am getting this
message. Why, and how do I unlock it?
Thanks for your help.
Has someone else got the file open?
Excel stores in Windows\Temp(win98) folder a copy(s) of any file that is open.
Sometimes this *.tmp file is not deleted from the Temp folder when you close
out Excel(maybe a crash of Excel?) or the file, so Excel thinks it is still
open and locked for editing.
You can try a re-boot and see if that clears it up. If not, after a re-boot,
clear out your Windows\Temp folder.
If using WinXP ...