Daylight Savings Time Changes
Does anyone know if the patch for Exchnage 2003 identified in KB926666 has
to also be applied to every server that is running the Exchange Tools (System
Thanks in advance
On Wed, 31 Jan 2007 10:24:03 -0800, Kerry
>Does anyone know if the patch for Exchnage 2003 identified in KB926666 has
>to also be applied to every server that is running the Exchange Tools (System
>Thanks in advance
Im all for consistency. If the patch isnt needed, it shouldnt install,
so I would at ...Underlying Connection was Closed when opening System Settings
I've seen a couple of threads on "Underlying Connection was Closed"
when opening System Settings. I just found a solution not mentioned in
those posts and thought I would add to the knowledge base.
System Settings requires a connection to Microsoft SQL Reporting Server
(SRS). If your SRS server is down or offline the above error will be
...Try Catch to Pinpoint Set-Based Error?
I have a fairly simple Merge statement with this:
When Not Matched Then Insert Values
... long column list ...
cast( crazyCol1 as decimal(16,8) ) / 1000000 )
, cast( crazyCol2 as decimal(16,8) ) / 1000000 )
cast( crazyCol2 as decimal(16,8) ) / 1000000 )
cast( crazyCol2 as decimal(16,8) ) / 1000000 )
The insert source is about 50,000 rows. One of the rows is failing the
cast (original source is varchar(36).
I would like to implement a try/catch block around this somehow so I
can catch the offending row.
How can I do that?
SnapDive (...Date on Template
I created some templates and am choosing to bring over a date to be shown in
the template when it is run. I have selected this attribute to be date only
and not date & time.
Every time I run the template it still shows date+time+time zone. Is there
a way to show only the date and not the rest of the data.
Thanks for any help anyone can provide.
...International Range style settings
I am using Excel 2007, the Ducth version.
I have created a workbook with macros, partly recorded.
In one of the I am using some code like
If .Value < gdblNormValue Then
.Style = "Ongeldig"
In the English version it shoul be
If .Value < gdblNormValue Then
.Style = "Bad"
Is there a constant I can ue instead of the text "Bad"?
Styles have both Name and Local name properties, so I *think* the English
name should work ...Outlook 2003 changing global auto archive settings?
Outlook offers to Run Auto Archive every days. It allows
you to run it more frequently, but I would like to run it
less frequently. In other words, I would like to run it
every 120 days and then archive the bottom four months.
It doesn't seem that you can change the auto archive setting
above 60 days. Is there a way to do this?
I have the box checked to ask me before auto archiving - but
if I say no, will it continue to ask? Or, will it never ask
Essentially I would like to archive every 4 months and not
more frequently - and I would like to archive my inbox and
my se...Calculate Dates with If Then Else Statements
I need to calculate total years’ full time experience (i.e. 2.5 years, 3.25
years, etc.) in an Access 2003 database form. This is what I am trying to
do: If the Full-Time End Date is Blank, use Today's Date, ELSE if the
Full-Time End Date has a Date, use that Date.
Separately, these two formulas work:
My problem is writing a statement to calculate using the END DATE if one is
entered, or NOW, if there is no end date. I have tried many combinations,
but can’t ge...Single set of folders in Navigation Pane?
In Outlook 2007, I have Exchange Server and 2 POP accounts. I would like all
of the messages from all of the accounts to display in the navigation pane in
the same folders and follow the same rules and alerts. Currently I have
Mailbox fro exchange and Personal folders for the 2 POP accounts.
Can someone help me out with this?
You can set your delivery location for each account in;
Tools-> Account Settings...-> tab Email
You'll have to decide if you want the default location to be a pst-file or
the Exchange mailbox. If you choose for a pst-file, all the d...Outlook locks up all the time
This is a shot in the dark. Ever since getting my new
Thinkpad with Windows XP, Outlook has never seemed to work
properly. I've run diagnostics on my machine and nothing
comes up as a problem. I've installed a spyware program
because after talking to IBM tech support, they suggested
I try that. I also talked to another support tech, who
suggested I reinstall Windows completely. I'm not a real
technical person. Won't a re-install wipe out my files?
Most of the time that I use Outlook for my email, it slows
down and eventually locks up. When I restart my computer,...Running macros for different cells at the same time
Is it possible to run different macros on different cells at the sam
time? If so how do I go about setting it up?
Message posted from http://www.ExcelForum.com
not really sure what you're trying to do. Could you give an example?
> Hi all,
> Is it possible to run different macros on different cells at the same
> time? If so how do I go about setting it up?
> Message posted from http://www.ExcelForum.com/
Yes it is possible to run different m...Filter Date
Hi, I have a form which contains a listbox (holding the values Process
Date and Quantity) and I have a textbox which displayed the current
month. What I want to do is when I click on a command button
(cmdMonthDown) and the textbox value changes from May to April I want
the values in the listbox to be filtered so that only those values are
disiplayed that were entered in April.
If I'm not making sense please let me know otherwise your help would
Reference the text box as a parameter in the list box's RowSourcee, e.g. if
the text box shows the month name in fu...Task start/end dates from MS project to Workspace site
We are currently running MSPS 2007 with WSS 3.0. I am trying to create a list in one of the project work spaces. I would like to auto-populate two columns in that list with the start and end date of certain tasks from the Project Plan in MS project. I am thinking we can do this by linking these columns to the the project SQL database fields. So,
1) Do I use the published SQL databse for this?
2) Which fields in the SQL database would I have to link to get the Start and End dates?
EggHeadCafe - Software Developer Portal of Choice
AutoList in ASP.Net
http://www.eggheadcafe.com/tutorial...Date Format when incoming date can be 0
I have a date fiels yyyymmdd which can have a value of 0 or a valid date in
Excel displays the 0 date as 01/01/1900 and the non zero dates as expected.
Cant figure this out , any help would be appreciated.
Excel uses a sequencial number from either 1/1/1900, or 1/1/1904 (depending
on your options) as the date value
for Example 6/3/2005 is 38506 using the 1/1/1900
if the cell is formatted as a date it is responding with the date it thinks
If you want the cell to display a zero
"DP NY10601" wrote:
> I have a date fiels y...I need help setting up my database
I used Access in the past, so I have a general idea on how to use it, but now
I have Microsoft 2007, so it's not as familiar. I currently have an excel
document with staff names and drills they have performed. The drills include
dates, times, an observer, and if they passed or failed. I had considered
doing something where I had a table with all my staff, and then connecting
tables for each person to list out the specifics for their drills. I don't
know how to link the relationship with that though because the table name was
the staff's name, so there wasn't a...how to calculate the substraction between two dates
i have two cells ,in which there are two dates.
(for instance ,one cel l 08/02 ,the other 07/30)
if the gap of the two dates is 2 days , something will be set to do.
but it is difficult to judge the the substraction between two dates
any good ideas.
Perhaps this might be of help ..
Assume the *dates* "2-Aug-2004" and "30-Jul-2004"
are input in A1 and B1, and
A1:B1 is custom formatted as: mm/dd
viz. it'll show as:
In A1: 08/02
In B1: 07/30
Try in C1: =DAY(ABS(A1-B1))-1
Format C1 as: General or Number
C1 will return: 2
i.e. the number of days...Date Range
When I want the date rage appeared on the report header, I use textbox and put
(qry criteria) in its recordsource. It works fine.
However, For this time, I got a message like this ‘First([Between [From this
date] And [To this date]])"
Is there something wrong with the qry criteria?
Would you please show me how to fix the problem?
It's very hard to understand the crtieria, can you post the full SQL
What is the First in the beginning?
Why there are to square brackes in the end And in the beinning?
First([Between [From this date] And [To this date]])"
T...How do I set up auto complete from a drop down list in Excel 2000.
I have a 10 sheet workbook that I will be sending out to various users around
the world. For their convenience, we are adding a lot of drop down lists for
them to choose from. However, since there are many options to choose from in
each list we would like for it to auto complete based on their initial
entries: Ed -> list to jump to Edinburgh, etc.... I have enabled the
AutoComplete in the cell values button in the Tools/Options/Edit tab, but it
is still not working. Any help on this matter would be greatly appreciated.
not possible for the data validation listboxes
--...Setting series values on Excel Chart
I'm struggling very hard in getting beyond this error when trying to use VB to generate a chart from data previously inserted into the sheet.
Unable to set the Values property of the Series class.
The code works absolutely fine in XL2007 but I am having to port it back to 2003 and the inference is that its empty values that cause it to hiccup - something I cannot avoid.
My code is:
1. Retrieve selected data from database and place it at the top of the sheet
2. Add The Chart
3. Iterate through the data (amount can be variable depending upon user inputs)
For j as i...Double emails when setting up new POP3
A long time problem I'd like to resolve is when setting up a new, or
resetting an user name and password for a POP3 mail account. In all
versions of outlook I have users who keep many months of email stored on the
mail server. I don't mind them keeping it there, but for some of these
people, when I setup a new logon name to the same mail account the Outlook
program is somehow reset and does not know that it already has months of
emails in its account. So, it goes ahead and downloads them all over again.
Well, I've used Duplicate Email remover that works nicely to remove t...How to set up a uato incremnt in sql server 5000 express
I'm trying to get into database programming. Cannot figure out how to
do a auto int for my key value in sql server express.
On 19-12-2009 19:40, tedpottel wrote:
> I'm trying to get into database programming. Cannot figure out how to
> do a auto int for my key value in sql server express.
Set IDENTITY on the field.
PS: This is a C# forum.
"tedpottel" <email@example.com> wrote in message
> I'm trying to get into database programming. Cannot figu...IE6 ignore font size setting = Outlook fixed 12-pt messages
Setting IE6's Accessibility option to Ignore font sizes
specified on web pages (so I can read online newspaper
text at my 1600x1200 resolution setting) produces an
undesirable side effect in my Outlook 2K-generated html-
format email messages: all message text is fixed at 12
point, even though my Outlook default message size is set
at 10 point. Manually changing the font size in the
message has no effect.
Closest KB article I can find is one for Outlook Express
(#178895), which indicates "this is by design." If so, why
would someone who wants to vary the font size displa...how excel calculates the major units on an axis when MajorUnitIsAuto property set to true #2
I need to know, how excel calculates the major units on an axis when
MajorUnitIsAuto property set to true.
We are porting an existing excel chart application to .net with help
of a third party tool for charting.
If MajorUnitIsAuto property set to true, excel automatically
calculates the major unit.Need to know what algorithm excel uses to
calculate the Major Units.
Thanks in advance,
Microsoft has posted an article which tells how the minimum and maximum
scale values are determined, in terms of this mysterious major unit, but I
have seen nothing about how this major unit is calcula...download the Credit Card transaction date not the the posting date
Then I download a statement from a Credit card and import it in to MS Money I
always get the Posting Date not the Transaction date.
Do I need another column in the register, help does not tell me how to do
Or is the only solution changing each entry by hand? ( that doesn't make
This credit card offers downloads in either QIF or spreadsheet.
In microsoft.public.money, riskymanr wrote:
>Then I download a statement from a Credit card and import it in to MS Money I
>always get the Posting Date not the Transaction date.
Do you mean you first enter the transactions by...How do I convert a time format to a double
I use a function to calculate the hours worked based on time
12:00pm to 4:00pm is 4.0 hours
when I get the number for hours worked it is in time format / .27398237 I
need the number 4 so that I can do my calculation. How do I convert it to a
Multiply with 24 and format as general
"DMB" <DMB@discussions.microsoft.com> wrote in message
> I use a function to calculate the hours worked based on time
> 12:00pm to 4:00pm is 4.0 hours
> when I get the number for hou...If Formula , Adding Days to a Date
I want to make a formula that calculate as following;
in Cell (B1) if the date in future the result will be [Enrolled], if not it
will be Cell (A1) + 730 Days
On Sat, 27 Mar 2010 02:14:01 -0700, Khalid A. Al-Otaibi
> A B
>I want to make a formula that calculate as following;
>in Cell (B1) if the date in future the result will be [Enrolled], if not it
>will be Cell (A1) + 730 Days
Try this formula in cell B1: