number rounding in MS Excel
This may have been answered many times.
In MS EXCEL is there a way that it calculates all numbers to 2 decimal
digit accuracy instead of the 15 digit default?
Thanks in advance for the answer.
You can set your decimal places in your cells as 2 and then check Precision
As Displayed on the Tools / Options / Calculation page. Be careful though,
it means what it says!!
"mahusain" <firstname.lastname@example.org> wrote in message
> This may have been answered many times.
> In MS EXCEL is ther...Business Portal Error-SQL server does not exist or access denied
We are running business portal 4.0 for one of our customer. It was running
correctly, however, they have changed the SQL server port (previously it was
set as default 1433). After that the business portal becomes very slow and
while creating a new request (purchase requisition) if we open the item pop
up; it is showing exception
"SQL Server does not exist or access denied...."
Can any body tell me how can I provide the new port number to business
portal connection to the database.
Thanks and Regards,
Thanks for using the newsgroups. I have a...Is Word in Office:Mac2008 the same as PC version?
Operating System: Mac OS X 10.4 (Tiger)
If I learn how to use Word, will I be able to use the Windows or PC Version if I need to in the future for a job?
The principles are largely the same; however, as of Office 2007
(Windows)/Office 2008 (Mac), there have been significant differences not
only as far as the interface is concerned, but also the functionality in
general. Word 2007 on Windows offers far more features than the Mac version,
and, depending on your needs, this is the version you should get. However,
to give you an adequate answer, we would need to kn...Access 2007 and Vista code problem
I am developing a database on a XP SP2 machine. On a form I have created
some buttons with event procedures that run 2 queries and open a form. I
sent the db to someone running Access 2007 on a Vista machine and nothing
happens when she clicks the buttons and there are no messages.
I know nothing about Vista so thanks in advance for any help.
Might be a reference problem, have them open the open a code window and
click tools references. See what says missing and tell them what should be
there, Add it and it should work. Duff
"Tim Reid" <TimReid@discussions.micr...Outlook 2007 Search always returns no matches
Any search I do in Outlook 2007's new search box returns no matches.
I watched the Indexing Status as it progressed, and now it says "Outlook has
finished indexing all of your items"
But, searching on anything, even the word "The" or "a" returns no results.
I'm searching all Outlook items. I'm on an Exchange Server via VPN.
Anyone have any suggestions?
I uninstalled Office and re-installed and the problem went away...
"Tom" <email@example.com> wrote in message
> Any search I do i...Office 2003 Service Pack 3--subsequent problems opening Publisher
I run Publisher 2003 on Windows XP. On June 13, I updated my system with
Office 2003 Service Pack 3 so that I could open Word documents with the file
ext docx. Subsequent to the Service Pack 3 installation, whenever I open a
Publisher file (which I created), I get the following message: "Publisher has
detected a problem in the file you are trying to open. If you are certain
that this file came from a trusted source and does not contain harmful
information, click OK." What is causing this and is there a way to stop this
Error message when you...Publisher 2007 frequently crashes
I'm having some difficulty with Publisher 2007. Whenever I try to open a
particular file, the program crashes. I get no error message, except that
Publisher needs to close. I've run Office Diagnostics (twice), with no
results. I can open other Publisher files. The file that I am trying to open
is an internal website for the company I work for. This file began acting
strangely a couple of weeks ago - it wouldn't insert a duplicate page for a
while, but I found a workaround, so I didn't worry about it. However, now I
think that it may be a part of a larger probl...Add PowerPoint 2007 to Office Basic
I have Office Basic installed on my laptop and need to add PowerPoint. What
is the most recommended, easiest and least expensive way to do this?
...Using Access 2003 on client to see Sharepoint 2007
Testing a Sharepoint environment and I can easily manipulate and run the
database from Access 2007, but when I try to use Access 2003 it wants me to
save the database to a location. The Access 2003 has the compatiblity pack,
but it seems to not work when I download it.
So the question is using Sharepoint 2007 and posting the Access 2007 format
to it, can a user go to the sharepoint site and use a 2003 Access database
that has the compatibility pack and open without having to download it?
Message posted via http://www.accessmonster.com
Send check for $500.00 to: David A Jenn...Outlook 2003 Out of Office Reminder RPC over HTTP
I have some remote office users that have Outlook 2003 configured
using RPC over HTTP. They do not get the notice that pops up
reminding them that their Out of Office is on when they open Outlook.
Is there a way to get this to work?
...running reports from MS CRM prompt for username and password
When running a report from Microsoft CRM client it prompts for username and
password. When given it's runs the report correct
question: if MS CRM 3 is configured correctly is it normal that when trying
to generate a report in MS CRM prompt for username and password?
No, ideally it should pass the users AD credentials to the reporting IIS
server (single sign on). If you were to close the browser and run a different
report does it still prompt for credentials?
I've noticed this does also depend on the hostname. For instance if the
reporting server uses a differe...Outlook 2007 Calendar -> Outlook 2003
In the past I could forward appointments and birthdays from one PC to
another, if both PC's had Office 2003. I just tried forwarding a birthday
from Outlook 2007 to Outlook 2003 and it doesn't work. I get the email in
2003. Open it, open the calendar item, then click on Save & Close. No
error message. But it's not there. Neither in the current month or for
next year. I forwarded it as a reoccurring item, that's the only way it
will let you do that.
Has anyone else been able to do this?
Or, is this a backward compatibility issue?
It's odd.... this works fine for...compact database in VBA access 2007
I have recently upgrade to office 2007 from office 2003. To compact a
database from within the database itself, I used the follwing code.
Unfortunately it no longer works in access 2007. Is there some similar code
that will work?
Public Function FncCompactTheCurrentDB()
CommandBars("Menu Bar"). _
Controls("Database utilities"). _
Controls("Compact and repair database..."). _
On Thu, 28 Jan 2010 17:34:01 -0800, SL <SL@discussions.microsoft....Creating Text Box in Publisher 2007 Crashes the Application
Hello, we have a clean install of Publisher 2007 under Windows XP SP2, and
when we try to create a text box in a document, (both an existing document
and a blank document), publisher crashes. Office is fully patched.
I ran Office Diagnostics from the help menu and no problems were found and
the issue persists. Any thoughts on how to resolve the issue?
See if selecting a different printer as default helps.
How to view error signatures if an Office program experiences a serious error
Mary Sauer MSFT MVP
http://of...Doesn't show busy,when scheduling meeting
I have a user, who has meetings scheduled and shows up in her Calendar fine.
But, when she or someone else tries to schedule new meeting, invite her, it
doesn't show her busy schedule.
It indicates as if she is available all time.
Secondly, when she edits the meeting and marks as "Out of Office", than it
shows up as busy.
Her Out of Office is Off.
Outlook 2000 with Exchange corporate setup.
Any help will be appreciated.
...MS Access 2007 code not running
I have created a brand new database in Access 2007 and linked some VB
code to run on Form_Load. This code worked perfect with no problems
the day I created it. Now today I opened the same form and it is not
running the Form_Load code anymore (and yes it is still there, I did
not delete it). I got frustrated so I copied and pasted the code to
Form_Current and several On_Change events and set breakpoints at the
beginning of all the events just to see if it was the Form_Load that
was not triggering, but NO events are triggering my VB code. Any
See this page:
http://accessjunkie.com/fa...MS Project 2007 question
I am developing a simple schedule with no resources but 2 tasks out of 100
are hazardous and I would like to make the schedule so that when these tasks
occur, no other tasks can occur. In other words, even though all tasks are
moving around as the schedule is being developed, I would like to make sure
no other tasks can be scheduled wherever these 2 hazardous tasks fall. These
2 tasks are serial to every other task in the schedule. Is there a way to do
Thanks for your help.
Create two milestones. Use milestone 1 as the successor task to all tasks
th...Office 2007 Templates & Themes
Is there anyway the content for Office 2007 at the MS Office web site
could be made available to Office:Mac users. Currently need to have OGA
validation via ActiveX control or from Office for Windows programs.
Surely Mac users could be given access!
We have asked that question. We don't have an answer yet (at least, it
wasn't "No", that would have been quick!).
They are trying to work out how to let us in without letting in all the
people using the competitor products.
I think they will set up a mirror on the MacTopia site that will allow us to
reach the ones tha...landed costs in MS RMS
Is there a standard functionality on handling landed costs (allocating
freight and other related costs to the value of goods purchased)? We've heard
that there's add-on that need to purchased in addition to RMS to support this
feature and so far we couldn't hear of someone who has used it.
Try contacting www.retailrealm.us directly for a reference on the Landed
"Kstylian" <Kstylian@discussions.microsoft.com> wrote in message
> Is there a standard functionality on handling landed ...MS Money '04 Reference Books
Is anyone aware of any good MS Money '04 reference
books? I've checked the MS Press website, but they seem
to have one for every software program other than Money.
Too many books ended up getting pulped--I'm not sure there are any for Money
anymore. You might check on http://www.amazon.com.
"Mike" <firstname.lastname@example.org> wrote in message
> Is anyone aware of any good MS Money '04 reference
> books? I've checked the MS Press website, but they seem
> to...MS CRM Security 05-26-04
I have 2 business units:
1. New Business Sales
2. Account Management (management of current customers)
I want to use the MS CRM security settings so that users in New
Business Sales cannot see any account records for our current
customers. This includes if the New Business Sales users select the
‘All Accounts’ view.
Is this possible with MS CRM?
Yes. When you assign access rights to the role, only give them "Business Unit"
access, they will only be able to see data within their BU.
------------------...Outlook 2007 PST files and temp files
When I have PST files on the server, I notice that there is a temp file
accompanying it when Outlook is loaded.
Would loading the temp file on the local PC make Outlook quicker, if so, how
can one do this...?
"TK" <email@example.com> wrote in message
> When I have PST files on the server, I notice that there is a temp file
> accompanying it when Outlook is loaded.
> Would loading the temp file on the local PC make Outlook quicker, if so, how
> can one do this...?
You shouldn...Setting in Outlook 2007
I have Outlook 2007 with all updates, how do I change the settings so
attachments, web addresses or inserted pictures are not removed
Thanks for any help
Attacments removed? - Uninstall your anti virus application
Web addresses - In internet options ensure outlook is set as default mail
"Daniel" <firstname.lastname@example.org> wrote in message
> I have Outlook 2007 with all updates, how do I change the settings so
> attachments, web addresses or inserted pictures are not removed...Exchange 2007 CCR after reseeding storage group copies
We have an Exchange 2007 CCR cluster that sits on two Windows Server
2008 Enterprise nodes. Due to problems with one node, I evicted it
from the cluster and rebuilt it, reinstalling Exchange using the
custom / install passive node setup. I used 'Update Storage Group
Copy' (with the option selected to 'Delete any existing log files in
the target path') to reseed the active databses. It seemed to go OK,
and the storage groups status in the Database Management window became
'healthy'. However, when I tried to move the clustered mailbox server
on to the new node f...Sending E-mails at a defined time with MS Exchange Server
We're using MS Exchange Server at the office.
We have around 150 e-mail accounts set up.
Some of our users are sending enourmous attachement (~100 Mega) and
sometimes to 50 different addresses.
During the day this is chewing up all our bandwith.
What we would like to know if it's possible in Exchange
to define that sort of rule :
- Send e-mails with an attachment bigger than 8 M�g only after 20h00 ? (so
they don't chew up the bandwith during the day as this has an impact on our
FTP transmission module and our client server applications)
Or maybe an add-on ?