Name could not be resolved error.....
Have a strange problem, where I can set up mail accounts,
and use these fine, but if I try to add a mailbox in the
Open These Additional Mailboxes field, I immediately get
an error "The name could not be resolved. The action could
not be completed"
This is before ive even tried to resolve a name, its as I
click Add, the error just appears, so you dont even get a
chance to put a name in there.
Any ideas what could have caused this? it seems to be
after we ran the move server wizard and moved the server
with these accounts on into a new site.
...Checkbox event to control other checkbox selections
I have been working for a couple of hours now trying different ways to
solve this problem and I'm out of ideas (or tired). :-/
Here's what I'm trying to do:
On a form I have a section with six checkboxes that represent 6
different mailing lists an organization can subscribe to: MailList01,
I have a seventh checkbox named MailListOmit for orgs that want to opt
out of mailings.
If MailListOmit is checked, when the user attempts to click any one of
the MailList checkboxes, I want to return a dialog box that says,
"This organization has chosen to not receive ma...Pivot Table Help #3
I have a lot of data that I am trying to analyze with a pivot table and am
not sure how to go about it.
(2) Store #
(3) 2003 Score - these are #s or text ("incomplete")
(4) 2004 Score - these are #s or text ("incomplete")
For each district, I am trying to find out 3 things:
(1) % of stores incomplete
(2) Average score for 2003 & 2004 - I've got this one working properly
(3) % change between 2003 & 2004
I can successfully analyze the data in a spreadsheet but there is too much
to go through and thought a pivot table was the way to ...Event ID 125
I have received an Event ID 125 on an Exchange 5.5 server. Along with this I have an ID Error #193, 1005 7 and 100 amonst others. Is it possible that during a backup in schedule+ for a client on the client's machine, that the procedure corrupted the EDB.log or any other file? If so, should I be using Microsoft Base Article #275602 to repair. At this point, my Echange server is down. Thanks.
Based on the limited information; the 275602 XADM: Microsoft Exchange Server
Information Store May Stop After a http://support.microsoft.com/?id=275602
would be a recovery method. Did y...Select multiple adjacent cells of multiple cells without selecting
Select multiple adjacent cells of multiple cells without selecting adjacent
cells one by one. those cells looks like;
|adjacent cells |cells|
|some characters | A |
|some characters | B |
|some characters | A |
|some characters | A |
|some characters | B |
I am trying to select adjacent cells of A cells without selecting adjacent
cells one by one.
Thank you for your help.
Adjacent in this case, means?
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgr...Subtract colums in pivot table
I have a pivot table that has the following characteristics (Excel 2007):
-rows (down the left) are values: "# Employees", "Total Pay"
-Columns (across top) are Dates
I want to calculate the difference between different date columns.
5/23/2010 5/16/2010 5/24/2009 Total
# Emp 10 15 5 30
Pay 1000 15000 500 16500
5/23/2010 5/16/2010 5/24/2009 Total Vs. Last Wk % Change Vs. Last Yr % Change
# Emp 10 15 5 30 -5 -33% 5 33%
Pay 1000 5000 250 6250 -4000 -80% 750 15%
Can anyone tell me how to cre...How to substitute for a non-existing column in a joined table
Is there a simpler way than a UNION to return a default value of a joined
table for which a corresponding row does not exist?
The following example (not a working one, of course) illustrates what I'm
after. I'd like to return 'N/A' as c2name if there is no matching row in t2
WHEN NULL THEN 'N/A'
ELSE t2.name END) AS c2name,
LEFT JOIN t2 ON t2.t1pk = t1.pk
On 2010-04-21 21:05, bob wrote:
> Is there a simpler way than a UNION to return a default value of a joined
> table for which a ...Pull Data From Multiple Tables ????
I will have 4 tables name "TblCostomers","TblVendors","TblAccounts",
Now i have a for name "FrmDrVouchers" that has a table "TblDrVouchers" in
This form has two TxtBox Control name "TxtAccountNo" and "TxtAccountName"
If User enters a Account No., It pulls the Account Name from Any One of these
I can do this if I have only one table.
But tell me how can i do it while I have 4 tables for One Field of a table
Message posted via AccessMonster.com
http://...retrieving directory names
Apparently it's a simple question: How do I retrieve the directory name
that my program's running in?
Background: My applications reads and writes its' configurations from an
xml file which is supposed to be stored in the same directory with the
executable. Relative pathnames like ".\myconfig.xml" appear to work at
startup but as soon as I invoke some file dialogs during runtime the ".\"
expression is resolved to the last directory I opened something from.
The followup-question to this would be: How do I retrieve directory names
like "my pictur...#Name? problem that has been stumping Everyone
I have been posting this message for about 5 days now and no one has
been able to help.
I have a macro that fills down the formula
=IF(AT2 = 500,MROUND(AI2,500),IF(AT2 = 5,MROUND(AI2,5),IF(AT2 =
10,MROUND(AI2,10),IF(AT2 = 25,MROUND(AI2,25),IF(AT2 =
100,MROUND(AI2,100),IF(AT2 = 200,MROUND(AI2,200),IF(AT2 =
Each time I fill down the range using the macro I get a #name? error.
As I have posted before there is no error in the function because when
I go into the status bar at the end of the formula and MANUALLY hit
enter the formula calculates correctl...Sort highest by name
I have 55 teams in A1 to A55.
I have their scores in B1 to B55.
Is there a way to list the scores (highest to lowest) but giving their team
names instead of all the numbers in order of the highest to the lowest?
Help Obe 1
Why don't you just sort this data by column B in descending order?
Select the range starting from cell B1 then just click the sort descending
button on the toolbar.
If you don't want to sort the data then you could use a formula. Are there
any tie scores? What type of values are the scores? Are they whole numbers?
Microsoft Excel MVP
&qu...How to get device name?
I want to know all the name of devices in my PC,
because I want to open them using API CreateFile and test it,
how to do?thanks.
what you want do by meanin "test it"?
You cant open all devices with the
API CreateFile (for several reasons).
Beste Gr�sse / Best regards / Votre bien devoue
Latest Open-Source Projects: http://entwicklung.junetz.de
"Lee Tow" <firstname.lastname@example.org> schrieb im Newsbeitrag
news:#vVH#JkqKHA.4220@TK2MSFTNGP0...Renaming table in a dB
Is there a short way in which i can modify all references to a table after i rename it? Or would i have to open every query and form and manually change the table references?Thanksramesh Access doesn't provide a way to do this.There are commercial products that do, e.g.: http://www.speedferret.com/-- Allen Browne - Microsoft MVP. Perth, Western AustraliaTips for Access users - http://allenbrowne.com/tips.htmlReply to group, rather than allenbrowne at mvps dot org."Ramesh" <ramesh2020@gmaildotcom> wrote in messagenews:uGgN$EuZHHA.4000@TK2MSFTNGP02.phx.gbl...> Is the...Charting depending on criteria & data series name as a column val
I want to chart some prices as I want to take a look at price trends.
My problems, and I can not figure out how to solve them, are:
1. Is it possible to dynamically change the chart depending on certain
criteria (product family & selected customers)
2. As the number of customers is variable and they are in one of the
columns. Is it possible to plot a series (customer name), depending on the
name of a column?
3. I want to chart the data based on the date, but just include the dates
available, to prevent periods of time showing no change (e.g. I don't want
monthly ticks for the x a...Tying tables to forms
I have four connected tables that work well as table input but when I put
them in a form some of the fields will not let me make entries. Does this
happen because I am using the Id fields and subsequent data from the wrong
It sounds like you have created a non-updatable form.
One cautionary note first:
Don't tie your forms directly to the tables. Use queries instead. The
queries will act as a stop light for which data is written and when. If more
than one person tries to make a change to the same record at the same time,
you will run into problems.
From wha...Dummy series and data table
I have a chart that presents 2005, 2006, 2007 summary data as a column
chart and then 2007 by month as a line. To show the yearly data I have
a yearly category, after which I have individual months where the
yearly data is zero - sort of like a dummy series - because I only
have one value for them. The 2007 detailed data has zero in the yearly
column but all the individual values in the monthly columns. It worked
fine until I was asked to add a data table to the chart. Now, since it
has 2007 twice - once as the summarized for the year and the other as
all these individual months - some us...Sumif across a table
I am looking for a function that works using a =sumif function to add things
that are not in a range that are next to each other as seen below the letters
in () are the columns that the values are in...
so I am looking for a sum in column A "X" of the total work out time if the
appl column is "Y"
total work Running (D) Walking (F)
out time (C) Appl (D) Time (E) Appl (F) Time (G) Appl (H)
X Y 20 N 0
Y ...Aging report table for accounts receivable
Can somebody tell me what is the table for a/r aging..I want to make
query/view in sql server 2005
You need to use RM20101 and RM10201 tables. You need to use date functions
to get the aging for your view based on document date or due date field. If
your aging is setup to be by Doc Date, Consider Doc Date and If it is due
date, you should be taking it by Due Date.
> Can somebody tell me what is the table for a/r aging..I want to make
> query/view in sql server 2005...columns changed to numbers instead of letters?
I noticed my excel clumns have changed from letters to numbers and
forumlas now look like =RC[-1]*R[-3]C
I was trying to make the R[-3]C static (using the $) but it errors.
In Excel Options uncheck "R1C1 Reference Style"
Gord Dibben MS Excel MVP
On Thu, 28 Oct 2010 20:25:30 -0400, Mike <email@example.com> wrote:
>I noticed my excel clumns have changed from letters to numbers and
>forumlas now look like =RC[-1]*R[-3]C
>I was trying to make the R[-3]C static (using the $) but it errors.
Can I develop a formula that I can add to those which you pick from whe
using the wizard ie sum, average, min, max etc
Specifically, I want to add an IF statement to give me a 'flag' i
which to summarize the data with elsewhere. The data behind the pivo
changes (sales data) and I am trying to flag new customers that hav
never worked with us before.....once they have traded with us then the
dissappear as they are now an old customer
Message posted from http://www.ExcelForum.com
no you can't do this
> Can I develop a for...Event ID ( 5898 & 5892 ) in Source ( CrmExchangeQueueService )
Our CRM decided this morning to stop forwarding emails to the CRM
system. The emails still get into the Exchange and OWA.
I have checked the url in the `mailserverurl` registry key, and that
seems fine. I've uninstalled/reinstalled CRM Connector also. I hadn't
applied any patches since a few days after the last MS patch day.
I noticed that when trying to access "/MSCRMServices/CrmEmail.srf" that
the IIS logs show an error 500 or 401.
Full Text of Event log messages:
The description for Event ID ( 5898 ) in Source (
CrmExchangeQueueService ) cannot be found. The local c...Column names
Is there any code to convert column(number) to column(letters), and V.V.
e.g. 27 for AA, AB for 28
"daniel chen" <firstname.lastname@example.org> wrote in message
> Is there any code to convert column(number) to column(letters), and V.V.
> e.g. 27 for AA, AB for 28
Great! Thanks. How about the other way?
i.e. 27 for AA
"Peo Sjoblom" <email@example.com> wrote in message
news:%23MpiXScTFHA.2560@TK2MSFTNG...Name AutoCorrect 09-26-03
I am running Access2000 and working on an existing
database (I believe it was converted from FoxPro).
I have turned on the Name AutoCorrect options (in Tools >
Options > General), however, Name AutoCorrect does not
I searched KnowlegeBase and found a report 230616 which
explained that for a "converted database", I need to save
each control that I plan to change, in order to generate
the Name Map. I have done that, but Name AutoCorrect
still does not work.
Not 100% sure but...
1. Can you create a new .mdb, set the NameAutoCorrect, and import the
objec...Shortcut into Name box
Hi there. Using E02 on XP. I'm using the Name box (above
A1) and wonder if there isn't a keystroke to 'jump' into
it quickly? Thanks in advance for any help!
Depends on what you use it for. If you quickly want to jump to a named
range, you can also use F5.
Microsoft MVP - Excel
"Bonnie" <Hambrick@discussions.microsoft.com> wrote in message
> Hi there. Using E02 on XP. I'm using the Name box (above
> A1) and wonder if there isn't a keystroke to 'jump' into
...Cross referencing named row with named column
I'm trying to find a way to cross reference a column named June with a row
named Sales but cant figure out what the syntax is. I thought it used to be
=June|Sales but it doesnt seem to work.
"davide212" <firstname.lastname@example.org> schrieb im
> I'm trying to find a way to cross reference a column named June with
> named Sales but cant figure out ...