products and price list items to be user owned
In CRM3.0 if you have access to products you have access to all price list
items in the product catalogue.
This presents a problem with large organizations where we see the
requriement for the salespeople to only see the price list items for their
business unit and the price list items visibiliy accross organization is a
Product and price list items need to be user owned (or there need to be a
way to switch over from the organization owned to user owned setting).
This post is a suggestion for Microsoft, and Microsoft responds to the
suggesti...Total column in Query 03-16-10
I have a table with ID, Description, Intake, Sold, Remaining, Intake Date, &
I would like to have the Total Inventory column populate with a total from
remaining column based on the description.
For example: At the beginning of February I took in a total of 5 warmers.
During the month of February I sold 4 of those warmers. Leaving a remaining
total for February of 1.
At the beginning of March I took in 5 more warmers.. for a total inventory of
6... if I sold 3 in March I would like the Total inventory to show 3 at the
end of March....
Am I making myself c...Deselecting all ListBox-Items
When you create a Listbox, it has initially 0 selected items.
After selecting an item, is there any way to get it back to 0 selected
As a coder, that easy "SetCurSel(-1)"...
But how to do it as user?
".rhavin grobert" <email@example.com> wrote in message
> When you create a Listbox, it has initially 0 selected items.
> After selecting an item, is there any way to get it back to 0 selected
> As a coder, that easy "SetCurSel(-1)"...
> But how to do it as user...X axis in column chart
When I create a column chart, on the x-axis I have dates (30-Sep-04,
30-Sep-05 and 30-Sep-06) that repeat. (It's a double x axis where I have
different office codes and the dates are shown for each office). When I
first create it, the dates display nicely in a vertical orientation.
However, when I add in the data table, it turns the dates all horizontal and
cuts them off (all I see then is the 30-S). Any help on how to fix this?
Data tables can mess up your chart. If there's little enough data to make a
data table legible, you have to ask yourself whether you even ...Mail Messages HTML Viewing
I am using win XP and Office 2002. When I receive
messages with html format i can only see the url's and
not the pictures. I have checked all the settings, I
have the box in options/mail format/internet
settings/html format checked to receive pictures and
still just the url. I runn norton and zone alarm but
can't see any settings in these that would restrict the
downloading of pictures. Any thoughts?
What are your IE settings?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to the
Swen virus, all e-mails sent to my actual...Sent Item not Showing Up
I'm at an office Running Office 97 and Outlook 2000.
When they send at attached file from the Application, not
Outlook, using Send To - Mail Recipient the message does
not show up in the Sent Items bin of Outlook.
There is apparently no record of it at all within my
system although, obviously, the reciever knows it was sent.
Is this an Office 97 problem? An Outlook 2000 problem? An
interface problem or just this office's implementation.
Thanks for any help.
...the webpage you are viewing is trying to close the window
We have an internal web interface for our helpdesk system. When we finish
working with a "call" it attempts to unlock the call and we get the message
as above. More often than not, we need to say YES to the message. Any ideas
how to get it to not appear?
Which security zone does the page/popup load into?
Hint: Is IE configured to automatically detect sites in the Intranet zone?
What 'call' software are you using? Have you attempted to contact the
"Keithmeister" <Keithmeister@discussions.microsoft.co...refer to same row in other columns by using entire column in formula
I have lots of columns of data which I want to do calculations on,
and i always want to consider the same row only.
I would like to use names in the formulas to make it easier to keep
track of which columns are being used. So it's not as if I have
a problem at the moment, just that it could be easier to follow if
i used named ranges.
Now, I noticed a 'feature' of excel and was wondering
if it is safe to use. Here it is:
Column A has, say, row numbers in it, so A1 has a 1, A2 a 2, etc.
If in cell B1 I type: '=A:A', the result is 1.
Below is cell th...Item has already been added. Key in dictionary:"winbootdir" Key being added: "winbootdir"
When I create a instance of web services proxy in winform, I get the
System.ArgumentException: Item has already been added. Key in
dictionary:"winbootdir" Key being added: "winbootdir"
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean
at System.Collections.Hashtable.Add(Object key, Object value)
at System.Collections.Specialized.StringDictionary.Add(String key, String
at System.CodeDom.Compiler.Executor.ExecWaitWithCapture(IntPtr userToken,
String cmd, String currentDir, TempFileCollection tempFiles,...Using custom document peroperties to creat views in Public Folders
How do I use custom document properties to create views in public folders? I
came across an article for Outlook 2000. I tried doing this for Outlook 2007
but I am unable to. Please assist.
The article I came across was
http://office.microsoft.com/en-us/publisher/HA010549541033.aspx However this
only appears to work for 2000 not 2007. Hopefully someone can help.
> How do I use custom document properties to create views in public folders? I
> came across an article for Outlook 2000. I tried doing this for Outlook 2007
> but I am unable t...m_pDocument Doc/View unique id for each view
I'm using the standard mfc mainform with a doc/view. While I'm in the
view portion I need to track the actions taken individually and
separately for each view. So when when I click on view one I track
that in a separate place than view two.
I there a unique id or index for each view? Something like
<firstname.lastname@example.org> wrote in message
> I'm using the standard mfc mainform with a doc/view. While I'm in the
> view portion I need to track the actions taken...insert 'x' number of rows in excel
I'm looking to insert 'x' no. of rows into an excel document where 'x' is
the result of a 'countA' function.
Is this possible?
only possible with VBA. Would this be feasible for you?
>I'm looking to insert 'x' no. of rows into an excel
document where 'x' is
>the result of a 'countA' function.
>Is this possible?
Yes VBA is feasible
"Frank Kabel" wrote:
> only possible with VBA. Would this be feasible for you?
> >-----Original ...View Webpage
How can i view a HTML page in Excel, it should also be automatically update
in 60 seconds. Is this possible?
Please note that, that page contains images
That webpage is on our intranet website.
Though I am not certain this is exactly what you are looking for, try the
Data, Import External Data, then New Web Query...
In the dialog box that appears, browse the site. You will notice that at
certain areas of the page you will see an arrow. Just click the ones that
you want to import. Click import. Select the cell you want to import the
data into and click OK.
Hope...Forms in two differant views
Is there a way to use the same sub form showing two differant views within
the same Main Form. For example: Can I show on one tab a datasheet view and
on the other a regular form view.
Create a button on your form and under the "OnClick" event put
'Me.DefaultView = Datasheet
Alternatively you could use a checkbox
If me.checkbox1 = 0 then
Me.DefaultView = 2 ' Datasheet
Me.DefaultView = 0 'Single Form
This should flick the form between datasheet and form views.
> Is there a way to use t...Column Header that moves with Data?
Does anyone know if it is possible, and if so how to have a colum
header move with the data?
I have a sheet with a ton of data and the list is growing, I would lik
to see the column header "float" with the list instead of having t
scroll to the top and check it out.
thanks for all help
Message posted from http://www.ExcelForum.com
if i'm understanding correctly -
click in cell A2 and choose windows / freeze panes
to undo it choose window / unfreeze panes
"wendellarina >" <<email@example.com> wrote in
mess...Forcing a view to be the active view
I have an SDI application that has a splitter window with two views. The
first view is an CFormView and the second is a CView. I want the CFormView
to always be the Active view. Even if the user selects the CView.
How do I accomplish this?
Anders Eriksson wrote:
> I have an SDI application that has a splitter window with two views. The
> first view is an CFormView and the second is a CView. I want the CFormView
> to always be the Active view. Even if the user selects the CView.
> How do I accomplish this?
> // Anders
I'd ...OL98 start up view
I recently had to reinstall my WInXP and now my OL98 has a couple of
issues I'd like to fix.
I've set up my mail account (with POP3 and SMTP servers) but when I
try to use it I get a message saying that internet mail is not
registered properly. What do I need to do to fix this?
Also, I used to start up OL98 so that the first view was not Outlook
Today. How do I change that?
I guess I can't remember how to do things that I only do once every
Thanks for any suggestions!
You might want to have a look at this MS KB ...Changing View -- All Folders
Using Outlook 2007, Windows XP Pro. I have dozens of mail folders in
Outllook. I would like to change the view (to the right of the folder
tree) on all folders. There seems to be no apparent way to do this.
Any ideas? Thanks,
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EAS...How do I make the X-Axis increase in scale with the quantity?
For example: If I have the values 1.5, 3.5, 8.7, 9.9 in the x values for a
line graph, is there anyway to make them spaced apart so that they are in
scale with eachother... Like so the distance between 3.5 and 8.7 is larger
than, the distance between 1.5 and 3.5?
Create a XY Scatter chart. It, and a bubble chart, are the only 2 that
allow for cardinals values on the x axis.
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <F2D3DC58-86D3-4D21-9D57-F704A78941FB@microsoft.com>, =?Utf-
8...item quantity discount not found
I have an issue I hope someone can help me with. I had created a mix/match
discount scheme for a group of items that I was overstocked with. Now that
the items are at the levels I wanted them to be I didn't want them
discounted anymore. Since you can't remove a bunch of items from discount at
once I decided to delete the discount scheme. It seemed to work OK because
when I looked into the item properties discount tab everything had no
discount selected. However, when we sell one of these items it comes up with
"warning 907 - the item quantity discount was not found in the d...Coustom view
I have been given a new work station and for some reason my custom view is
not highlighted and is not working.
I don't think it is as add-in feature. Excel heip has not been of any (help).
Does someone know how to enable this feature?
Custom Views will be disabled if you have more than one sheet selected.
Do you see [group] behind the filename on title bar?
If so, right-click on a tab and "ungroup sheets".
Gord Dibben MS Excel MVP
On Wed, 11 Jan 2006 06:28:03 -0800, "Michael"
Recently my boss was having problems with Outlook 2003 Reminders not
working properly and after some digging I had found some mention that
reminders may not work on items in sub folders, though I can't seem to
find anything Official from Microsoft that documents this fact. Can
anyone point me to an official Microsoft statement for this fact so I
have some grounds on recommending a 3rd party solution, otherwise I
will be expected to solve the problem myself without the 3rd party add-
in.. and I'm guessing this will be near impossible.
reminders only fire on default folders in outlo...Calendar View?
Outlook 2000. This seems like a dumb question but in the monthly calendar
view how do I get it to show a regular standard Sun-Sat week with equal
weight for each day (Sat & Sun the same size boxes as the rest of the
right click on the calendar and choose Other settings. Uncheck the option to
compress weekend days.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.ne...Rename the a column title
I want to rename the title of the "Task Name" column. I looked in the
help and the provided solution was that I have to hide the column, then
insert it again, and in the "Column definition" dialog box enter the
desired title in the Title field. This works, however I noticed
something funny. In the Field name list of the Column definition dialog
box there is no "Task name" column, but only "Name". As the latter
contains the same information as the first one this is not a big deal,
but what should I do if I want to insert the same old &q...Modifying Activities associated view 10-01-04
I have tried the unsuported fix involving:
The view opens fine but I am unable to save as is or make
changes... I get the message "the Item Id is invalid."
Make sure you include the braces around the view ID GUID.
"Sean T." <firstname.lastname@example.org> wrote in message
> I have tried the unsuported fix inv...