Adding lots of new products quickly
At the moment adding simple products (name, alias and price) is quite slow as
each bit of information is in a different tab.
Is there any way that I can add products in a spreadsheet, worksheet or
excel/text file mode? All I'd like is a name, lookup, and price columns. This
would make adding new products 10 times faster and easier.
Contact your RMS Partner and ask for the QSImport tool. If they don't know
what you are talking about then you bought from the wrong company. If they
can't give it to you post back.
> At the moment add...Excel 2007 Bug? Conditional Formatting
My client has the following situation:
A1 = 5%
A2 = $3.00
A3 = (a list option to determine if they want to use the % or the $)
On Sheet2 the formulas use the value of A3 in an if condition to apply
either A1 or A2 to calcuations.
This all works fine.
On Sheet2 they have a cell that simply reports the A1 or A2 value
being used in the calculations. The conditional formatting I wrote
compares the value in that cell to the original A1/A2 cells and sets
the formatting to either currency or % as appropriate.
At first blush it seems to work but as I change the selected item in
A3 and fli...Project Accounting
1. create an U of M with 2 level of measurement (eg: DOZEN=12 PC)
2. create an Item (eg: itemX) with U of M, assign above U of M
3. create a project with project type=FIXED PRICE
4. enter itemX as a buget item of this project, enter 2 lines, one for PC
and one for DOZEN
5. Enter a project inventory transfer for this project, cost category and item
6. after specifying/selecting the U of M (either PC or DOZEN), message pop
you can change the U of M of Fixed Price/Cost Price project type
is this a limitation or bug? any work-around?
...Hidden ActiveX gets focus
i have a MFC CDialog that contains several controls and ActiveX'es.
Depending on the configuration of the dialog, I have to hide an ActiveX (I
tried different ways like ::ShowWindow(...) or ::SetWindowPos(...) etc. to do
that). The ActiveX gets hidden as it should.
Let's say, I have the following tab order:
Edit1 (ActiveX) - Edit2 (ActiveX, hidden) - Button - Edit3 (ActiveX, hidden)
I jump from control to control by pressing the tab-key. What I expect is
that the focus jumps from Edit1 to Button and back to Edit1 and so on. But....
What really happens is that:
- Edit1 is foc...Reduce balance
How can i get the cell with my balance owed to subtract what payment I made
on the next cell?
let's say your balance owed is 100, and your payment was in cell B1, then you
would enter =100-A1 in the cell
If you tell us more about what you are trying to do, there are probably much
better ways to do this calculation.
> How can i get the cell with my balance owed to subtract what payment I made
> on the next cell?
You subtract. If balance is in D2, and payment in C3, then new balance is:
...I have a product key for SBE that allows me to install on Server 2
Microsoft gave me a new product key so that I could install the small
business edition of the crm on to server 2003. The number of licensed users
is still 10. So is there any reason I can't have both the crm and server
2003 on the same server? I know that if I was installing the professional ed
of the crm, microsoft does not recommend housing both the crm and server 2003
on the same server.
...Bugs in LONG_PTR usage in VS2005 header files
Just in case you encounter these, they appear to be actual bugs. The warnings should not
be issued. I'm using VS2005/SP1/Vista and compiling for Win32.
line 43: ::SetWindowLongPtr(hWnd, GWLP_WNDPROC, (LONG_PTR)func);
warning C4244: 'argument' : conversion from 'LONG_PTR' to 'LONG', possible loss of data
static LRESULT CALLBACK SubclassHandler(HWND, UINT, WPARAM, LPARAM);
line 289 ::SetWindowLongPtr(hW...Reduce fan speed
sounds like my pc is ready for take off.... The fan gives 3 sounds: Loud,
louder, loudest and alternate on their own. Is there any way to reduce the
fan speed or is there some program that is constantly running?
"Gary" <Gary@discussions.microsoft.com> wrote in message =
> sounds like my pc is ready for take off.... The fan gives 3 sounds: =
> louder, loudest and alternate on their own. Is there any way to reduce =
> fan speed or is there some program that is constantly running?
I ...Reduce excel file size
Is there any way to reduce the excel file size?
I' am using a calculation sheet, which I customize everytime for a different
It looks like the file somehow retains a hidden record of all file changes
and the file grows over time. At this moment the file is roughly 9Mb!
I removed all the names which I don't use anymore plus all the macros. It
does help a bit but not enough. The weird thing is that if I start of a
clean spreadsheet, and copy the formulas from the old to the new one. The
new one is just a few 100kb.
Any ideas, how to get rid of some of that "MS Intelligenc...Setting Discounts for Individual Products?
I'm confused as ever - I'm looking at the Settings-
>Product Catalog->Discounts List section, and completely
understand how to create a discount, etc.
But how do I apply a specific discount to a specific
For example, I want Discount A to apply to Product B, and
Discount B to apply to Product C, but have no discount
for Product A...
NM - found it in price lists. Although I must admit, the
entire product structure for the CRM seems rather
confusing... Anyone else?
>I'm confused as ever - I'm looking at ...Add Multiple Manufacturers to Product Catalog
I'm setting up CRM 3.0 for a company that acts as a broker or middleman for
many manufacturers. In most cases they create quotes which contain products
from 4 - 6 manufacturers. How do you suggest the product catalog be created
so we can create quotes and track sales history?
> I'm setting up CRM 3.0 for a company that acts as a broker or middleman for
> many manufacturers. In most cases they create quotes which contain products
> from 4 - 6 manufacturers. How do you suggest the product catalog be created
> so w...BUG? CFile::GetStatus fails if the file is on a CD
There is a message box: "The parameter is invalid."
This problem occurs with MSDEV.NET 2003...
e.g. (E: is a CD-ROM drive)
There is an exception in the CTime constructor because
there is no access time for a file on a CD (I guess).
Is there a simple workaround?
I stepped through the VS6 CFile::GetStatus() code and it handles this
scenario fine. If the access time is 0, it simply uses the modified time
"Steph17x" <firstname.lastname@example.org> wrote in message
news:0ac101c3674b$a...Windows 7 bug with ID3 v2.3 interpreter
There seems to be a bug in the Windows 7 ID3v2.3 interpreter that occurs for
all ID3v2.3 tags of more than 10 Mbytes.
When encountering such files, windows 7 explorer hangs for minutes on the
files. The delay times of the explorer increases with the ID3 tag size.
This can affect files with uncompressed album arts or mp3HD files, which
have large id3 tags.
Can anyone at Microsoft look at this?
On Wed, 2 Dec 2009 10:11:01 -0800, fairmetoo
>There seems to be a bug in the Windows 7 ID3v2.3 interpreter that occu...bug in selection CListCtrl vc 6 sp6
i just spottet 2 strange things that i couldnt find already discussed
and want to know if someone had the same experiences...
first is: when i give a ListView (what, btw is the difference between
a -view and a -ctrl?) the LVS_SHOWSELALWAYS-flag-check in the dialog
editor, i cant get rid of that flag via editor (i have to manually
load the *.rc-file and remove LVS_SHOWSELALWAYS by hand)
seconds is: after specifying LVS_SHOWSELALWAYS *all* items are
selected (in NMLVCUSTOMDRAW.nmcd.uItemState bit 0x01 is allways set)
anyone spotted this before?
...Major startup issue
I have had my vista home premium system for a little over a year with no real
issues. The other day I did a system restart . The manufactures logo which
normally comes up for about 20 seconds before moving on to the microsoft
welcome screen stayed on for at least 5 minutes and then the screen went
black for a couple of minutes. Then a short blinking cursor with a message
that "Bios not installed!", then black for several minutes and then a message
that the pc could not start and I was prompted to select an option for
automatic repair. I did so and after about 10 min...XP product key on netbook label almost unreadable
I am about to reset an XP netbook back to factory settings. Unfortunately
the license key printed on the label on the base has two or three of letters
that are not very clear.
I ran the Jelly key finder and found the key in the registry. Unfortunately
it does not match the key on the label which leads me to believe that it is
the manufacturer's 'multiple machine' XP key.
Can I use this to re-install XP on this netbook?
If not what happens if I can't correctly guess the missing letters on the
: I ran the Jelly key finder and found th...self-register problem (linker bug?)
When I create my DLL then I get the following error message:
1> Creating library D:\Project\xxxx\Release Unicode\PROJ.lib and object
1>Project : error PRJ0050: Failed to register output. Please ensure you have
the appropriate permissions to modify the registry.
1>Build log was saved at "file://d:\Project\xxxx\Release
1>PROJ - 1 error(s), 0 warning(s)
Trying to register it by myself with regsvr32 results in:
DllRegisterServer in proj.dl...Reduce excel file size #2
I have an excel file that is 671KB in size. It should be no more than 70KB.
Can you tell me how to find out what is causing the enlargement. Please help
because I need to have about 11 - 15 of these sheets in one work book. And
at this size (671KB) it will be around 10MB when completed. I am willing to
send one of the sheets to anyone who would try to determine what is causing
Do you have any macros in the file? Somestimes when you have macros in the
file the file size can growth rapidly.
"Bobby Atkinson&qu...Bug in Excel 2007
Simply when you try to multiply 850 by 77.1 excel display the result to be
"Molham Serry" <email@example.com> wrote in message
> Simply when you try to multiply 850 by 77.1 excel display the result to be
> 100000 !!!
Wow! How did you find this major bug?
Even Sumproduct returned 100000.
(2*0.5 = 1)
This seems Major to me!
Windo...Top 10 articles by Product
How do we set up the KB to assoicate articles to Products?
I see clearly how this is done for subjects. And we are using subjects kind
of like call types on the case form and this is working well. But I want to
be able to associate KB articles to products without having to create a
subject for each product.
Hi Heather, the products in consideration are the "Case Products". So if you
associate a product with a case AND a KB with the same case, "Top 10
articles by Product" would be able to find the top 10 KB articles related to
the selected product in all your ca...Bug in XslTransform within .NET framework 1.1
While parsing xpath expressions within an XSLT document the .NET
XslTransform class seems to delete the first "/" after a "]" within an
expression containing a "|". This problem can be demonstrated by the
following short C# program. The program throws an exception saying
that "ac" is an invalid XPath expression.
static void Main(string args)
string inputXml="<a>&...How can I track batch numbers of products sold?
I need to track batch numbers of products sold and had expected to simply add
a one-to-many custom entity under the order product entity.
However it seems that you cannot create relationships between Order Product
and - well - anything!
Is this a system limitation, and can anyone suggest a workaround? Thanks!
On Apr 18, 10:50 pm, BillB <B...@discussions.microsoft.com> wrote:
> I need to track batch numbers of products sold and had expected to simply add
> a one-to-many custom entity under the order product entity.
> However it seems that you cannot create relationshi...update to outlook2003 lost everything
Now I know I am not that bright but I thought when you up
grade a product it gets better. upgraded to office 2003
to be able to access som new files. well now the
oldones dont work in access and for outlook lost all my
mail and address book. Any ideas where the old address
book would be.
Upgraded from which version? All Outlook data is contained in a pst-file. If
you didn't store your addresses in the Contacts folder you must also search
Tips of the month:
-Create an Office XP CD slipstreamed with Ser...Outlook bug?
I change my column headings and rows fonts to Verdana size 9. I notice if I
leave my Outlook open for 24 hours it changes my font automatically to a
smaller font. Is this normal or is this a bug? I've noticed this with
Outlook 2000 and 2003.
Could it be Automatic Formatting that has been doing this to all of my
messages? Like after a certain time they turn a different font due to some
"Nocturnal" <firstname.lastname@example.org> wrote in message
news:eSRVRVyh...How to Reduce file size in excel 2000?
my excel file is growing bigger each time i'm working with it, is it
possible to clean it?
hope someone can help!
Tanks a lot
> my excel file is growing bigger each time i'm working with it, is it
> possible to clean it?
> hope someone can help!
> Tanks a lot