difference send as / receive as
I know that if you want under E2K "service account" access to mailboxes you
must give yourself "send as"/ and "receive as" access ". But can anyone
please tell me the whaht is the difference between the two permissions ?
> I know that if you want under E2K "service account" access to mailboxes you
> must give yourself "send as"/ and "receive as" access ". But can anyone
> please tell me the whaht is the difference between the two permissions ?
> Regards Je...Auto Account Number Generation
Here's a newbie question for which I have not yet been able to find a
solution. Whenever creating a new account, I'd like the form to
automatically display an account number in the accountnumber field that is
one more than the max in the table. How can I automtically create this?
That is how can I run a query on form load that looks up the current max
account number then add one to it? ANy help would be appreciated.
Only way to do this is through writing some code. For example you could
achieve this using a callout. When you save a new account you can have the
callout scan ...Differences in various auto-fit options (2007)
Does anyone know why these two autofit mechanisms give different
1. Right-click in table | AutoFit | AutoFit to Contents.
2. Select entire table | Double-click right border.
Right-clicking in a table brings up a list of options. One of them is
Auto-Fit. Selecting Auto-Fit, brings up three options:
AutoFit to Contents (AFTC)
AutoFit to Window (AFTW)
Fixed Column Width (FCW)
AFTW makes the table as wide as possible. I am not sure how it decides
how wide to make each column.
AFTC doesn't seem to work all the time. I have a table with 18 columns
on a le...Counting how many different names in a long list
I have a list of 332 names many of them are duplicated. I am looking for
a formula or function that can count how many unique names there are in
Can anyone help?
Quaisne's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28052
View this thread: http://www.excelforum.com/showthread.php?threadid=501357
This'll count the number of distinct values in a range:
(adjust the range to matc...Exchange server and huge emails generated to postmaster
I have been trying find a solution for a serious problem on exchanger server
2003 (on SBS2003).
Recently probably due to a virus infection a lot emails were being generated
to postmaster (1 million in 10 hours) plus badmail in badmail queue. Have
checked it with norton corporate a/v but can not find any viruses. Also
tried stinger but no viruses found.
Have emptied all the queues. Used microsofts anti-adware program to check
for adware and trojans. It came up clean.
Still getting loads of emails. The only way to stop it is to stop the
exchange information store service, but just dismounting...Serializing Array with array "name" in the XML
I need help serializing an array without including the array "name". I am
writing in C# and using the XmlSerializer to serial classes.
I am trying to serialize a class with an array in it like the one below.
public class myclass
public myimage images;
public string name;
public string path;
It will serialize something like this...
...xml config file...
I ve a Windowsapplication with a configuration file app.config... (it's in
<?xml version="1.0" encoding="utf-8" ?>
<section name = "MyNameValueSection"
<add key="MyKey" value="MyValue" />
<add key="test" value="MeinInhalt" />
</configurati...A problem occur after changing OFFICE from C: to D:
Considering my C:\ is nearly full, I unstall my office from C:\ and then
install my Office to D:\
After this, OFFICE runs well except EXCEL has a warning messege when I open
The problem is:
When I open EXCEL, it jump up an alert messege:
[Unable to find C:\Program Files\Microsoft
1. Can anyone tell me how to solve this problem?
2. If I don't solve this problem, what will be the result?
> The problem is:
> When I open EXCEL, it jump up an alert messege:
> [Unable to find C:\Program Fil...Calculating date difference
I need to calculate the number of years of service for
person(difference between Start_Date & End_Date). The result should b
in terms of years, months and days (all in one single cell). Ca
someone please help?
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
Have a look at Chip's site:
"rll" <firstname.lastname@example.org> wrote in message
&...Render XML data island to HTML?
I have an XML data island in my aspx web page. The XML includes a link
(processing instruction) to an XSL stylesheet. Is there any way on this page
to view the HTML, that results from the xsl transformation, as the contents
of, say, a div? I know I can do it if I display only the XML in IE, but I
don't know if I can do it as a fragment of an existing HTML page.
> I have an XML data island in my aspx web page. The XML includes a link
> (processing instruction) to an XSL stylesheet. Is there any way on this
> to view the HTML, that results from the xsl transformation, a...Corporate or Workgroup, send from different accounts
I have been using Outlook 2000 (CW) in order to attach
history to my contacts in ACT! This has been running
well. The problem I've run into is I used to be able
click on the "Send" button and choose a different email
account to send from, I no longer have that option since I
set up the workgroup settings.
The email account that I can't send from is a Linux
firewall account we use for internal emails...I can
receive emails, but I can't reply or send new messages.
They keep coming back as undeliverable.
Any suggestions/feedback would be greatly appreciated.
...Mapisp32.exe has generated errors and will be shut down
One of my coworkers is getting this error whenever
Outlook97 checks for email. She is running Office97 Pro in
WIndows 2000 on a 600mhz PIII with 128MB RAM.
>One of my coworkers is getting this error whenever
>Outlook97 checks for email. She is running Office97 Pro
>WIndows 2000 on a 600mhz PIII with 128MB RAM.
I almost forgot to mention that I tried the fix listed in
Microsoft Article 296412, with no success.
Here is the URL to that fix.
...Efficiently Generate 88 New Chart Sheets
I've got a simple X*Y chart with year (1977-present) on the x-axis and
an estimate of deer population size on the y-axis (actually, there may
ultimately be 2 estimates/series). There is nothing really all that
fancy about it. It will be updated each year with the current year's
estimate. The problem is, I need 87 more just like it - 1 for each of
the 88 units that I manage.
I have been reading VBA and Excel books and I have yet to find an
example on how to "mass produce" a bunch of chart sheets. I take that
back - a simple "FOR NEXT" loop will generate t...Use Stored Procedure developed in C# in a SQL Query
I created a Stored Procedure by selecting a SQL Server Project in Visual
Studio 2008 using C#. It receives a SqlString as a parameter and return how
many times a specific character was found. I deployed the procedure to a SQL
Server database and can see it listed under the database. One caveat is that
it has a small lock icon on it.
I have a select query where I want to use the stored procedure. I am
thinking this is doable in a select query but can't seem to get it to work.
What I want to do is to have a select statement listing some fields and one
of the fields being th...XML error "Some Data Was Imported As Text"
Daily, I recieve a 3rd party XML file that I parse in Excel (using an excel
macro) and then import into an Access database. Infrequently, the data will
import into Excel, then parse and then the routine stops with the error
message above. I look through the raw XML file and everything appears to be
within the brackets, etc.
Can someone give me some clarification to the meaning of the error message?
Thanks in advance and Mery Christmas and Happy Holidays!
The error message might be generated within your macro - as it is
parsing the data it might detect that some field which should be
...Writing XML from Dataset to Response Object as Binary File
I have looked fot his solution, but Im not sure what to search for.
I have an asp.net based report. I need the user to be able to download
an XML file of the results so they can use the data in Excel, etc.
I do NOT want to write the file to the server first. I just want to be
able to write the contents of the Dataset into a binary file and send
it back out to the user as a download, but all in memory.
Can you give me a boost in the right direction or an article that
> I have an asp.net based report. I need the user to be able to download
&g...MFC String-table in C# ?
maybe a bit OT for this newsgroup, but I know that people here use C#, too.
So, does anyone know how the MFC string-table technique map to C#/WinForm?
I initially thought about using an integer->string map in C#, but is there
some built-in mechanism to manage that?
"Giovanni Dicanio" <giovanniDOTdicanio@REMOVEMEgmail.com> ha scritto nel
> So, does anyone know how the MFC string-table technique map to C#/WinForm?
....after some web search, it seems that C# has a ResourceManager class ...How do I automatically plot different ranges of data in different.
I need to chart parameters that are a function of three variables in the 2002
version of Excel. I have used the x and y axis to represent 2 variables on an
'xy chart', but require an automatic method to represent the value of the
third variable. I have tried the 'bubble-plot', but cannot get sufficient
resolution between the data. Is their any way that I may plot the third
variable in different colours/shades, that automatically changes for
different ranges of the the third variable?
THis might help you:
How does one generate a XML code?
If you have data in a dataset, you can have the dataset do it automatically:
Dim x as string = DataSet.GetXML
"Raj" <Raj@discussions.microsoft.com> wrote in message
> How does one generate a XML code?
...XML deserialization from string
I have an XSD and created a VB.NET class file from it. When I have an
XML file (conforming to the schema), it is straight forward to
deserialize using the class file.
I am looking for ways to deserialize when I have the XML as a string
and not in a file. Writing the string to a file and deserializing from
the file might have an adverse effect on the performance.
Anyone know of a good method to do this?
Any help will be appreciated.
Use a StringReader to read the file and wrap that in an XmlTextReader.
This posting is provided "AS IS" with no warranties,...DataSet from XML
There are several options on my WinForms app where the user can change/add
or delete options - these settings are saved in an XML file. When the main
form opens, the XML file (and schema) is read into a dataset and the options
are displayed in the various controls. Pretty basic... but I am still
My questions is this - when the user makes a change to one of the settings,
how to I modify the dataset and display the new data in the controls? Do I
create a new dataset in each method? That would seem inefficient as the
user could makes dozens of changes - each time creating a n...Operator Overload between different types
I'm trying to implement the overload for two different kinds of objects. I
tryed for example:
Dog1 + Dog2;
Dog Dog::operator+(Dog& s)
return this->nBau + s.nBau;
it works fine.
I need something...
Dog1 + Cat1;
??? Dog::operator+(Cat& s)
How can i implement my overload between different types and what type of
object must return?
I can only compile my program only specifing "return 0" in overload function
but it doesn't work.
Maybe i must implement overload function as static function outside class
Some help please.
My final n...Automating Different Survey Results
Does anyone have any idea on how to facilitate the preparation of surve
Our survey results are downloaded from our survey online facility (som
facility when it can't even produce the report :sigh:). These survey
are about the services of the different support groups of our company
So each survey has its own set of questions. The backend process o
translating these results is quite tedious and I've been thinking o
how to automate it ... I know that there is a better way. I am usin
Excel but only the standard features such as countif, sumproduct
pivot, charts. But still it c...different colors for x-Value axis
I want to use different colors for X-Values in X-axis of a chart. Is it
I-1, I-2 black
II-1, II-2, II-3 grey
III-1, III-2 red
V-1, V-2, V-3 green
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan
The best solution is that, Excel brings the formatting of x-axis value from
Rasoul Khoshravan Azar
Civil Engineer, Osaka, Japan
> I want to use different colors for X-Values in X-axis of a chart. Is it
> I-1, I-2 black
> II-1, II-2, II-3 grey
> III-1, III-2 red
> IV pink
>...What's the Difference Between This NG and microsoft.public.excel.misc?
(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
Obz Site: 39� 15' 7" N, 121� 2' 32" W, 2700 feet
Web Page: <www.speckledwithstars.net/>
You are posting to the microsoft.public.excel
so I'm not sure what you mean by the subject line? your's ends in .m which I
don't think is a legal site.
The microsoft Excel newgroup area has many sub-areas dealing with: