Outlook Web Access/IIS6
We use IIS6 just for OWA (Exchange 2003) every so often the ability to
access the OWA page stops, even if you go onto the server and localhost still
can't access page, the only way to respolve this is to restart the server?
(you can stop and start IIS services)
Any help much appreciated
- Any errors in the application event log?
- Is the http virtual server running?
- Does this happen for all mailboxes or particular mailbox(es)?
"Marka" &l...Offline post-callouts?
We're using a post-callout to add some business logic to the MS CRM,
but now we want that business logic available to the Outlook client
when working offline as well.
We've installed the COM+ component on a test client, and registered it
with CRM, and it gets called at the appropriate time, but it doesn't
work: the component blocks when trying to create a CRM object (e.g.
BizUser). An alternative would be to access the local MSDE datastore
directly, but we can't figure out how to do that (we always get
We're unable to find any docu...General Ledger - General Posting Journal
On the General Posting Journal Printed Report (print JE's), how do I add a
column on the printed report to show the Distribution Reference (next to the
Journal Transaction Transaction Audit Trail
Entry Type Reference Code
2,083 Standard Adj Aug Interest GLTRX0000318
Account Description **DISTRIBUTION REFERENCE** Debit Credit
000-1000-000 Interest Exp Book interest to actual xx
...Code Comment Web Report,
I have enabled VC++ XML comments in Visual Studio 2005. However, I do not
see the "Build Comment Web Pages" under the Tools file menu (which my book
says should be there--but the book was written for VS02). Did they get rid
of Build Comment Web Pages in VS05, or simply move it?
> I have enabled VC++ XML comments in Visual Studio 2005. However, I do not
> see the "Build Comment Web Pages" under the Tools file menu (which my book
> says should be there--but the book was written for VS02). Did they get rid
> of Build Comment Web Pages in VS05, or simply ...Form as Web Page
It has been many years since I used Access, but I would swear that I used to
be able to save/export the form as an HTML or at least make it look like a
webpage. I want to be able to open the form and add/modify records without
having access to (or even see) the tool bars, etc...
Yes you could save as a Data Access Page. Does not have all the
functionality of regular forms. Maybe this would help:
MS Access 2010 will be released in June and has the ability to build web
databases. Quite nice from what I have seen. The ...SP2 Post-Installation Problem
I have just updated our exchange server 2003 to SP2 and have now lost the
ability to send and receive any mail - either internally across the network,
Any e-mails sent from outlook clients simply reamin in the outbox and refuse
All services seem to be running ok.
Can anyone offer any help or pointers for which direction I need to look in ?
I guess you already tried reboot?
> I have just updated our exchange server 2003 to SP2 and have now lost the
> ability to send and receive any mail - either internally across the network,
> or ...Payroll Posting Accounts #5
v9.0 / SQL2000
When you have the payroll posting accounts set up, how does GP know where to
post transactions to, if only 2 of the 3 segments match? We have our
accounts set up according to the following examples:
ACCOUNTING > ACCOUNTING > SALARY
ACCOUNTING > ALL > SALARY
ALL > ACCOUNTING > ALL
ALL > ALL > ALL
Say if an employee had a transaction, and only the first 2 of the 3 segments
match (ACCOUNTING > ACCOUNTING) Where would GP post the transaction amounts ?
...Rename the worksheet
Is there a possibility to rename the worksheet without using the
mouse-rename procedure? I mean using the keyboard only???
praveen_khm's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30364
View this thread: http://www.excelforum.com/showthread.php?threadid=502191
Use Alt+O+H+R to rename the worksheet.
> Is there a possibility to rename the worksheet without using the
> mouse-rename procedure? I me...Change background / color of chart worksheet?
Need steps to change the color or backgound of the worksheet that is a chart.
Have multiple tabs in workbook that are just the charts. Only option for
background is to use Format-Sheet-Background. That changes background of
chart, but not the grey areas around the chart on the chart tab.
You need to select the Chart Area (what you call the, "grey areas around the
chart") and format that.
There are 2 separate, "parts" to a chart:-
1. The Plot Area (which you seem to have formatted OK) and the
2. Chart Area.
You need to select each of them to format th...Start a file at a defaulted worksheet/cell?
Having a few users to a file, can I have the file open to a default
worksheet/cell as I have directions I want them to read before playing...
Kevin, use something like this, put in thisworkbook code
Private Sub Workbook_Open()
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
"...copy data from one worksheet to identical sheet in different workbook
I want to essentially sync the data between 2 identical worksheets in
different workbooks. Essentially, I want to import and replace data in
the second sheet with data from the first, is there a simple way to do
this without deleting the worksheet and then copying the new sheet into
You can right-click on your source-sheetname tab,
the shortmenu will reflect Copy/MoveSheet....
Select it and make 2 other choices:
1) Check to Create Copy box at bottom
2) From dropdown box at top of screen
select an existing open workbook or select
"a...Populate customer through web services
I am trying to import a customer record through dynamics web services and
have the following questions:
1. How do I get the customer class information to default for the customer.
I am passing in the customer class and the class field populates on the
customer but the class information does not default. There is a behaviour on
the create customer but it is of type internal. If I change the behaviour on
the policy, the customer does not import at all.
2. How do I get the address on the customer card to be imported. I can get
the customer addresses to be imported into Great Plains but no...Emailing a Web Page from Outlook
I'm trying to email a web page from Outlook and when I select File,
Send, Page by Email, the Outlook Express is opens vs Outlook. I have
checked and under Tools, Internet Options, Programs, Outlook is
selected as the email program and when I click on an email link on a
web site Outook opens.
Any ideas why for emailing a page, OE opens vs Outlook.
try setting it to OE, apply, then reset it to Outlook.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http...System.Web.Services.Protocols.SoapException
Has anyone tried the Samples that come with the Webservices install?
Has anyone else received this error with the Samples or does anyone know
what is causing it?
"System.Web.Services.Protocols.SoapException: Server was unable to process
request. ---> An exception occurred that the exception subsystem was unable
to log. Consult your System Administrator.\r\n at
CustomerUpdate.WebServiceManager.GetAllCompanies() in C:\\Program
108\r\n at CustomerUpdate.Custom...test post
Testing my ability to Post.
...Display web chart in excel
I am trying to create a financial spread sheet and link a chart from ADVFN so
it shows up live in my spreadsheet. Havent got a clue how to make this work,
any ideas would be appreciated.
I may not be understanding what you're after...
(and I don't know what ADVFN is) but,
have you tried inserting a hyperlink from the menu?
Select which cell you want the link to show, then
Insert->Hyperlink... and complete the information
(link address, name, screen tip, etc)
Or are you looking for something more??
>I am trying to cre...Default Signatures using Outlook Web Access
Because I primarily access email via Outlook Web Access
(do not use desktop version of Outlook), I would like to
have new/reply messages in OWA default to use a standard
signature. I know how to set this up with the desktop
version of Outlook. I have also seen how a signature can
be picked if your desktop version of Outlook
is "configured and runnable" when you are using OWA.
However, can a standard signature be set up when only
Thanks, I would appreciate any help.
What version of Exchange are you using? Exchange 2003 OWA offers a default
signature. There are a...worksheet appearance
I create worksheets in VBA, then delete them again and create them
One worksheet always stays in my workbook, but when I create such a new
worksheet with add it appears the first in line. I want it to appear it
after the worksheet stat is always visible.
How can I solve this?
From XL/VBA Help:
> Add Method (Worksheets Collection)
> Creates a new worksheet. The new worksheet becomes the active sheet. Returns
> a Worksheet object.
> expression.Add(Before, After, Count, Type)
> expression Required. An expression that returns a Worksheets object....Searching a Differnt worksheet in the same workbook.
So what I need to do is have a colum D that searches Sheet1, column E
for a certain text string entered in a different sheet (either 2 or 3)
column D. If they match I want the cell in column E, sheet 2 or 3 to
return a text of "Found" and if there is no match I want the cell to be
I've been looking in these forums and have a feeling it can be done, I
just can't figure out how.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
Dear Cre...vlookup help linking data between worksheet
I have a master list of students (about 200+ )in one worksheet. On the
succeeding worksheets are the attendance for seminars. We have more than 20
seminars in a year. Because of the large no of attendees per seminar, I
usually type out a list of the students who came for each seminar, so there
will be 20 +attendance worksheets.
Not all students will come every time and there are new ones for each session.
To update on master list, I will sort each sheet by surname, print it out and
type in separate column (date) for each session and typed "P" for present
and &quo...CRM Web links appear to be broken
I am able to open the home page and move throught the interface. The issue I
I open "HOME" and then move throught the website, I hit errors when trying
to return to "home" and other links. Errors occur 95% of the time. The
error shows as a permission problem, but if I continue to navigate through
the site I eventually get to home. I have a new server and just installed MS
SBS 2003 with CRM 1.2. I am also unable to load the Outlook client -->
during installation, the host computer is unble to locate the CRM server -->
the same server I am have web li...Excel VBA
Is there any way to freeze (prevent) a number of worksheets from
recalculating when a VBA macro is running?
I have a spreadsheet with about 10 worksheets, most of which are linked
to each other in some way. One of my macros only needs to use the
formulas (and related results) from about 7 of these, so the other 3
are updating all the time but since the results from these are not
needed then they are slowing down my code.
Is there some VBA function for temporarily disabling a worksheets
calculation function? I would need my code to look something like
...Excel macro for copying range to another worksheet
On a monthly basis, I would like to copy the completed range (varies
from month to month) of a database (Sheet1) to a master list (Sheet3).
Once the data has been copied I intend to manually delete the entries
of Sheet1 and start anew for the new month =96 for eventual transfer to
The idea is to copy each month=92s data at the bottom of the previous
I followed Excel=92s record macro command but the macro I ended up with
is not capable of placing the new data at the bottom of the existing
one; it simply keeps overwriting the previous entry.
Unfortunately, I don=92t...Linking items GREATER THAN O on another worksheet in the same Work
I have a workbook that has about four worksheets …
I want to create a list of items that will automatically be included on
worksheet tab 4 from Worksheet tab 1 if the quantity for the item listed on
the first worksheet has been changed from 0 to any other number (i.e. 1 or 10
I have a list of equipment with pricing on worksheet tab 1 and the list is
long. Many of the items will have quantities of zero and will not increase as
they will not be selected for the project being created. We have additional
columns for cost, extended cost, labor hours etc. If the quantity changes for
Hello basically I would, each time i open my spreadsheet model for the
worksheet i wont to pop up, and from there i can navigate easily to the
other worksheets by buttons, how can i make a worksheet to pop up like
this everytime i open the file....?
Neo1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30329
View this thread: http://www.excelforum.com/showthread.php?threadid=515098
Private Sub Workbook_Open()