Error on Inquiry/Sales/Transaction By Customer
Recently we upgraded to GP10 and we found an error just in one user, whe she
run inquiry/sales/transaction By customer option and lookup a customer she
got this error
"Cannot Insert the value NULL into column 'ORTXAMT', table
"temp.dbo.##....", column does not allow nulls. INSERT fails.[Microsoft][ODBC
SQL server Driver][SQLServer] cannot insert value NULL into co "
I have another user with the same security role and they do not have this
error , even with the sa the inquiry run ok.
I droped the user and created again and the error still persist.
Any help ...Filtering Error: "You Cancelled the Previous Operation"
I have a form that I've developed that shows data from all over my database,
grouping it all together and displaying it for the user's ease of use. There
are four status indicator columns on this form, each one either equal to
"Green", "Yellow", or "Red". At the bottom of each column is a drop-down
combo box I have added that allows the user to filter on a certain color, so
they can see what records have a certain status. They can search on "Green",
"Yellow", "Red", or "All", which removes all filtering.
...Can I set a filter on the source data for a pivot table
I want to exclude certain records from a pivot table... i.e.,
Only inlcude "B" records.
Can a pivot table be set up to filter?
You could add the Buy/Sell field to the page area of the pivot table,
and select B from the dropdown list there.
> I want to exclude certain records from a pivot table... i.e.,
> Buy/Sell Quantity
> B 5,000,000.00
> S 5,000,000.00
> B 1,000,000.00
> B 10,000,000.00
&...XP Windows Explorer slows down saving of Excel files
My customer has a problem which I can duplicate on our own network (Windows
XP Pro workstation and Windows 2000 Server). XP's Windows Explorer, if
opened/displaying the same network directory where the excel files resides,
will slow down the saving of the files significantly: from 30 seconds when
explorer is closed to 90 seconds when explorer is opened in that directory.
That time is for the saving of a huge Excel file (20 Megs). We would
probably not have noticed it with regular (small) files.
It is not a question of how the file is opened, either through Windows
Explorer or through Ex...Data import for custom entities
Hello I created a new entity (CRM 3.0) and i'd like to import a big amount of
data for this entity. Unfortunately the import wizard is useable for
accounts, contact, leads and campaign responses only. Have anyone an idea to
import data for custom entities?
Thanks a lot
If you can't find any other ways to import data to custom entities,
you probably will need to use Scribe or C360's import tool. Scribe
have a data migration license for 30 days for as little as $500 I
Hope this will help.
On Jul 30, 10:28 am, Gerd Gott...Purchase Order Error #3
The users are trying to get into the PO search to print off approved PO’s.
Every time they get to the area of bringing up the PO thier machines locks
up. We have checked and no one is in Dynamic’s entering PO’s at these time.
If they try to end the task Dynamics closes.
...Macros in Excel
I am trying to automate two function for multiple users of
a series of microsoft files. While running a macro to
create a new file for archiving specific data, I would
like the user to be able to assign a filename while
running the macro that creates the file. Is this possible?
If so, how?
Second, for the above mentioned file I would like to
create a macro the automatically launches the send to mail
recipient function, but allows the user to select the
recipients from a corporate mail list while running the
Any help would be greatly appreciated!
Take a look at Appl...Publisher 97 Startup Error
When I start up Publisher 97 recently, I have been getting a undialog.cpp
error. How do I stop this happening?
The only reference we can find to this error is in conjunction with ZoomText and how
it handles clipart.
Undialog.cpp Error Message
When inserting clipart into a Microsoft Office application with ZoomText running, the
Office app would display an "Undialog.cpp" error. This problem has been fixed in
My recommendation would be to re-install Publisher in safe mode. It is a programming
Compact your Gallery, righ...Referenced cell displays formula, not data
I downloaded a form template and linked it to my data; when I use the = sign
to insert my data into the template, some – though not all – cells display
the formula of the cell reference rather than the data that is actually
contained in the cell
Cell D10 in datasheet contains text; instead of displaying the text in the
template, it shows the following formula that is the reference address:
Press CNTRL + TILDE Key whch is available above the Left Tab Key.
Tilde key (`) or (~)
Remember to Click Yes, if this post helps!
...ESM gives error c1030af0
Recently I changed the IP address of my server, and ever
since I cannot view the properties of the public folders.
When I attempt to I get an error:
The operation failed due to an invalid format in the HTTP
request. Verify that the host header is correct for the
ID no: c1030af0
Exchange System Manager
I have already verified that IIS default web page IP has
also been changed to match the NIC's first (of two) IP
Make sure the web site in IIS that answers requests for Exchange can answer
requests via it's own host name. I ha...embedded object error (pdf file)
I have two new computers. Dell latitude laptop and dimension desktop. I
am converting an excel file to pdf format and trying to insert it as an
object in an excel file so people can double click on it and view it.
I used to do this with my old laptop (purchased new in 2004 Dell
It worked fine with that laptop.
I am taking an excel file and converting it to pdf format using a
program I purchased called personal converter. Then opening the other
file and clicking insert, object, create from file (and display as
icon). I get the following error on the laptop "cannot insert objec...Data Access Pages Data Source
I have several data access pages I created with tables as the source. The
tables are in Microsoft SQL Server 2005 Express. I have since created queries
and copied them into the database as a View. How do you change the data
source from the linked tables to the Views?
it's not good idea to uase data access pages - they are not supported in
latest Access versions.
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
> I have several data access pages I created with...How do I make a formula refer to given data even if I do a sort f.
I want to create a formula in a spreadsheet that refers to specific cells of
data. However, I also want to be able to sort my data but keep the formula
refering to the same information. IE, say I have a collumn of ten numbers.
I would like to be able to have a formula take the average of the first 5
listed. If I then did a sort function of these ten numbers that changes the
order of the numbers, I want my formula to have the same result because it is
still referencing the correct information.
...Referencing Data in a Pivot Table
I have created a pivot table which shows me total money spent in various accounting categories. I want to reference the sums this creates to subtract them from a total budget to give me a remaining total. Unfortunately, as the pivot table is updated, cell references change. This means that the total I used as say total spent on fuel may become total spent on salary.
Can anyone help?
You can use the GETPIVOTDATA function to extract data. Look in Excel's
help for information and examples for your version of Excel.
> I have created a pivot table which shows me total mon...Outlook Synchronization Error
I have a problem trying to synchronize offline folders
with the Exchange Server.
I have a Exchange 5.5 - SP 4 (running on window 2000) and
having problem with Outlook 2000(SR-1a) and 2002(SP2).
When synchronization is completed, a synchronization log
is created in the deleted folders as below.
12:12:00 Synchronizing Hierarchy
12:12:00 Synchronizing Favorites
12:12:00 Synchronizing Folder 'Inbox'
12:12:16 5 item(s) added to offline folder
12:12:16 Error synchronizing folder
12:12:16 The client operation failed.
12:12:16 Microsoft ...importing *.csv data into two columns
I have a data file that is delimited as comma separated
values: escentially one long row of comma separated
values. I need to import this long string into two
columns: read two comma separated fields and start
entering data into a new row and repeat. There are no
empty cells as column 1 always has a matching value in
column 2 for that particular row.
I would appreciate any help. Thank you.
> I have a data file that is delimited as comma separated
> values: ... I need to import this long string into two
> columns: ...
This looks like a job for Excel's ...Status on one sheet w/ data?
How do I setup a stats (sum, count or whatever) on the same page as
the data and yet able to sort the data at will? If I add a count, for
example, at the bottom of the data, and sort, the "count data" becomes
part of the sorting!! Is there a stats that can be setup like a page
footer thing? Sorry, I am not good at excel in this regard.
When you sort, select only the data and not the cells with the statistics ?
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
<email@example.com> wrote in message
news:1186399300.3...Error When Merging Two Records
When trying to merge the contents of two records, our users get an error:
"An error has occured. For more information, contact your system
Which is followed by an IE Script Error:
"'crmMergeForm' is undefined"
At first I thought it was a permissions issue, however every one of our
security roles has full rights on Merge in the Miscellaneous Privileges
section. This error even affects those with administrative rights. Any
suggestions? Thanks in advance.
I am also having this problem! Please help!
...error 1706 running Office 2000 in Windows XP Home
Program is loaded. No problem starting in administrator
log in. On a different user, starting Excel results in
error 1706, but after clicking OK, Excel starts. What's
The information in the following MSKB article may help:
OFF2000: Error Message: The Feature You Are Trying to Use Is on a
Network Resource That Is Unavailable
> Program is loaded. No problem starting in administrator
> log in. On a different user, starting Excel results in
> error 1706, but after clicking OK, Excel starts. ...Can't seem to read PDF files, keep getting a 1402 error message
Tried loading Adobe reader and keep getting a Error 1402 could not open key
message. Here is what the message looks like.
Have you tried completely Uninstalling it and re installing it?
Russell Grover - SBITS.Biz [SBS-MVP]
Microsoft Gold Certified Partner
Microsoft Certified Small Business Specialist
24hr SBS Remote Support - www.SBITS.Biz
Second Opinion $15 - www.PersonalITConsultant.com
Free Trial Microsoft Online Services - www.Microsoft-Online-Services.com
&q...Saving spreadsheet with a Macro (VB)
Hi all. I am trying to write some VBasic code within Excel to save to the
path as follows:
C:\Documents and Settings\USERNAME\My Documents
I know in windows world you would use %HOMEDRIVE%%HOMEPATH%My Documents, but
I can't figure out the proper use within VBasic
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Jon Arbuckle" <NOSPAM@Nospam.com> wrote in message
> Hi all. I am trying to write some VBas...error code "publisher cannot load files from a different version"
yes a popular error i know. but
no i do not have norton
basically the computer crashed, i had to reinstall everything, now previously made pub's on office 2k will no longer load on publisher 2k. or on another version of publisher 2k.
i looked into the files and they do say publisher 3 embedded in the codes.
i am at a loss as to what to do, i have hundreds of files , i havent checked them all of course
Do an installer cleanup,
Description of the Windows Installer CleanUp Utility
Mary Sauer MS MVP
http://office.microsoft.com/...msinm.exe application error
I have Outlook Express running under XP Home edition. I
keep getting a send receive error and when I close
Outlook I get the message msinm.exe application error
instruction 1x77f58d2c couldn't reference memory at
cliff <firstname.lastname@example.org> wrote:
> I have Outlook Express running under XP Home edition. I
> keep getting a send receive error and when I close
> Outlook I get the message msinm.exe application error
> instruction 1x77f58d2c couldn't reference memory at
> Any thoughts/
Ask in an Outlook Ex...Data Synchronization Error
When I go online with a few of my CRM For Outlook Clients I get a 'Data
I am then provided with three options:
1. Proceed with going online, but save the data changes offline for the next
time you synchronize.
2. Stay offline and try to fix the errors so all the data will synchronize
3. Finish going online and do not save the data changes made offline
Here are some error examples which appear next to each piece of offline data:
1. Invalid activity regarding object. It probably does not exist
2. the record you are requesting is currently unavailable
Any help ...query data
Hi. I am building an aviation database. I am want to create a flight
summary query that shows only
Date of Flight
However, my result is a line for each passenger - for example If there were
three passengers on one flight i am getting 3 lines with 3 x the miles and 3
x the hours. How do I return only one line per flight.
Also, I want to be able to show flight details with all passenger names for
each flight. Is a subreport the answer there?
Message posted via http://www.accessmonster.com
jefferysf via AccessMonster.com wr...