RPC over HTTP setup help. RPC DIag returns no results.
I have been trying for several weeks to get RPC over HTTP workign in our
environment. I refuse to put an ISA in place and am currently behing a Pix
520 ( which is not the issue, all logs show no denied traffic) I also see no
error logs in either of my Exchange servers. Please any help is appreciated.
From my Front end Server I see the followign when running RPCDIAG
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:\Program Files\Windows Resource Kits\Tools>rpcdump /p ncacn_http
Querying Endpoint Mapper Database...
RpcMgmtEpEltInqNext:(Access is denied....Font size in data validation drop down lists
I am using data validation lists to control user inputs to a spread sheet.
How do I change the font size inside the drop down list?
I have tried changing the font size on the sheet itself & changing the font
size on the list page. I can't seem to find a property setting for this
font size. The only way to make it appear larger is to zoom in on the page.
In a data validation dropdown list, you can't change the font size.
There are a couple of programming workarounds here:
> I am using data validation lis...how to force user not to enter "%" sign into a TextBox.
I need to force user not to enter "%" sign into a text box. OnExit
event of text box, which code sould i use, so that I will make the
I can do that by placing ComboBox and defining a criteria on the query
where combobox is bounded. But i want to learn how to do in VBA.
There are lots of information about it on this group but i failed to
> I need to force user not to enter "%" sign into a text box. OnExit
> event of text box, which code sould i use, so that I will make the
> I can do that by pla...Result of crosstab query in form
In Access 2007 I'm trying to display the result of a crosstab query in a
In the Form_Open event I fill the label Caption and text control
ControlSource with the field names from the query. But when I open the form
the text controls display the #Name? error.
Even when I fill the control sources with the correct field names (selected
from the list) I get the message the name is not in the list...
What is the solution?
Thanks in advance,
>In Access 2007 I'm trying to display the result of a crosstab query in a
>...group totals w/criteria?
I'm relatively new to RS and have a challenge I don't know how to overcome.
I have a report where I need to subtract one group total from another. I
read that this isn't possible in 2005, but that 2008 will support
aggregations on aggregations. I'm sure someone has figured out how to do
this in 2005 though, so any words of wisdom?
This is an Accounting report, where I need to get the value for the
Contribution Margin total. The aggregation I'm looking for is this:
Contribution Margin = sum(Revenue) - sum(Expenses)
The challenge is the the...assigning a null value of a date field to a date variable
At some point in the execution of my program I open a dialog box were the
user is supposed to enter some info. Among other things he is asked to enter
a date in a textbox, but this is optional.
When I try to assign this date to a date variable I get the message “Invalid
use of null” in the case the user has not filled in any date. If I use the Nz
function, a value of 0 is assigned to the date and this later shows as
December 30 1899 which I don’t want.
How can I deal with this situation?
Thanks in advance, George
You cannot assign the Null value to a VBA variable of type Date.
...data validation fonts differ in drop down box
I am using Excel 2003. I have a group of cells with a data validation
"list". That list contains 3 options -- check mark, "X", and "box" -- in
Webdings. When you click the drop down box to make a selection the options
are in alpha-numeric characters (Arial font(?)) and not Webdings. So my
"check mark" becomes an "a" and my "X" becomes an "r".
How can I get the drop down box to display the same font as the one in the
Both the drop down box cells and the "list" cells are formatted with the...Trapping Enter key in FormView of SDI -PreTranslateMessage
I Have a Owner Drawn button in a FormView and on clicking on the EnterKey
i need to make that Button to handle some thing and i have used
PreTranslateMessage and can i use PreTranslateMessage in FormView and please
let me know the details
If you want the clicking action to be in button, OnLButtonDown in your
button should work. If you want to handle it in the form,
PreTranslateMessage will work fine.
Ajay Kalra [MVP - VC++]
"Suresh" <firstname.lastname@example.org> wrote in message
I have an MFC application with a TreeView and a CDockablePane
When I select a tree item - I display its properties in the properties
window. That works.
But I don't know how to change the tree item properties when I change
the values in the properties window. My problem is in getting the
values from the properties grid.
I tried to override EndEditItem method like this:
BOOL CMyMFCPropertyGridCtrl::EndEditItem(BOOL bUpdateData)
CMFCPropertyGridProperty* currProperty = GetCurSel();
//I don't like this implementa...How do I display a text message when a cell has a certain value??
I have a cell where if the cell is empty (A1=0), then I would like
cell to display "Enter your value here." Otherwise, I would like the
cell to display the value a person enters.
I have tried using an if/then/else statement and, understandably, I
get a circular reference error:
=IF(A1=0,"Enter your value here",A1)
Does anyone have a suggestion?
Why not just enter the text itself?
The value entered by the user will displace (replace) it.
This should work if the form is a template.
===================================================...Why doesn't what I enter in the function bar appear in the cell?
I have a workbook that contains several copies of a master template
On one of these sheets when I enter text, it appears correctly in the
function bar, but appears as a string of &s in the cell. This has only just
occurred, and as far as I know used to work OK, i.e. it used to appear as
text in the cell.
What could cause this and what do I need to do to put it right?
You wrote that the text appears as apersands (&). Did you really mean
If yes, then try formatting that cell as General--or anything but Text.
Chris Mitchell wrote:
> I...create calendar drop down list in Excel sell
i would like to create calendar drop down list in Excel. Is it possible to
import it or link a sell to a calendar?
"Bo" <Bo@discussions.microsoft.com> schrieb im Newsbeitrag
> i would like to create calendar drop down list in Excel. Is it
> import it or link a sell to a calendar?
...Help exporting the resulting of a sort by Group
I would like to export into excel from MS Project 2007 the result of a sort
by Group value within my project. I have created a custom field called area
for my project and have assigned an 'area' for each task. If I sort by the
group 'area' I get the exact results that I would like to export - the sum of
values (such as work, % work complete, etc) for each of my areas. HOWEVER I
can not seem to export this into excel. I am not able to figure out how to
create a filter that will give me the group by area with the sum totals. Can
you help please - is there a...Reverse the order of values
I am trying to reverse the values in a column of cells
from positive to negative & neg to pos. Excel HELP tells
me to go to the FORMAT menu & click Selected Axis then
click the Scale tab. These options are not listed on the
FORMAT menu. I tried going to the TOOLS menu & selecting
CUSTOMIZE but I can't find where to add Selected Axis &
Scale. Am I in the right place?
Put -1 in an empty cell, copy it, then select the entire set of data and do Edit / paste Special
Negs will turn pos and pos will turn neg, zero unaffected.
...Replace Option Group Value from form with text in report header
Question: How can I convert the numerical option group value from a form to
a string value and place it in the control source of a textbox in a report
I have a form used to 'build' reports: users choose a query, a report, and
then the rest of the controls on the form are used to build a 'where' clause
for the DoCmd.OpenReports statement attached to a command button which opens
the report based on all the user's choices.
I've tried creating a variable on the report in the declarations area and
then using a select case statement in the 'open&...Two identical formulas for a different result?
Hello everyone, :)
A very quick question, but nonetheless very intriguing to me (I jus
lost 4h on that :( )
I don't understand why my first formula works, and the second and thir
(result is #value)
(this one could work too I thought, but result in a 0)
I am simply trying to sum (amount) when the fiscal year is 2003 an
IncomeFeeId is RB......Forms Drop down list
I created a form that works from a table. From the form you can enter
information and it will put it into the table. I would like to create
a field in the form where the user can selects what to be inputed from
a drop downlist. how would I do that?
You need to first create another table which contains the values you want to
list, each as a separate row in the table. If the values to be looked up are
unique, then the 'referenced' table and the 'referencing' table can have the
same column, e.g. a States table could have a State column, and the
referencing table, e.g. a ...Office 97 to 2003: Excel: enter data w/fixed 2 decimal. 2000. be.
When I enter number "2000." I get 20.00 - yes, set decimals at 2 but earlier
excel would accept change if you entered decimal with number. this is
slowing down a budget prep and I'd sure like some help - online and tutorials
say "enter decimal" but this is not working. what am I doing wrong?
Confirmed, until v ersion XP you could finish off with a decimal separator.
This behavior changed with Excel 2003, I haven't seen any documentation on
"Enter decimal" is like
which is just as many keystrokes as
If you d...Do not display Value label if value = zero
I am putting together a pie chart, where values for some slices is 'zero'.
The zero slice is not visible, but the label still appears '0%'. Is there
any way of suppressing this label for the zero slice only (so the other
slices still have value labels appearing) ?
Many thanks for any help
Format label, custom format:
"LFNFan" <LFNFan@discussions.microsoft.com> wrote in message
> I am putting together a pie chart, where values ...Inventory values in HQ
The computer with one of our store databases was stolen (we have 7 stores
total). Our inventory dept. does a monthly audit for each store and at the
end of the month uses a 501 worksheet to upload latest Store inventory
After the theft, I have successfully restored the store database from HQ,
however, are the numbers in HQ the same as the inventory in the store before
the theft? Our Inventory Control Dept. manager doesn't want to trust the
numbers at HQ because he says that since no 501 worksheet was made just
before the theft that he doesn't trust HQ inventory values for the...drop down menu
I want to put a drop down menu (the same menu) in 10 different rows in the
same column. I want the list to say, for example 990 - LWOP. But when
they select, I only want the 990 to be entered in the cell.
Suggestions, please, and thank you.
The following example uses DataValidation and an event macro.
Put the following event macro in the worksheet code area:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Range("A1"), Target) Is Nothing Then Exit Sub
Application.EnableEvents = False
Target.Value = Left(Target.Value, 3)
Application.EnableEvents ...Run macro based on cell value in worksheet
Does anyone know of a way to do run a macro based on a cell value. EG i
cell A1 = 0, dont run macro - otherwise run macro
Message posted from http://www.ExcelForum.com
Does anyone know of a way to do run a macro based on a cell value. EG i
cell A1 = 0, dont run macro - otherwise run macro.
below macro will run your code is cell a1 is anything but 0.
Do you want the macro to run automatically if a different value i
inputted into cell a1, or are you happy for the user to run the macr
manually? (if automatically, more code is required)
sub Macro 1 ()
if cells(1,1) = 0 then exit sub
&...BUG?: Excel scatter chart: will not plot x-values
I am trying to make a simple scatter plot. There are two
columns of data. Excel will not plot values on the x-
axis, only categories. I have entered the ranges for x
and y values correctly, and the chart wizard shows it;
yet, the chart comes out with the x-axis showing only the
points numbered in the order they are entered in the
spreadsheet. Oddly enough, if only one y-value is
included, it plots properly; the x-axis correctly shows
the range of x-values entered, and the single data point
shows up at its proper xy location. as soon as I expand
the y-range to more points, the x-axis r...Drop Ship Sales Order and Purchase Order
I am entering a drop ship sales order and then creating a drop ship purchase
order. The drop ship sales order needs to be invoiced before we receive the
accounts payable invoice. GP doesn't allow that until the ap invoice is
matched. Obviously for cash flow purposes we wouldn't want to wait. I know
we can break the link on the po and so but we really don't want to do that.
We need this corrected.
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&q...Is it possible to change the "result of a formula" to a "number? #2
Is it possible to change the "result of a formula"... to a number?
yes, choose the cell(s) you want to do this to and copy them
then choose edit / paste special - values
this will change the formals to the result.
"Renee R." <Renee R.@discussions.microsoft.com> wrote in message
> Is it possible to change the "result of a formula"... to a number?