Outlook periodically points to DC instead of Exchange server
I have a strange issue that started recently. Outlook clients on the
network will occasionally get the balloon that says "Outlook is
retrieving data... from server SATSAD1.mydomain.com".
The problem is that this server is only an Active Directory DC. My
exchange server is SATSMAIL.mydomain.com.
Any ideas why this would happen? It always correctly finds the exchange
server eventually, but why would it THINK that the other server is the
<firstname.lastname@example.org> wrote in message
> ...Using Groupwise instead of Outlook in GP 10
We've recently starting using GP 10 and are having problems utilizing the
'Send To' function to send a report via email. This option, as you may know,
is available in most Screen Outputs. Right now, if I click that button, I'll
get a dialog asking me to choose a profile - the "Novell Groupwise" is the
default entry. Unfortunately, this does nothing.
Has any one had any success with using Groupwise as the email client instead
of Outlook? Our partner was asked, and they unfortunately are running
Outlook, which appears to work with no problems.
Migrating...Formula/calculation returning a 0 instead of actual sum
I am using 2007 and I have a workbook that returns a "0" instead of the
actual sum. I have tried using @sum formula and just adding the cells
Sounds like your values are not "real" numbers. They may be Text values.
Another possibility is you may be in manual calculation mode.
Gary''s Student - gsnu200908
"Jenny Beech" wrote:
> I am using 2007 and I have a workbook that returns a "0" instead of the
> actual sum. I have tried using @sum formula and just adding the cells
...Drop Down list will not choose Yes in protected 2007 form
Using Word 2007 with legacy tools for drop down form field. Only one user has
the problem which is - can not choose Yes from the drop down field. He sends
me the document and I have no problem. The document is on his desktop. The
problem is with his PC, but I don't know what else to check.
Any help will be appreciated.
...drag and drop #5
Does anybody know how to implement drag and drop with bitmat obiects? I have
to drag a bitmap from one part of my window to another. There is no need to
move it outside the application.
if all you need is just moving some picture inside a window, system d&d isn't the
best choice. I would rather use mouse messages (MOUSEOVER,MOUSEDOWN,MOUSEUP) to track
mouse positon and state to paint the picture by myself(CDC::BitBlt) in a MOUSEMOVE
event handler. Of course, before drawing, care must be taken to erase previously
"Marcin >poczta.onet.pl>&q...Table to feed form instead of lenghty code?
I a database that is kind of like an Auction type deal. If a user enters
their user ID and click the button, it will automatically display their
chosen private ID (or Auction ID). What I want to know is, I have 80 people
in my department and the code (only way I know how to do it) will become very
long. Can I set up a table with the User ID and Private ID and when the
button is clicked, have it read from the table and display the Private ID
that way? Below is how I am going to do it if no alternative.
Private Sub cmdStatusUpdate_Click()
Me.NewBid.Locked = False
...Drop down box values
I've been given this task to do in Excel and I need help.
I have a column/list in worksheet2. The list is indexed and must stay intact
as many cells in the workbook use this list.
Lets say in this column I have the following information:
GEVA 1/2 - 2 1/2
GEVA 3 -5
GEHA 1/2 - 2 1/2
GEHA 3 -5
Now I want to add two drop down boxes on another worksheet. Drop down box 1
would have the values:
The list in Drop down box 2 would be dependent on what value is selected in
drop down box 1 so if Absorp is selected i...Pictures in body of email instead of as attachments
How do I put pictures/graphics in the body of an email instead of it
becoming an attachment
Using Outlook 2003
On Thu, 17 Jul 2008 13:01:43 +0100, Martin ���� @nohere.net wrote:
>How do I put pictures/graphics in the body of an email instead of it
>becoming an attachment
>Using Outlook 2003
I found the answer in another thread
To insert a picture as an attachment
To insert a picture in the body
Martin ���� @nohere.net <Martin ���� @nohere.net> wrote:
> How do I put pictures/graphics ...CRM V3 adding drop downs in disqualiftying leads
we are using version 3.0 and see that in v1.2 you can add additional drop
down selections to disqualifying leads, how do we do it in v3.0?
Settings > Customization > Customize Entities
Click on the Lead to open the entity. Click on the Attributes under Lead.
Find the statuscode attribute and open it. On the right of the Attribute
window, there is a dropdown called State. The choices under this are Open,
Qualified and Disqualified. If you select Disqualified you will see that the
picklist values for this state are displayed below it. You can edit or add to
Hope...Error with combobox control on standard toolbar
i have code which creates a combobox control on standard toolbar on
microsoft excel. i have a bug in this code ... dono where i have gone
wrong ..... hope anyone can help me with this ...
Dim cBar As CommandBar
Dim c As CommandBarComboBox
Dim i As Integer
=91 Set reference to standard toolbar
Set cBar =3D Application.CommandBars(=93standard=94)
=91Add Combobox Control
Set c =3D cBar.Controls.Add(msoControlComboBox, 1)
For i =3D 1 To ThisWorkbook.Sheets.Count
.AddItem ThisWo...ComboBox Values to TextBox
On my form "frmDetails", I have a ComboBox "cboProblem" and a field [RATE]
The ComboBox looks up the values from the table tblProblem with 3 fields
[ID] [TASK] [RATE]
The 3 fields are formatted as AutoNumber, Text and Currency
The ComboBox RowSource is SELECT [tblProblem].[ID], [tblProblem].[Task],
[tblProblem].[Rate] FROM tblProblem;
I need to select a Problem from the ComboBox and the [Rate] field
I am using Access 2007.
I have tried a few variants of the following but cannot get get the field to
"Me!Rate = Me!Problem.Colu...Drop Ship Purchase Order Returns
When we try and do a return or a return with credit against a drop ship
purchase order we are always blocked by an error message stating "You can't
return against a Drop Ship or a Drop Ship blanket purchase order".
Is there a way to work around this limitation? why is the limitation there
in the first place?
Thank you for your help.
I too would like this to change. I guess the theory was if it's drop-shipped
to your customer you don't have it on site to return.
"Claude Garceau" wrote:
> When we try and do a return or a return with credit against a d...Accessing Uploads via Cable modem instead of Telephone ISP
I recently changed ISP providers from AOL (telephone) to a
broadband cable provider but can't seem to find the way to
get money 2002 to recognize this change. Has anyone run
into this before? Do you have any suggestions how to
switch from AOl to cable modem ISP.
What uploads are you trying to access?
Money should use any available internet connection unless your bank's online
banking requires a dialup connection. You might also review your connection
settings in Internet Explorer to confirm that you don't have "always dial my
default connection" checked.
--...get a negative percentage in brackets instead of a negative sign
I am trying to get a press release set up and I have
negative percentages and need them to have a bracket
around them and not a negative symblol. How is that
possible using excel
Format>Cells>Custom I the Tyoe box, enter 0.00%;(0.00%)
Microsoft MVP - Excel
"Anthony Beer" <email@example.com> wrote in message
> I am trying to get a press release set up and I have
> negative percentages and need them to have a bracket
> around them and not a negative symblol. How is that
> possibl...Rule is copying item instead of moving it
I have a .inbox (. to make it come first in the list) and
a receipts folder under my personal folders. I've created
a rule to move anything with "read:" in the subject to the
receipts folder on my personal. Then I have some rules to
move anything else (3 rules, one for each importance to
capture all e-mails) to my .inbox.
The receipts move rule is putting items in the receipts
folder but it also leaves a copy in the .inbox (indicating
that it's getting captured in the 2nd set of rules). I
specifically run the receipts rule first so it's taken
care of but I can...drop down arrow missing on pivot table when refreshed
I used this to get rid of old items in a pivot table.
Dim ws As Worksheet
Dim pt As PivotTable
Dim pf As PivotField
Dim pi As PivotItem
On Error Resume Next
For Each ws In ActiveWorkbook.Worksheets
For Each pt In ws.PivotTables
For Each pf In pt.VisibleFields
If pf.Name <> "Data" Then
For Each pi In pf.PivotItems
If pi.RecordCount = 0 And _
Not pi.IsCalculated Then
when refreshing the pivot table the drop down arrows on the page by
fields disappear. We are runn...Populating a drop down list.
...Exel Calender drop down box 2005
Trying to set up a drop down Calender box, within a Exel Spreadsheet for 12
month period--showing months & days.
Could anyone tell me how I could have excel fill in the date info for my travel expenses? I do a monthly report that I have to use at the end of the year for my taxes.
Message posted via http://www.officekb.com
how would you like to do it. If it's the current date you're after then the
shortcut key combination of ctrl & semi-colon (;) should work.
other than that a bit more information about how your ...drop down list showing only 1 of everything
Hi everyone, basically on one sheet( called data) i have
a list of all the data, the first column is the date. On
a separate sheet i want to have a drop down list in the
cell (A1 for example).
however i want the drop down list to show only 1 of each
date that was in column A of the data sheet.
for example say column A had the folowing dates: 1/1/04 ;
2/1/04 ; 2/1/04 ; 3/1/04 ; 4/1/04 ; 4/1/04
the drop down list on sheet 2 would show the values:
1/1/04 ; 2/1/04 ; 3/4/04 ; 4/4/04
i need some help in doing this and would appreciate any
ideas. thank you....
do you need this formul...Payees not in drop down list
My payees are not appearing in my drop down list when I enter transactons. I
only have 5 payees in drop down list whereas I should have dozens. 3 of the
payees in the drop down list have been deleted (merged to another payee).
The auotfill is working ok. Why is this? Thanks
It appears that only those payees that have been entered in the Payee setup
section appears in the drop down list. All mine ave been entered as I have
entered a transaction. There must be a setting that enables all new payees
entered as you go to appear in the drop down list. If not how can I make al...How to display the value of combobox in footer section of report?
Can someone help me with this problem? I try to display choices of combobox
in random order in footer section of report. Combobox has: Food, Utiliy,
i have a bit of an issue with a combobox
the combobox style is "Dropdown" (so you can type in the field as well)
when the user selects from the drop down, i have an ON_CBN_SELCHANGE
handler update the variable associated with the combobox - i use
now, when i call DDX_CBString, the returned string is the *old* value -
and after the UpdateData() has finished and program execution resumes,
the *new* text (from the dropdown selection) appears!
what is going on? why, when the ON_CBN_SELCHANGE event is triggered,
isn;t the selected value in the edit field o...multiple drop down lists
i have created a drop down list. i am looking to create a sub list (or maybe
2) of this. eg when the first item is selected from drop down list one, a
second subset become availiable.
as an examlpe if the first list was cars and the drop down menu gave
manufacturers names, the second would give models.
There are instructions here for dependent data validation lists:
jason n z wrote:
> i have created a drop down list. i am looking to create a sub list (or maybe
> 2) of this. eg when the first item is selected from drop down list o...need to know how to incorporate drop-down fields and lists
working w/ms word 2003, Designing my own webpage... want to incorporate both
drop-down fields and drop-down lists, won"t let me put in the text i need???
Talk to me like i"m ten yrs. old.... new to this stuff. Thanks!!!
...Drop-Down List #4
How do you print drop-down list?
Drop-down list ( = Combo Box) should automatically be printable. Yo
can check if it is by right clicking the control (or Form object) an
selecting "Format control..." from the menu. There on Properties-ta
you can see a check box Print object.
Jazzer's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=446
View this thread: http://www.excelforum.com/showthread.php?threadid=26414