RPC over HTTP/S on Exchange 2003
I have been configuring my single server with exchange to use RPC over
I have followed the instructions in MS guide and another simplified
Server spec is: Server 2003 standard SP1, Exchange 2003 SP1, XP client
SP2 with outlook 2003 sp2
The bottom line is that when testing from the WAN, the outlook client
will not connect and say that the exchange server is unavailable.
I have a lot of experience configuring rpc over http/s with sbs2003 but
this is the first time for server 2003 standard.
I have outlook ...The Sum from 1 worksheet cell to another worksheet cell
the sum from one cell on sheet1 from another cell on sheet2,how do you do the formula
To sum the value on Sheet1, cell A10 with the cell
value Sheet2, cell B20, enter =Sheet1!A10 + Sheet2!B20
(or you can enter '=' sign and click on A10, then enter
the plus sign and click on B20)
>the sum from one cell on sheet1 from another cell on
sheet2,how do you do the formula
Is it possible to write a criteria where the value of an empty field is "0.00"?
Background: I have three queries with different customer account groups. Not
every salesperson has customer accounts in every accountgroup - so, he will
not shown up in that query. But he has accounts included in another query.
Now, I would like to get a sum of commission earned by each salesman
calculated from all three queries together.
Since the salesman has no record in one query the total sum of that specific
salesman is not shown.
Any idea how to solve that problem?
On Wed, 29 A...Summing in A Query
I have a database which fuel records are stored in. The data is
stored in two tables. The first records the daily logs that operators
use each time they fuel up. It stores their name, the key they used
(keylock fuel system - it's ancient) the unit number of the equipment
using the fuel, and the amount of fuel they took. The second table
stores the month end information retrieved from the key lock print
out. It keeps a running total of the amount of fuel taken with each
key, and the operator using that key.
We have problems making sure all of the fuel is accounted for each
mon...How to create an "and" rule in Query Based Distribution Groups
With Exchange 2003 Query Based Distribution groups, is it possible to create
an "and" rule? ie, all users who are based in "London" "and" have the first
Please reply to news group only. Thank you.
"Curtis Fray" <email@example.com> wrote in message
news:OjVc...Finding all queries which use a table
Does anyone know of a tool that can scan all queries in a database and find
if a certain table is used? I have a table called tblCustomerRollup which is
old and outdated. I want to see which of the 500 queries in my database use
this table without opeing every single one of them?
Sounds like a variation on Search/Replace. Try searching online for
"Database Documenter" as a starting point.
A couple of the commercial tools I've used include FMS, Inc.'s Total Access
Analyzer and Black Moshannon's Speed Ferret. There are a lot of fr...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...Query to hide duplicate records
I recall that this used to easy in previous versions (Unique values
only ??), but in 2007, I can't get this to work at all.
I have a table with our companie's job numbers in it. The job numbers
show up multiple times because of different phases of the project:
3077 Univ. of Vermont/UC/LEED
3077 Univ. of Vermont/University Commons: Building Fee
3077 Univ. of Vermont/University Commons: Excess Professiona...
I need to jut have a single listing of each project number, otherwise, I
get repeated records in the query that looks at this information (which ...Can I abbreviate one value in a data series?
I've got a chart where one value (8,300) greatly exceeds all the others. Is
there a way to abbreviate this value so the other data points show better in
One way is to break the Y axis, have a look at these examples of how to
> I've got a chart where one value (8,300) greatly exceeds all the others. Is
> there a way to abbreviate this value so the other da...Simple Access counting queries
Hi, hoping someone can help a relative newbie with a pretty simple
query. My database (Access 2007) has three tables:
Purchases (many-to-one links to both of the other tables, this is
basically a linking table)
I have two simple queries I'd like to get out of this database, but
I'm a bit stuck on how to construct the SQL. Any direction you can
give me would be helpful.
1. List of all customers who have purchased 2 or more products (or 3
or more products, or 4+, etc.)
2. List of all customers who have purchased both Product A and Product
B (or A, B, and C, or B an...Return values that sum to a known value
I have a list of data and would like to know if there is a formula that would
return any items from that list that sum to a known value.
Have a look at this thread for something similar:
> I have a list of data and would like to know if there is a formula that would
> return any items from that list that sum to a known value.
...Change of field separator
When I open CSV files in Excel all data is put in one column. Can anyone tell
me, where I change my set up, so I get another field separator? Please be
specific, because my Excel is a Danish version, and sometimes I have a hard
time following the English instructions. Thanks!
you specify this in the Windows regional settings. Another idea:
- rename your *.csv file to a *.txt file
- now open it with excel. The Import wizard should appear and should allow
you to specify a different delimiter
> When I open CSV files in Excel all data is put in one co...Zero filling a number field
I have an auto number field that I want to zero fill to six digits but
can't figure out how. Any ideas?
You don''t say where you're trying to do this, but basically
>I have an auto number field that I want to zero fill to six digits but
>can't figure out how. Any ideas?
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
Message posted via AccessMonster.com
You can't do that wi...Annoying problem with lookup field
On a client, I have a MOSS 2007 portal with two lists which are not
wroking as expected. One contains people and the other one contains a
lookup field based on data from the first list. When someone which
hasn't got administrative rights logs in and tries to see the
properties of any element in the second list (on DispForm.aspx), they
can't see the lookup field value, and if they try to edit the element,
the dropdown control used to choose a person from the first list
appears empty. Administrator don't have this problem.
The users having the problem have collaboration rig...Problem with vba code to export query result in excel
I have a access report that exports to excel with click of a button after
choosing parameters. This works well. However I have to modify couple of
fields to utilize formula in the export module. I am not sure how to do this.
I am writing the above code which seems to cause problem. I appreciate any
help to resolve this issue. Thanks.
If lngColumn = 12 Then
xlc.Offset(0, lngColumn).Value = =([UnitPrice]*[OriginalShippedQty])/1000
It seems the fields UnitPrice and OrigianalShippedQty are not being
>I have a acces...Sum Times
I have four fields on a form to show time. I want a seprate "Total" field to
add the time between the first two fields and then add the time between the
second two fields. Like this:
In LunchOut LunchIn Out
6:00am 12:00pm 12:30pm 4:30pm
The first four fields are stored as medium times. Can someone let me know
how to do this?
Message posted via AccessMonster.com
"ladybug via AccessMonster.com&quo...Selecting cell value for a sum, based on a condition
Trying to come up with a formula or method that will enable me to sum values
based on a condition. For example, I have three columns which contain a
condition and two amounts. If the condition is of the 'each' variety, one value
will be used in the sum. If the condition is of the "square foot" variety,
another value will be used. Here is a small diagram that may help visualize
A B C D
1 Measure Unit Cost S.F. Cost Summed Total
2 Each 3.00 .30
3 S.F....How to change the FROM field in email campaign activity?
How to change the FROM field in email campaign activity?
I would like to create an email campaign activity and change the TO
field of the email to be abother name instead of mine
I would also like to add attachments
I can't find a way to do this
Any help is very much appreciated
There are many ways to send marketing emails from CRM:
Quick Campaigns with mail merge using Microsoft Word
E-mail Campaign Activities
E-mail Campaign Activities with mail merge using Microsoft Word
Direct e-mail using templates
Send a workflow e-mail
Integrate...How do I make X-values of a chart dependent on values in cells?
I have a chart which can go from x-value 0 to x-value 200. However
I'd like to be able to input min X-value into a cell, and a max X-valu
into a cell, and the x-value in the chart changes to reflect that.
Is it possible to do that?
Thanks for any replies.
Message posted from http://www.ExcelForum.com
There is no automatic way to do this but take a look a Tushar's
AutoChart Manager for a possible solution.
Kashgarinn < wrote:
> I have a chart which can go from x-value 0 to x-value 200...Difficult query
I have a table called WT,contains the fields "Type of call","DateW" and
"ID", this table is used to by users to add rows that determine type of calls
received in a call center,I want to create a query with the following
1- To view number of calls received in each type per day.
2- To show the field "Type of call" in this query,even the type that wa not
used,and to view number 0 in the count field.
3-Prcentage of each type of call .
On Dec 11, 3:52 pm, Pietro <Pie...@discussions.microsoft.com> wrote:
> I have a tabl...Report Query in RMS
Is there somewhere that I could get some information as to how the reports
in RMS are composed.
When you look at the various reports they all seem fairly simple in there
Are the any examples of how these reports are composed. The //---
Columns ---// iformation seems to be the same in most reports, same as the
//--- Title Rows ---//.
Setting up the flitters and the TablesQueried I need to understand.
I have the schema for 1.2.
How do I better understand the following or what do I need to learn. I wish
I was in college again and had all the time in the world.
//--- Repo...Help Please in Summing
Sorry to ask such a simple question, but I need help on
how to get a total of some cells.
Here's the sample.
A1 is 05 and is true
A3 is 10 and is true
A5 is 15 and is False
A7 is 10 and is True
A9 is 05 and is False
How can I make A11 show me the result by just adding those
numbers that are TRUE and give me the sum ?
Would really like help, thank you.
I assume that you have TRUE or FALSE as boolean in an adjacent cell.
But the assumption may be wrong and you'll need to provide more
Regard...set value of a group of activex control points
Have a spreadsheet that has some 20+ activex control points (option buttons).
Is there a way to group all these controls together & set their initial
values the same? Trying to setup a "reset" type of operation that would clear
all control points. I can do them individually via properties, but it's too
...pvt table field settings!
i am receiving data every day from 10 different places as under.!
TOTAL NUMBER OF RECEIPTS 10
TOTAL OF RECEIPTS AMOUNT 1000
TOTAL NUMBER OF RECEIPTS 50
TOTAL OF RECEIPTS AMOUNT 1500
TOTAL NUMBER OF RECEIPTS 15
TOTAL OF RECEIPTS AMOUNT 1000
TOTAL NUMBER OF RECEIPTS 10
TOTAL OF RECEIPTS AMOUNT 1000
-likewise i'm receiving daily data from all the 10 places..!
what i want is a pivot table report on a...Storing distinct values in an array
in the speadsheet, i have a column containing a series of numbers
maybe of them repeated multiple times...
i would like to store all distinct values in an array
any ideas on how i could do that ...
eg , if these were the numbers going down column then 1 3 5 7 5 3 5 7
5 4 3 4 5 7 8 5 3 .. store 1,3,5,7,9,4,8 in an array, in no specifi
shimeel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1583
View this thread: http://www.excelforum.com/showt...