duplicate value error message
After successfully running a database for 2 years, suddenly as of 1/20/2010,
I get the following error message after data input into a form, "The changes
you requested to the table were not successful because they would create
duplicate values in the index, primary key, or relationship. Change the data
in the field or fields that contain duplicate data, remove the index, or
redefine the index to permit duplicate entries".
I am inputing about 13 values into a form that feeds a master table. The
table can have duplicate values, but NOT within the same date and shift
inp...Re: Exchange 5.5 mailbox issues
Any ideas for the below pls.
We are currently using a exchange 5.5 server and some of
our clients are not getting all emails sent. Its been when 3 or 4
external users send them email but they dont get it and the external senders
an NDR. The NDR sent to the senders refers to the exceeding storage
"Remote host said:552 requested mail action aborted:exceeded storage
The users is not over the storage limit, as we individually set large limits
for them. It only happens occassionally it could be more than the 4
senders, as its difficult to
monitor. And ...Printing issue
I have a question, and I would appreciate any tips on the most
efficient way to accomplish my task. I have a worksheet that has 3
pages of data when I print currently. The data is 2 narrow columns on
each page. I would like to take the data from each page, and put it
all on one page side by side ONLY FOR PRINTING purposes. I still want
the user to be able to look at the data as is, but I want the printing
to display the data on one page, with the columns from each page side
by side. I am thinking of copying and pasting the data on pages 2 and
3 to page 1 and then removing it ... but that...Reconnection issue between Winsock Server(VB6) and TCP Client (VB.NET)
I have a program (Winsock Server) written with VB6 which is connected
by a TCP Client (written in VB.NET).
The developer who writes the TCP Client told me that the TCP Client
can't reconnect to my Program (Winsock Server) after TCP Client
crashes or restarts. It can only reconnect to my program after my
I did the same testing with a simple Winsock Client i wrote and
everything works fine.
What i notice is that when TCP Client tries to reconnect, Winsock
ConnectionRequest event is not being fired anymore.
Having no working knowledge about VB.NET, ple...Line Spacing
I hit enter to create a new line but it insists on being double-spaced, even
though the text I'm working with is single-spaced. How do I change this?
Format - Paragraph
MVP Microsoft [Publisher]
"LindaE" <LindaE@discussions.microsoft.com> wrote in message
>I hit enter to create a new line but it insists on being double-spaced,
> though the text I'm working with is single-spaced. How do I change this?
> I hit enter to create a new line but it insist...superscript
I am trying to design a formula that concatenates in cell A3 th
content of cells A1 and A2 together, and by displaying the content o
cell A2 in superscript. This has to be done through a formula, as
want it to be dynamic, and be able to copy elsewhere in the worksheet.
A1 = CAR
A2 = (blue)
A3 should return CAR(blue), but the "(blue)" must be superscript.
P.S. I know this could be done by creating a custom function (usin
VB), but I would prefer doing it using standard Excel functions
Message posted from http://www.ExcelForum.com
It can't be done with either built-i...GL Purge
We did a Purge of our GL in Great Plains 10 (got rid of 1992 - 2006). Our
database was 40gb to start. The issue is that the purge did not free up any
space. So I ran a SHRINKDATABASE.
DBCC SHRINKDATABASE (N'xxxx', 0,TRUNCATEONLY)
This made our log file go from 4gb to 118mb, didn't change the size of the db
DBCC SHRINKDATABASE (xxxx, 10)
This made our log file go stay @ 118mb and size of the db went down by 3.5gb
DBCC SHRINKDATABASE (xxxx, 20)
It wouldn't run this as it reported there wasn't enough free
So I ran
DBCC SHRINKDATABASE (xxxx, 10) again
an...XP Pro Login Issue
I have a Windows XP Pro computer that I think has been hit with a virus. It
is not part of a domain currently. I have 2 accounts on the computer
(Administrator and Joe) and when I try and log on to either one it appears
to start the login then goes right to saving settings and logging out. I
even tried to do this in Safe mode so I could run a MalwareBytes but no go.
If I can't log in then I can't run Malware Bytes.
"Richard K" <email@example.com> wrote in message
We have recently setup an Exchange 2003 Server into our
network. We moved acrossed mailboxes and started
replication of the Public Folders from our old Exchange
2000 server. This seemed to work at first, but has now
The Exchange 2003 server is replicating fine to the
Exchang 2000 one: I created a new fodler on the Exchnage
2003 box and this soon appeared in the Public Folder list
on the Exchange 2000 box. Replikction however does not
occur the other way.
I have increased the diagnostic logging for replication
but this is not showing any errors. I also examined
mess...The space between to pages
I have a Chart report that shows in two pages. Is there a way that I can
remove the space between them so that the chart is shown perfectly?
...Printing issue in Excel Sheet
When ever i am giving a print job, it is printing page with my name as a
cover page for the print job. If i give a single page as 5 copies, it is
printing 5 cover pages. It it is 50, it is giving 50 cover pages where i am
not able to remove this settings. Please give me some idea about this.
Thanks & Regards
> Hi Friends,
> When ever i am giving a print job, it is printing page with my name as a
> cover page for the print job. If i give a single page as 5 copies, it is
> printing 5 cover pages. It it is 50, i...Performance issues with XMLTextReader
I need to parse a lot of html-files from wikipedia, and I need to do it
as fast as possible. So I started a little testing with XMLTextReader,
but the results I get confuse me. It seems that the Reader ALWAYS needs
about 1 second for the first textReader.Read()
Here's my testcode:
XmlTextReader _myReader = new XmlTextReader(textBox1.Text);
DateTime _firstRead = DateTime.MinValue;
DateTime _start = DateTime.Now;
_firstRead = DateTime.Now;
MessageBox.Show("FirstRead: " + Convert.ToString(_firstRead - _start) +
"...line spacing w/in a text box
I'm having difficulty with line spacing within a
textbox. I go to the Format menu and click line spacing
and even if I adjust between lines and before & after
paragraphs I still have way too much space between the
lines. I'm designing a business card and am having to
use a separate text box for each line on the card. I'd
like to have just one text box for everytthing on the
card. Can anybody help? THANKS!
> I'm having difficulty with line spacing within a
> textbox. I go to the Format menu and click line spacing
> and even if I adjust...EXCEL can't sum cell with SPACE " "
I have imported data from some text file to do sum in EXCEL, as it is
always easy to SUM with EXCEL.
But here I surprise EXCEL can't do that simple sum,
B4 has value "339 " in cell seen as 339
B5 has value "2079 " in cell seen as 2079
Now i tried with =SUM(B4:B5), yield 0.000
I have checked what's wrong with in base cell, found excess space" �
after last digit.
I have billions of data to sum; I can't remove that space manually.
i am attaching that file for your ref.
i have also tried with TRIM() function but that also didn't work
Any function o...how do I take off the double spacing in publisher
how do I take off the double spacing in publisher
High-light your text, format menu, paragraph
Mary Sauer MSFT MVP
"gb" <firstname.lastname@example.org> wrote in message
> how do I take off the double spacing in publisher
...Text issue on export
I have a field in access that does calcuations. When I export data along with
this field into excel the exported data is set as text, I need it to be a
value, how can I correct this in access before it hits excel?
That could mean that the calculations you do are written in a text field. How
do you export to Excel? If it via a query you could try placing:
Val([calculation]) in your queryfield, where calculation is the field with
the calculations in it. If you store it in a table (which you shouldn't with
calculations) you should set the datatype to numeric or double...
Maurice A...Superscript #2
Is it possible to show supersript in a text entry in excel for example the
symbol for H2O or Cubic metres - m3??
Type H20 in cell
With mouse, select the 2
Use Format|Cell and open Font tab
Click in the subscript box
Similar steps work for m3. But for squared and cubed you can also:
A)Type m; hold ALT and type 179 on numeric keypad to get m^3.
B) Type cm; hold ALT type 0178 om numeric keypad to get cm^2
remove CAPS in e-mail address
"MGT" <email@example.com> wrote in message
news:firstname.lastname@example.org...Rollup 1 issue
Since installing the RollUp1 for CRM 3.0, Laptop client users get errors
like "Failed move data for entity 'Contact'" on synchronising (going
Offline). I've looked at the KB and there's nothing listed there
Any solutions out there?
There is a client version of the roll-up Im sure you installed but have to
> Since installing the RollUp1 for CRM 3.0, Laptop client users get errors
> like "Failed move data for entity 'Contact'" on synchronising (going
> Offline). I've looked at the...Outlook Format and line spacing.
I write a message/letter on HTML format single line
spacing, and when the Reply comes back to my Inbox my
original message is in double line spacing.
Even when I write a "test" letter to myself, again in HTML
single line space, the letter appears in my "In box" in
double line spacing.
How can we cure this?
...CRM 3.0 installation issue with sql 2005
HI, any help would be great please.
Single instance of SQL 2005 upgraded from SQL2000 sp3. When trying to
install CRM 3.0, I get to the end of the installation check and receive:
""The minimum required version is SQL Server 2000 SP4 (8.0.2026)."" Now, I
am runnig SQL 2005, all services are running, event viewer is clear of SQL or
CRM errors. I am at a loss as to why the CRM installation does not see my
SQL 2005 installation and indeed reporting that I need SQL 2000 SP4 at
least!? Any ideas as to what may be causing this please?!
...remove white space without changing plot size
Now I know the white space can be removed by draging plot area but without
changing the size of plot I like to remove the white space. Is that
Not impossible, but it is hard to maintain the plot area size. You have
to first make the outer chart area rectangle as small as you need, then
make the plot area as large as you need. You'll probably have to cycle
through resizing of the two rectangles a few times.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> Now I know t...superscript
Is there any way to add a superscript to a cell that has a
formula in it? Thanks.
Basically no.. There are some workarounds.
I would use a help cell and make it small and insert
superscript there. Assume the formula is in A2,
create a new B2, left align the value and enter the
superscript. Assume you want superscript 2
Hold down alt while typing 0178 on the numpad,
release the alt key..
>Is there any way to add a superscript to a cell that has
>formula in it? Thanks.
In general No but what is the formula?
Bernar...Adding spaces between numbers in a cell that contains a full address
3-764 Neighbourhood Cir
39 Frostbite Lane
3938 Stardust Drive
4 Jones Lane
I have a spreadsheet that contains addresses in a column such as the
ones above. What I need to do is separate the numbers in the addresses
in one of two ways. Either would be ok.
The first is (and better for me) would be so that the number portion of
the address would have spaces between every number, and then the rest
of the addresses in the same cell. For example, "3-764 Neighbourhood
Cir", would become "3 - 7 6 4 Neighbourhood Cir". The second would be
to split the num...Performance Issues with initial connection to server
I am having performance issues with connecting to our project server. Each
time I open the main page for the first time, there is a large lag while the
page displays. This also happened in our test environment, but I assumed it
was because we were running the application and database on the same server,
but since reinstalling and distributing across separate server the lag still
The servers exceed the published specs for the PS. Any ideas what could be
causing the slow initial connection?
In our case, this was due to the IIS cache getting empt...Superscripts
Can you superscript only some of the numbers in a cell? I am using Excel
You can if the *numbers* are text so either pre-format the cell as text of
precede it with an apostrophe
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace@mailinator.com with @tiscali.co.uk
"Mark Hatfield" <@> wrote in message
> Can you superscript only some of the numbers in a cell? I am using Excel
You seem to be able ...