DST Update Didn't Work
Hoping someone can assist with this problem.
Last week we ran the update for DST for Windows on all our XP workstations
and on the servers, including Exchange.
Then ran the update in particular to Exchange, I believe 926666.
Then ran the Outlook calendar update tool. All the calendars updated
succssfully and the log files were generated for each mailbox that updated.
This morning, the clocks on XP workstations and clocks on the 2003 server
are correct with the new time, however, all calendar appointments are 1 hour
behind where they should be.
Can anyone tell me if I did some...Install #2
I just installed GP10 on a users Windows 7 machine. I went through the process, then changed the dynamics.set file to report to the reports.dic file on the server as we are connecting to a remote server. When I open GP it says I must use utilities first. Fine, GP re-opens in utilities. Then it gives me the option to "Update modified forms and reports? which I do, it points to the local reports.dic, which is odd, but ok. when I click process it errors out saying "reports.dic: unable to open. Any ideas???
...Why can't I add rows or columns on my worksheet?
I am on line 28 of my worksheet and , all of a sudden, I keep getting a
message saying :...excel cannot shift nonblank cells off worksheet...I am new
to PC use, so please don't answer in computerese. Thanks
The root problem is that Excel believes that there is data in row 65536
and/or column IV, so that inserting rows or columns would move data off the
To stop this issue, highlight A1 and press Ctrl+End. Note where your cursor
ends up (we are presuming Z65000 for this demo, so adjust to where you end
up). now you look to see where your 'actual' data finishes. (again, we...send/receive settings #2
My co-worker and I are both having a problem with setting
the leave a copy on the server. We click the box for
saving and choose the amount of days to leave on the
server. Then when we close outlook and reopen it is gone.
The box is no longer checked to save email on the server.
What's happening?? Is there a fix for this problem?
...sent email #2
I am using outlook 2000 with XP and IE7.
When I send email it goes through the outbox and then to sent items
the people never receive it.
I am currently including myself in all outgoing email to check the problem.
> I am using outlook 2000 with XP and IE7.
> When I send email it goes through the outbox and then to sent items
> the people never receive it.
> Any suggestions?
> I am currently including myself in all outgoing email to check the
Do you get the mail?
Basically, once a messa...Changing case #2
Is there an easy way to change the case of a block of cells containing data
from lower case to upper case?
If you want to change the case of cell A1 to uppercase, use the following
"Peter Downes" <email@example.com> wrote in message
> Is there an easy way to change the case of a block of cells containing
> from lower case to upper case?
B1: =UPPER(A1) ---> ABC
C1: =PROPER(A1) ---> Abc
-------------------------------------------------------------...Save copy of active sheet
I use the code below to save a copy of my Workbook in a specific file
path (testing to see if the folders already exist along the way) with a
specific, data dependent file name. It works, but I'd like to tweak it
a bit and I'm not sure how to write the code.
I'd like to save only the active sheet instead of the whole workbook.
I'd also like to save only the values and formats to the new file, not
the formula and macros.
Anyone have any advice on how to accomplish this?
Here's my current code:
If Not Len(Dir("g:\users\one\" & Range("h6&..."Customize Outlook Today" button does not work.
My "Customize Outlook Today" button does not work or do
anything. I am using Outlook 2000. Can anyone help?
See the foolowing KB article;
Tips of the month:
-Create an Office XP CD slipstreamed with Service Pack 3
"Ricardo" <Ricardo993@comcast.net> wrote in message
> My "Customize Outlook Today" button does not work or do
> anything. I am using Outlook 2000. Can anyone help?...2 cash drawers, one closing ????
We have a POS computer with 2 cash drawers, since its two cashiers that works
the station at the same shift.
My question is, is there a way to have 2 closing? one per cash drawer /
cashiers? This sins since both cash drawers are in the same shift and both
start with a petty cash.
Whats the recommended way to work a shift with 2 cash drawers/cashiers and
to properly square off the shift?
...Locking a sheet??
Is there anyway to lock a sheet so it cannot be selected at all? I
will/can even accept hiding the sheet, but would prefer to have it just
locked so it cannot be selected. As always, thanks in advance.
mcr1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15496
View this thread: http://www.excelforum.com/showthread.php?threadid=499448
Just go up to tools->protection->protect sheet. Then protect it with
whatever password. Then after that you can go up to
Format-&g...Exchange 5.5 & W2k SP4 #2
Can anybody tell me if there are known problems between Exchange 5.5 sp4
and Windows2000 server sp4.
Runs just fine here. See
> Can anybody tell me if there are known problems between Exchange 5.5 sp4
> and Windows2000 server sp4.
Help fight spam - designate sending servers for your domain.
...Dynamic range #2
In C2:C65 I have dates as follows (DK standard):
indicating January 2001, February 2001, March 2001 and so on up to
01-04-06 (indicating April 2006) in cell C65. In about a fortnight new data will appear i C66: (01-05-06) and later on
I know how to create a dynamic range if I always had to start from the top, but here I want to be able to enter for example 01-01-05
in cell H1 and the dynamic range should now be, not from the top, but from the cell C51 (which holds 01-01-05) and as far down as I
(just now) have data.
I fou...CRM 3.0 Installation help...2 errors
Going through the system requirements part of the setup I get a Warning on
the IIS part. It cant access the URL-- Error accessing URL
http://IRONWOOD-CRM: The remote server returned an error: (500) Internal
The second error I get is :
Setup failed to validate specified Reporting Services Report Server
http://ironwood-crm/ReportServer. Error: Client found response content type
of 'text/html; charset=utf-8', but expected 'text/xml'.
1. Check your IIS and default CRM virtual directory is there issue accecing,
can you send me detail or s...Code working in 2K3, but not 2K7
I have a form with one unbound combo box. The On Open Event is set as follows:
Private Sub Form_Open(Cancel As Integer)
Works eveytime in Access 2K3 , but in 2K7 the form opens and the cursor is
blinking in the combo box. Any idea on why the combo box will not drop down
and display records? I have tried changing Overlapping Windows and Tabbed
Documents settings, but no difference. If I remove the code entirely, the
form opens and the combo box has the focus because it is the only object
available. Any help appreciated.
Try mov...Microsoft Excel #2
Why can't I close my Excel application by clicking the x button in the
upper right hand corner of the application. This is Excel 2002.
Is there a way to do this?
Message posted from http://www.ExcelForum.com/
Is the "x" button grayed out and unavailable?
Are using using Groupwise?
If that's the problem. See this MSKB article
Article is specific for 2000 but I think it is valid for other versions.
It gives a workaround (use the file menu) and instructions as to how to remove
the Groupwise add-i...Opportunity>Quote 'Mail Merge' Issue
Dear Forum Members:
When I add three 'different' products (Product A, Product B, Product C) to
an Opportunity and then try to Produce a Quote in Word (Mail Merge), I get
the 'same' product 3 times (Product A, Product A, Product A).
I think there may be an issue with the database fields I have placed in my
I see the problem, yet I still need advice on how to repair the Quote in Word.
The Mail Merge is creating 3 Quotes for 3 Recipients. For example, Quote #1
has has Product A three times, Quote # 2 has Product B three times, Quote # ...Drawing Graphs #2
I need to write an application that displays multiple
graphs on multiple tabbed sheets in a single window. The
graphs are all simple X-Y line graphs like you'd see on an
oscilloscope, but with labeled coordinates. I need
everything (including the fonts if possible) to scale as I
resize the window. I'm debating about using MFC or C#. Is
there some standard class or set of functions that
supports such graphs or do I need to write my own from the
ground up (or buy a 3rd party package)? We've already
done this in Java but I'd like to get rid of the Java and
r...DATA DUMP WARNING #2
Maybe the ultimate lesson in this is backup backup backup.
Do backups early and often.
and use a large cycle - don't write a backup onto the immediately previous
Microsoft MVP - Money
For UK tips & fixes see
For wishes or suggestions see
or for UK wishes http://www.microsoft.com/uk/support/money/feedback
I do not respond to any emails that I have not specifically asked for.
<DrWoodardOnDS@hotmail.com> wrote in message
news:11095315...Catalog Merge #11
I am trying to do a catalog merge in Publisher. 2003 I am using an excel 2003
spreadsheet as the source. I have 3 fields. Name, Description, and picture.
The picture field is a hyper link to the sample pictures file. I have tried
it as a hyper link and by inserting the actual picture. No matter what I do,
when I perform the catalog merge I can't get the pictures to show up as part
of the catalog. I insert the field as a picture and the other two as text. I
believe this to be the correct procedure. Am I missing a step? I appreciate
The way I do it is create a f...Combine Text from Multiple Cells
How do I combine text from mutliple cells into one cell?
one option - well two really:
if the information is in cells A1, B1 & C1 and you want it combined into D1
then in D1 type
=A1 & " " & B1 & " " & C1
this will give you the contents of each with a space between
=CONCATENATE(A1," ",B1," ",C1)
which will give you exactly the same thing
Hope this helps
"Carter" <firstname.lastname@example.org> wrote in message
> How do I combine tex...Tab orders
Is there any way to set the Tab order in a worksheet? I've got
spreadsheet where there's quite a few cells for the users to enter inf
into and others where I definately don't want them to enter or chang
any of the huge nested IF statements I've created.
1. Can I set the tab order so when the user opens up the spreadshee
(as a template) the cursor will be in the first cell, then they hit ta
and it moves to the next cell and so on, also I'd like to move from th
last cell within one sheet to the next cell in the next sheet.
2. Is there anyway to make sure t...Error message with CAPICOM 18.104.22.168 Not enough storage is available
I need some help.
With CAPICOM 22.214.171.124, when I try to store certificates from a smart card I use
Store := CoStore.Create;
Cert:=CreateComObject(CLASS_Certificate) as ICertificate2;
without any problem.
I have updated with CAPICOM 126.96.36.199, and the same code produces an error
message:"Not enough storage is available to complete this operation" when
I need use this library.
My os is Microsoft Windows XP Professional Version 2002. SP3.
My Internet e...I have MS Office XP Prof. & need System Office pack 2.0 or later
I just recently installed the Windows 7 Operating System on my computer. I
use Microsoft Office XP Professional as my office software. While editing a
document I received the following message: " The Office Assistant requires
Microsoft Agent 2.0 or later. This product is available on the Office System
Pack." Where can I get this?
The link to request a hotfix is here:
The full article is here:
&g...Org Chart:1 Manager 2 Sections
How do I divide two work sections of employees under one manager?
I tried arranging the first set of staff under a vertical alignment and
wrapping a team frame around them, but when I add positions to create the 2nd
team, they are aligned the same. If I arrange the employees horizontally,
members are randomly assigned to the left or right, breaking the team
...Why this code does not work?
Why this code does not work?
[Report] is a checkbox located in a Subform named:lbl_ScrapDB_subform
and [shift_combo] is a combobox located in Form named:WScrapForm
could you please help
Private Sub Report_Click()
If IsNull(Form!WScrapForm![shift_combo]) Then
MsgBox "You must Select the Shift where you work before report !",
vbCritical, "Warning, Shift not selected"
Report.Value = False
Report.Value = Value