I need to turn off the stationery option for everyone in
my organization. Is this possible?
...Oulook Express 6 Connection problem
Recently, I am having serious problems not being able to
secure a connection when sending e-mail via Outlook
Express6. I am getting a Cannot find server message Number
0x800cccCO131. Many times, Outlook disconnects altogether
and I frequently get a "Can't Find Page" message for
either Inbox, or Sent folders although in some instances
thhe message disappears and the folder appears as I wsitch
folders. This is all very disconcerting and affects my
business as well as costing many hours of lost downtime.
Need help fast (before I lose my mind--or business).
...Averaging a Value between Two Serial Dates
I have two spreadsheets. The first spreadsheet contains two columns, one for
start date/time (in serial format) and the second for stop date/time (in
The second spreadsheet contains two columns. One containing a serial
date/time and the other containing a meteorological value (eg. temperature).
I want Excel to read the start and stop date/time from the first spreadhseet
and then search the second spreadsheet for all temperature values which were
recorded during this time frame.
Lastly, I want Excel to average these values.
Is this possible using a single Excel func...Find Oldest date based on two criteria.
I am having an issue trying to figure out this issue.. I have tried a
MIN, but it doesnt seem to work correctly..
I have three columns One with a State, one with a Code and one with a
The Code can have say EA12 EA23 EA45 and FG12 FG34 FG56
What I need to have happen is that when State= NY and CODE Starts with
EA find me the oldest date in the column.
A B C
NY EA12 1/1/2009
NY EA24 2/28/2009
CT EA12 3/2/2009
NY FG34 4/5/2009
ME FG45 5/1/2009
NY EA12 ...trying to export .aba file from Palm Desktop to .csv file and having problems with irregular characters
I'm getting these odd square characters in my notes section of
the .csv file which I think are carriage returns in palm desktop that
are unrecognizable to excel. Any idea how to eliminate them?
Here's a pic of what they look like"
> I'm getting these odd square characters in my notes section of
> the .csv file which I think are carriage returns in palm desktop that
> are unrecognizable to excel. Any idea how to eliminate them?
> Here's a pic of what they look like"
I hate to ask what...offline sync problem
Yesterday I had a customer's 8 register system lose internet connectivity, so
all the registers went off-line. They are using RMS 1.2 SR3 on a SBS
Professional 2003 Server with XP SP2 registers. When internet connectivity
was restored today, all but one of the registers sync'd. On the register
that did not, the last transaction in the batch was at about 7:40pm
yesterday. No transactions were recorded after that time. I manually took
the register off-line today and could not find any batch or blind-closed
batch with any transactions after 7:40pm.
I also checked, via MS Acce...Date and Time Stamp with a keystroke
If I want to use a keystroke in Outlook to insert a date/time stamp (like
ctrl+; in excel) how is this set up?
Thanks in advance...
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, certolnut asked:
| If I want to use a keystroke in Outlook to insert a date/time stamp
| (like ctrl+; in excel) how is this set up?
| Thanks in advance...
I am running a query from a table that limits the output of data to a
specific time frame. I am working on the last month minus 12 months. So
what I want to see is from April of this year to May of last year. This is
progressive as the months change. i have been using:
Between (DateAdd("m",-1,Date())) And (DateAdd("m",-12,Date()))
This gives me this years May which I do not want.
Any help would be appreciated
Message posted via http://www.accessmonster.com
On Wed, 09 May 2007 19:18:04 GMT, "rollover99 via AccessMonster.com"
...Problem with Table Column Not Expanding
I've got text in a table column that extends beyond the visible edge of the
column. It appears that Word 2007 is not actually extending the table as it
should but stops right at the page break.
On the Table tab of Table properties, make sure text wrapping is set to
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"David C. Holley" <David.C.Holley> wrote in message
> I've got text in a table column that extends beyond the visible edge...dashed line printing problem
I am having problem in printing charts which has dashed lines.
Whenever I make a graph which has dashed line instead of solid line,
on the computer screen those lines appears to be dashed but when I
print the graph those lines come to be solid.
I believe it's bug in excel. I was reading and microsoft suggest
installing service pack 3 for the office to get the problem rectified.
I installed the service pack but the problem still persists.
Can somebody help me if he know the work around with this problem.
...Problems with a form in Access 2000
We are using Windows 2000 pro with Access 2000. We are having this problem
on one machine only. There is an input form that has a memo field in it.
When the guy tries to hightlight some text in that memo field, it highlights
the whole memo field as soon as he clicks in it instead of letting him
choose what data to highlight. Sticky keys are not on, on his machine, I
checked that. The database has a front end and a back end and he is working
in the front end. To make the problem go away, he has to restart his
machine. What could possibly be the problem?
...problem with header rule...
i seems to have a problem with only one rule type.. i
have a rule that says to permanently delete any mail
which contains certain words in the header.. i also have
the same basic one for words in senders and recipients
names... but on those rules i have no problems with it
just checkin the perm. delete only, but on the header
rule it turns on the stop processing more rules checkbox
automatically if i have the perm. delete on... i dont
want the stop one on.. just the perm delete... for now i
just moved this rule to last place so it is the last one
to process anything ayways, but i wou...Microsoft Outlook has encountered a problem and needs to close
After un-installing Norton Internet Security using
Add/Remove Programs I get the message "Microsoft Outlook
has encountered a problem and needs to close" when trying
to run Outlook. I have tried removing all account info,
running with /safe etc, reinstalling office xp,
reinstalling Windows 2000 but still cannot start outlook.
Any ideas anyone???
...Problem with Outlook 98 Not Closing
We have some clients who recently began running Outlook 2003 over dialup
RAS without any problems, but when they use a LAN or dialup connected
machine with Outlook 98, the Outlook client won't fully close unless they
manually close it with task manager or logoff or restart the machine. A
dialog stating that Outlook is exiting remains on the screen and doesn't
disappear. The problem began once they started using Outlook 2003.
Interestingly enough, Outlook 97 exits without any problems.
Does 2003 make some changes on the Exchange server that cause Outlook 98
to try to run some...calender problems
By mistake I imported(old Schedule plus import) another user's calender into
my outlook (I meant to just look at his calender). Now, of course, "people"
(I still have this in testing mode) so no big deal, yet) think they are
looking at my calender instead of his. How can I fix this? Also, his admin
assistant has to view his calender, however, she has to use another Exchange
server and you can't use two Exchange servers. Since I screwed up the
import, viewing her boss's calender(in OWA) is impossible. Please advise.
"amyb" <email@example.com> wr...Problem when trying to make initially invisible a dialog base app
I programmed a dialog based application that shows an icon in the traybar.
Since all functionality is made from a menu shown when user clicks on that
icon, I want the dialog to be invisible at startup.
I tried it by using SetWindowPos(........., SWP_HIDEWINDOW) and
ShowWindow(SW_HIDE) API's in OnInitDialog method but always the dialog is
What can I do?
> I programmed a dialog based application that shows an icon in the traybar.
> Since all functionality is made from a menu shown when user clicks on that
> icon, I want the dialog to be inv...Update Problem 06-28-10
Recently, I downloaded & installed updates by going to the Windows Update
site -- just like I regularly do, . The update process went fine -- all
updates were installed. NOW, however, the program (Acronis) that I
regularly use to backup my hard-drive crashes with a BSOD specifying a
kernel error. I guess that I will have to UNinstall these updates to be able
to run that program. Is there any way I can find out which update is causing
the problem so I only have to UNinstall only one of these updates?
I use WinXP Pro SP2.
On 2010-06-28 2:52 p.m., MN wrote:
> Rece...Risk and Decision Analysis @Risk, Evolver, Decisiontools, Roy Kelly FloorTrader Tools 8.3, AmiBroker 5.0, MultiCharts 2.1, NinjaTrader 6, OwnData 2.6, VantagePoint 184.108.40.206, other ...
Risk and Decision Analysis @Risk, Evolver, Decisiontools, Roy Kelly
FloorTrader Tools 8.3, AmiBroker 5.0, MultiCharts 2.1, NinjaTrader 6,
OwnData 2.6, VantagePoint 220.127.116.11, other ...
please send e-mail to : ola 'AT' mail 'DOT' gr , ola3 'AT' mailbox
'DOT' gr , ( please substitute 'AT' with '@' , and 'DOT' with '.' ) ,
RISK ANALYSIS with @RISK
@RISK 4.5.7 for Excel, Compatible with Excel 2007, ( Standard,
Porfessional, Industrial )
@RISK 4.5.6 Internat...Problem with XmlSerializer
When i make a call to
XmlSerializer xs = new XmlSerializer(System.Type.GetType("myobject"));
I get this error
Key cannot be null. Parameter name: key
what is the cause of this?
<firstname.lastname@example.org> schrieb im Newsbeitrag
> When i make a call to
> XmlSerializer xs = new XmlSerializer(System.Type.GetType("myobject"));
> I get this error
> Key cannot be null. Parameter name: key
> what is the cause of this?
Don't use a string...use an object
XmlSerializer xs = new XmlS...Dates
When using date formulas and displaying the Month in letters is there a way
to make the month letters be in ALL CAPS?
Not with formatting, but with a formula like
=UPPER(TEXT(TODAY(),"ddd mmmm dd yyyy"))
"Benjamin" <email@example.com> wrote in message
> When using date formulas and displaying the Month in letters is there a
> to make the month letters be in ALL CAPS?
...Problems with CString (Conversion from VC6 to VC2005)
I have converted a project from VC6.0 to VC2005 (MFC). Now I have a
compiling problem. Following error:
error C2079: 'myString' uses undefined class 'CString'.
CString should now be a template in place of a class.
By another project theres is a forward declaration of 'class CString'.
I get the following message:
error C2371: 'CString' : redefinition; different basic types
Thats an indication for the template, but what do I have to do to
compile my project again.
looks like a header file path issue. It seems that when you compi...set cell value and workbook Creation date
How can I set the value of a cell with the creation date of the workbook?
Each workbook is beaing created from a custom template.
Either through a macro or through a User-Defined-Function:
ActiveCell.Value = ActiveWorkbook.BuiltinDocumentProperties("Creation
Use this like
Function CD() As Variant
CD = Application.Caller.Parent.Parent.BuiltinDocumentProperties("Creation
MS Excel MVP
"William Hamilton" <william@NOthevirtualSPAM.PLEASEco.THANKSnz> wrote in
me...XmlDocument xsi: Problem
I've been looking through MSDN, books and googling for a couple hours but
haven't found the solution yet. I'm using CSharp in VS .NET 2003.
I'm trying to use XmlDocument to save XML files that are valid to a schema
I've developed. I want the root element to look like this:
I've tried several variations of XmlElement.SetAttribute() and "
XmlAttribute att = [XmlDocument].CreateAttribute() " The closest I'...Address space problems on IMC ( Exchange 5.5 )
We have several IMC's but we want emails from certain outside domains to use
a particular IMC, and not all of them, but have this IMC only process emails
for this domain ( it sends it all to a smart host )....
We have configured address space on all IMC for this outside domain, have
set the cost higher on all IMCs beside the preferred one, but it still seems
to only use the * address space. If we set the cost higher for the * address
space on that particular IMC, all emails for all domains including one
listed in the address space goes trough other IMC's...
If we set the * addr...Outlook 2000 Backup Add-In Problem
I'm having trouble with the Outlook 2000 Backup Add-In..
On clicking File/Backup and exiting Outlook I
get "Cannot copy Outlook. Access is denied, the source file may be in
I've done searches on Google and eliminated every possible process
that might possibly have a hold on Outlook.. Namely the Nokia
connection manager which syncs a Phone w/Outlook. No luck.
I eliminated every process Windows would allow me to kill. No luck.
I've rebooted without the Nokia Connection Wizard booted. (X-ed it
out in the registry on CurrentVersion/Run) No luck.
So Outlook wo...