I downloaded exmerge this morning. When I try to run it to play around with
it, I get this message "This application has failed to start because
EXCHMEM.dll was not found. Re-installing the application may fix this
problem." I searched and found the .dll file on the machine. I do not want
to re-install Exchange 2003. Can anyone shed some light on this? Thanks in
Copy all the Exmerge files to the exchsrvr\bin directory.
"J. Huber" <jimh@great!harvest.com> wrote in me...Formula Error #2
mod(12,2.4) will not return a zero value
This is simple roundoff error. If it is not acceptable then use:
Gary''s Student - gsnu2007k
> mod(12,2.4) will not return a zero value
Try =ROUND(mod(12,2.4),10) or nay number of decimals less than 15
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
<email@example.com> wrote in message
> mod(12,2.4) will not return a zero value
...Error when saving workbook
We have a user where I work who has Excel 2003 on her computer.
She is complaining that on certain excel documents which she has used
in the past that when she goes to save them after making changes, she
gets the error message:
"This file was created using a later version of Excel. There is a
remote possibility that certain workbook properties specific to the
later version may be lost if you save the file in this version. If
you want to preserve the original file, click Cancel, then rename the
new version using the save as command."
If she clicks the OK button and saves the f...Switching to MFC in shared DLL brings runtime error
My Visual Studio 2005 solution is composed by many projects: an exe,
some dynamic dlls and some static libs.
All of them use MFC in a static library and I need to switch to MFC in
a shared DLL.
The compilation is fine but when I debug the application I got the
"Debugger: An unhandled non-continuable exception was thrown during
No more hints, and it is not possible to execute any piece of code.
I then analyzed my exe files with Dependency Walker to see if there
are errors while loading dlls.
I find out that in two of my dynamic dlls some function (but no...Any way to convert column of numbers from positive to negative?
Is there any way to convert a column of numbers that are positive to be
negative? We create a text file from our general ledger program that has all
the transactions for the past year, then import that file into Excel. We use
the text to columns to convert the text file to a usable format where the debits
are in one column and the credits in another. The problem is that all the
numbers are shown as positive so when we net various figures the amount is not
correct. Here's an example:
...Outlook error #60
Keep getting this error mesage
"Outlook could not create the temp file. Check the temp environment variable"
any idea how i can fix it
Outlook error <Outlook firstname.lastname@example.org> wrote:
> Keep getting this error mesage
> "Outlook could not create the temp file. Check the temp environment
> variable" any idea how i can fix it
What are the values for the %temp% and %tmp% environment variables?
Brian Tillman [MVP-Outlook]
...How to generate conditional pop-up error message?
I have a moderately complex sheet with a lot of cells where the user
(usually me) can enter data. I would like to add checks to certain
cells and generate a pop-up warning message if there is an error.
The pop-up would be like a Comment or an Input Message, except that it
would appear if a test failed, rather than when hovering over the cell
or selecting it.
Have a look at Data | Data Validation in Help
Then come back with more questions
Example, you have arrange that a cell can have only values "cat" or "dog",
and that a message (the text of which you get to decide) po...error adding new schema field 05-24-04
When I attempt to add a new schema field to an account in the
Deployment Manager, I get the following error:
"An error occured during the addition of the new field. The addition
In the event log, there were 2 entries:
"dmlog:sp_repladdcolumn failed-timeout expired"
"dmlog:failed to add new integer attribute (CFInumberofpcs) to Account
Anyone got any ideas how to resolve this?
Try the following recommendation from the Microsoft website
When you create a new schema field in Microsoft® Business Solutions CRM (Microsoft CRM) Deplo...NEED HELP:Soap error: operation requested in the Soap message with soapAction isn't defined in the WSDL file.
Hi all, I need some help. We have an application which is using SOAP to
relay messages between two applications. We are having a problem, which
started to only occur intermittently, but now happens all of the time.
When communicating between the apps, we receive this message...
Soap error: The operation requested in the Soap message with soapAction
defined in the WSDL file. This may be because it is in the wrong namespace
or has incorrect case.
The SOAP sender application is a VB6 COM dll hosted in a...MS query and corrupt data
I Use Msquery to get data from an Oracle view and get it directly into a excelsheet.
In this view the results contains charakters like a degree character. (for degree celcius)
When i look at the ms query results then the data is correct but when it is tranported to an excelsheet the the degreesign is corrupt. On an machine i get an �0�.. o another machine i get an black box with an questionmark in it.
Does anyone knows what to do on that. I use excel XP
Please help me if you know the reason
--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made...Error Serializing a Wrapped SortedList
This is a multi-part message in MIME format.
I'm using VB.NET 2002 on Windows 2000 Pro and am having trouble =
serializing a SortedList.
This is my class:
<Serializable()> Public Class clsGoodFiles
Public Sub New()
This is my calling code:
Dim xw As New Xml.XmlTextWriter(Path.Combine(Application.StartupPath, =
"GoodFiles.xml"), System.T...Business Closure error after upgrade
Anyone with a solution to this onne ?
Exception of type 'System.Web.HttpUnhandledException' was thrown.
[ArgumentException: Cannot load resource that matches
Parameter name: name]
Microsoft.Crm.Application.ResourceManager.BasicResourceManager.GetCultureString(String name, CultureInfo culture)
node,...Editing MS Query
I am having a problem editing queries created in MS Query. I create the
queries without any problems, and am able to add criteria and bring the query
into Excel. But when I want to edit the query, I get the SQL box that pops
up, and it is not easy to edit.
Thank you in advance.
...Passing an argument from a query to a command
I am trying to send a report using an email address in a DB. I wrote the
following code for it.
Private Sub Reminder_Letter_Command_Click()
On Error GoTo Err_Reminder_Letter_Command_Click
Dim stDocName As String
Dim SendTO As String
stDocName = "BG Reminder Letter"
MsgBox "This is After RunQuery " & SendTO
SendTO = [Queries]![BG email only from email from ae code].EmailAddress
MsgBox "This is SendTO 2 Value ==== " & SendTO
DoCmd.OpenReport stDocName, acViewNormal
DoCmd.SendObject acSend...How to convert AVCHD M2TS/MTS to iPad on Mac
"I have a Sony HDR-SR5, or some other AVCHD camcorders such as Canon HF11, JVC GZ-HD10, Panasonic HDC-SD5, etc, but I failed to import the video files copied from my camcorder in the format of .mts or .m2ts for playback on my new iPad, is there anyone can give me some suggestions, I'm using Mac Snow Leopard."
Well, firstly I should tell you that most portable devices cannot read .mts or .m2ts files directly, if you want to play them on your mobile devices like iPad, iPhone, etc. without trouble, you have to convert them into their acceptable format like MP4 vid...How do this tricky query?
I have 2 tables, a CASE table and an INVESTIGATOR table.
This is a one-to many relationship. Each Investigator has an Assign Date and
a Completion Date.
There may be zero, one or many investigators per case but only one at a time.
Completion dates could be missing:
Investigator1 Assigned 12/10/09 Completed 12/10/09
Investigator2 Assigned 12/10/09 Completed null
Assigned dates could be the same e.g.
Investigator1 Assigned 12/10/09 Completed 12/10/09
Investigator2 Assigned 12/10/09 Completed 12/11/09
Or, different e.g.
Investigator1 Assigned 12/10/09 Completed 12/11/09
...Error 1920 during CRM install
I would like to set up a CRM to try it. I have 2 W2K3 hungarian servers. One
Domain controller with Exchange 2000 and one SQL 2000 server. I have
installed these as the installation manual says.
I have set the local to English (US). I start CRM install and I get the
"Error 1920 Service Crystal Cache Server (CacheServer) failed to start.
Verify that you have sufficient privileges to start system services".
If I choose Ignore, I get this message every Crystal services. I am logged
in as domain administartor.
What have I done incorrectly?
Hi - did you every find out how...No Current Record error
I have a form with a subform on it. When I open the form with the acFormAdd
option (to add a new record) I get the error "No Current Record" on the
which is in the load event of a subform on the form.
are in my subform so the "Item n of n Items" label box will show the correct
number of items.
How can I avoid this error message?
When you open a form in add mode, it does not load any records.
Consequently, the instruction to move to the ...Nested query with combined key
I am working on an existing database that has three tables, no option
to change the database structure, but have to work on it.
CREATE TABLE Building (
b_id INT PRIMARY KEY,
CREATE TABLE Door(
d_id INT PRIMARY KEY,
d_BuildingID int references Building(b_id));
CREATE TABLE History (
h_key char(40) PRIMARY KEY,
transaction_time DATETIME PRIMARY KEY);
The h_hey in the History is actually d_id + "-" + d_key, now I need to
join three tables, get the building, door and associated last
How can I convert 1m38.15s or 0m58.98s into seconds in decimals ie:98.15 or
58.98. I've tried formatting the column next to the data "ss.00" but it does
Any help would be appreciated.
"Dave" <Dave@discussions.microsoft.com> wrote in message
> How can I convert 1m38.15s or 0m58.98s into seconds in decimals ie:98.15
> 58.98. I've trie...12.2.3 Updater errors every time.
Auto Updater reminds me every time I run an Office app that I need to
update to the CRITICAL 12.2.3 update of Office 2008 (12.2.1) on my
Intel Power Book running up-to-date OS 10.6.2.
EVERY time it tries to download it again, EVERY time it starts the
install, then EVERY time it errors out saying :
"The Installation Failed. The Installer encountered an error that
caused the installation to fail. Contact the software manufacturer
It goes through the progress bar saying Writing files, then switches
to Running Package Script - at which point the progress b...Another tricky selection query
could not resist re-using the title of a previous question as I was just
trying to scratch my head on how to name my question.
I need a query in which the data from the previous record is referenced. to
make things simpler, here is the situation. I have a simple table that
contains 2 columns, first column contains name of an event and the second
column contains the date. There ARE NO DUPLICATE dates.
The date is the end date for the event. The start date for the event is
from the day that follows the end date of the previous event.
What I need:
A query that generates a listing...Excel exception error
I keep receiving the following error when I try to print
an Excel report:
Excell caused an exception 10H in module EXCEL.EXE @
Can you help me to fix this problem?
Thanks so much
That sounds like a printer driver conflict, try downloading the latest from
the manufacturers website, is it a Kyocera?
"Becky A" <email@example.com> wrote in message
> I keep receiving the following error when I try to print
> an Excel report:
> Excell caused an exception 10H in module EXCEL.EXE @
>...PST Backup: Error Copying file
Each time I try to backup Outlook 2000 files I get this message:
"Cannot copy mailbox: The process cannot access the file because another
process has locked a portion of the file."
Anybody have a clue how I can fix this problem
Not until you tell us how you are trying to back up the file.
You must make sure Outlook is closed completely before you try.
"Marty" <firstname.lastname@example.org> wrote in message
> Each time I try to backup Outlook 2000 files I get this message:
> "Cannot copy mail...Licensing errors on Small Business Server 2003
My SBS 2003 server just started reporting almost continuous pop-up errors
with the message: "Warning: License usage for a product licensed in per
server mode has exceeded the maximum number of licenses purchased and will
prohibit further licenses from being granted. Consult the Application event
log or Licensing from the Administrative Tools folder for more information."
While these errors were popping up, all users on the network were unable to
access any resources on the server.
This seems like a straightforward message except that the server has 25