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.
...Showing Specific Data from Master Sheet to Another Sheet
I am making a bill of materials at work and have a master list I want to
access from other sheets.
The master list has all parts named and categorized, and I want to be able
to access sections (Hydraulics, Chassis, Electrical, etc.) of the master from
I have tried pivottables but I am having issues showing the data in it
Part Name Quantity Material Expense Category etc.
(accross the row)
I wish to be able to make calculations only off the selected data on each
sheet but I am having immense problems getting there.
If you can help.
Parker Jo...Activities don't show up until we hit the refresh button
We upgraded from 3 to 4 and it appears that the upgrade did not complete
successfuly, but the users used the system.
Everything appears to be working well except for a couple of strange things
like when we create an activity the activity does not appear until we hit the
Refresh button, going to history and coming back does not fix the issue, only
the refresh button any quick fix on this one?
...SBS 2008 Fax Sent Items Not showing all faxes sent
I need to allow sent faxes to be seen by all users. I have Windows XP and
Windows 7 64bit client machines. Currently they can only see their sent
faxes. In SBS 2003 they were able to see all sent faxes.
Could you create an Outlook rule based on the fax sent acknowledgement that
copied the fax to a public folder?
"RodSoh" <RodSoh@discussions.microsoft.com> wrote in message
> I need to allow sent faxes to be seen by all users. I have Windows XP...Show All Groups in 2007
I've looked for this setting, but can't seem to find it -- or, maybe it's not
available (which would totally surprise me) -- is there a way to always "Show
All Groups" in Access 2007 as opposed to having to right click on the
navigation pane and activate all the time? I prefer to see all my objects at
once. Thanks for any help.
Yes: the top of the Nav Pane has a drop-down. Choose:
To see them sorted like previous versions, right-click on the top of the Nav
Pane, and choose:
Category | Object Type
Allen Browne - Microsoft MVP. Perth, W...How do I send newslette in email without showing the publisher too
When I email my newsletter as an attachment, when you open the attachment, it
takes you to the publisher program page where I built it. How can I send a
"finished" newsletter out?
As a .pdf file.
MVP Microsoft [Publisher]
How to ask a question
"Lifefire" <Lifefire@discussions.microsoft.com> wrote in message
> When I email my newsletter as an attachment, when you open the attachment,
> takes you to the publisher program page w...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...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...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...#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...Calculate number of months
I have a field where I am trying to implement a calculation. I want it to
take the date in a cell and subtract it from today's date to show me the
total number of months between those two dates. So right now, it looks like
=(TODAY())-D3 and it returns 167 - the total number of days. How do I make
it show me months?
THANK YOU IN ADVANCE
"TxWebDesigner" <email@example.com> schreef in bericht
> I have a field where I am trying to implement a calculation...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...How can I prioritize tasks by number in Outlook 2007?
I am trying to create a custom priority for my tasks in Outlook 2007, but I'm
not able to edit the field that was created when I changed the settings to
include a custom priority. I'm trying to put a number into it, so that I can
sort my tasks in a certain category by number, but I'm not able to.
We aren't watching you and your explanation is missing details.
Where in Outlook are you trying to view the Tasks? There are 3 places to see
If in the Task Folder, what View are you in? If in Tasks folder you
probably need to turn on in-line editing.
Judy Gle...I have a problem with getting a total Sum of numbers (URGENT)
I'd really appreciate if someone could help me here.
I am using Microsoft Excel 2002 on a Microsoft Office XP system. I a
trying to develop a minor league baseball schedule, but am having som
I have attached a copy of my spreadsheet to give everyone some idea o
what I'm doing here.
I have where the fans list the "RUNS, HITS & ERRORS) of both teams an
for each game of the series. I then have it set up in the TOTA
WON/LOST column where if the T-Bones RUNS are more than the SALTDOG
runs, a "1" appears in the WON column. If the SALTDOGS have a highe
numbe...Stop Buttons showing when opening up form
I have a button on my Main Start up page that when click makes these buttons
visible, but when I open up my DB they automatically show on start up, is it
possible they not be visible till I click ckbHelp.......Thanks for any
Private Sub ckbHelp_Click()
If ckbHelp = True Then
cmbHelpNewHorse.Visible = True
cmbHelpActFinHorse.Visible = True
If ckbHelp = False Then
cmbHelpNewHorse.Visible = False
cmbHelpActFinHorse.Visible = False
In design view, set the property pf the *button* Visible=No
"Bob" <firstname.lastname@example.org> wrote i...Balances don't show when reconciling
I just upgraded to Money 2004 and the totals dollar value
of debits and credits cleared no longer shows. Instead,
this line shows:
"The difference between your statement and register is:"
along with the difference. I want to know the dollar
value of debits and credits I have cleared so far and
compare that with the bank statement.
Somebody at Microsoft thought this was an "improvement" compared to the way
they presented the data in M03 and earlier. It's probably something that
came out of the usability lab after they took their great grandmother in to
see if ...number in system using arrivals and departures
Is there and easy way to figure out the total number of persons in a system if have access to the arrival and departure times. I have tried to use counts with if statements, but I keep getting the number 1. I know this is not correct. Is there any special macros or functions
you may provide some more details about your data. Could you post some
example rows (plain text - no attachments please) and describe your
> Is there and easy way to figure out the total number of persons in a
> system if have access...how would you calculate the number of hits to your website
can some one tell to me the answer of this question
On a website, how would you calculate the number of hits to your
...Some contacts don't show on drop down box when addressing email
I was using Outlook Express, my computer motherboard died, got new
computer with Windows 7, trying to learn Outlook 2003.
The computer tech from my husband's office put Outlook 2003 on the new
computer and somehow transferred the addresses that I had in Outlook Express.
I do not know what method he used to get the addresses into Outlook 2003.
Some things carried over just fine, some things didn't, i.e. a group list of
my subdivision property owners, so I had to re-make that distribution list.
When I want to email my daughter, her name or email address is not s...Customized picklist fields are not showing up in the preview
can you please help me out in the following situation:
i have customized my crm 1.2 system in a huge manner. now all customized
picklists do not show up in the preview of e.g. opportunity. opening such a
related opportunity offers me the possibility to change the picklist field as
note: all built-in picklist fields are showing up in the preview...
Did you publish the customizations? And performed an IISReset?
After those actions your changes should be visible.
Hope this helps,
> hi,...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.
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...A way to increase a number in a cell by using the + key
Hi, i do a lot of data entry and am looking for a way to increase the
number in a cell (or range of cells) so that i dont have to enter the
new number in each time. I have columns that separate items and i use
the sheet to show the total count for each item in it's row.
Item 1 Item 2 Item 3
2 5 4
I'd like to use the + key only to increase the counts for each item.
Did i make sense?? It's a Friday and my mind isn't quite up for a lot
of detailed explanations, lol.
Any assistance would be appreciated.
That would require VBA
How far are you will...reference number #2
Where does the information in the "reference number" field in the
transaction table come from? I see tranactions with reference numbers -
the first part of which appears to be the year, month and day - but I
can't figure out the second part. It is nothing that we have
intentionally entered while ringing out the customer. Pls help.
Newsgroup Access Courtesy http://www.rockryno.com/
Tax and Accounting Software Forums
Web and RSS access to your favorite newsgroup -
microsoft.p...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