Comparing and Deleting rows
I have two spreadsheets.
One is like this:
The other is like this:
Computer | Last Used[
The problem is that the two lists are different, but some computer
exist in both. The first list is a complete list, the second one is
subset of the first.
How do I extract rows that are common into a separate spreadsheet
Message posted from http://www.ExcelForum.com
what do you mean by extract. from which file. do what
after extraction. why 2 files instead of 1 file-2 sheets.
>I have two spreadsheets.
>One is like this:
Is there a way to delete just the files in the Inbox
without having to delete the hole .pst. If possible
offline; without opening outlook.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the SWEN virus, all mail sent to my personal account will be deleted
After searching google.groups.com and finding no answer, Martin asked:
| Is there a way to delete just the files in the Inbox
| without having to delete the hole .pst. If possible
| offline; without opening outlook.
Martin <anonymous@disc...Unabel to Delete Mail From Outlook 98 In- Box
Subject: Deleting Mail From Outlook 98 In-Box
From: "Barry J. Koffman" <email@example.com>
Sent: 8/16/2003 8:05:50 PM
I am running Outlook 98 on XP Home Edition. It has run
fine until August 7th 2003. I elected to do the updates
form XP and after that date I have been unable to delete
e-mails in my inbox. I have also not been able to sync
by my PDA. I receivew an error message that I have an
interface error and to restart Outlook - This does not
solve the problem.
I have tried to reset the dates to previous dates before
the changes but I can not...how do I delete Salesperson IDs?
We are re-numbering all our Salesperson IDs.
I would like to delete the old ones to ensure they are not assigned to
accounts out of habit. However, I get the message "Commissions exist for this
salesperson. The salesperson record cannot be deleted.
We don't care for the sales / commissions history on the salesperson cards.
I set everything I could see to 0 (on the Salesperson Maintenance and
History), but still get the msg (ran checklinks just in case).
Anyone have some suggestions what fields I need to clear to allow me to
delete a Rep ID?
Thx a lot,
MS sells a Profe...Deleting Switchboards
I have created a form with controls to replace my Switchboard, but when I
open the database it is still looking for the Switchboard. How do I get rid
of this from wherever it is looking?
On Tue, 12 Jan 2010 16:24:01 -0800, Bill wrote:
> I have created a form with controls to replace my Switchboard, but when I
> open the database it is still looking for the Switchboard. How do I get rid
> of this from wherever it is looking?
Access 2003 or older?
Tools + Start Up
Replace the Switchboard listed in the Display Form/Page dialog box
with the name of the form you wish t...Two table query not giving expected result
I have two tables, contacts and companies, which are related by the companyID.
The value in the contacts tables is a result from the input form where for
avery contact one can choose the company using a combobox.
Now I would like to populate a list box using a query which as input uses
either the name (first or last) form one table or the company name from the
second table. (lets assume that in the contacts table a lot of names are the
same and that in the company table every record is unique)
I use the following query to limit the output to the selected values:
SELECT Contacts.ContactID,Cont...Characters /r/n%20%20 in blank tags?
I have a Webservice which returns an XMLDocument type. In viewing the raw
output steam, I noticed that if a tag value is blank, the data stream
actually looks like this:
A CR/LF followed by two spaces.
I have a special client to recieve this stream generally, but when I do
testing just with IE I note that the formating of such blank tag fields is
abbreviated -- perhaps this is something that was purposely designed to make
browser output look clearer.
But my question is this -- can I suppress this behavior?
* Harry Whitehouse w...Account Master tables
On the GP Account card, there is a checkbox to "Allow Account Entry". Does
anyone know what SQL table that is stored in?
The table name is dbo.GL00100, the particular column in question is
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> On the GP Account card, there is a checkbox to "Allow Account Entry". Does
> anyone know what SQL table that is stored in?
&g...deleted subject line
i have a user that sent an email to 40 different addresses, when she sent it,
it had the subject line filled in, after it sent the email the subject line
was empty. She is using outlook 2002 with Sp3 microsoft office 10 and we
have a win 200 exchange with SP3. is there a limit in the number of "To"
addresees that one email can support and would that have any bering on the
subject line being entries being deleted?
There is a limit on the number of addresses in the To: line - by default
it's 5000 in Global Settings (and fwiw, as high as 64000 in default SMTP
virtual ser...Cascading combo boxes
I would like to set up a form containing a combo box with a list of
mechanisms of injury. Some mechanisms have sub groups that I would like to
have visible by means of linking them with a cascading combo box. Is it
possible to have only some records from Cbo 1 link to Cbo 2? The examples I
have seen to date show cascading data for all records in the first combo ie
the city/state or postcode/suburb examples where every record has a sub
Thanks for your help.
If I understand correctly, you initially show just the first combo
(ex. cboInjury), and on ...Outlook problems -- deleted my mail acct., etc.
I am having a few problems with Outlook 2003 ("w/business contact manager").
I have already looked through the online help but can't find any answers.
1) My Hotmail acct. mysteriously disappeared from my email accounts and was
replaced by a "business contact database". I deleted that, but I don't know
where my hotmail acct. is (it was originally imported from Outlook Express).
Does anyone know why this happened? Having email accounts with all of their
messages is very bad.
2) I open a new message and click the "To..." label. In the form that pops
I've added a new Exchange server to my network, Exchange 2003, and I've
migrated all the mailboxes.
I'm not trying to uninstall Exchange 2000 off of the old server when I bring
When I try to uninstall it through add/remove programs, I get an error
message telling me that I can't remove it because "One or more users
currently use a mailbox store on this server. These users must be moved to
a mailbox store on a different server or be mail disabled before
uninstalling this server."
These are the boxes that are left:
SystemMailbox...what happened to the table controls
Just upgraded from Publisher 2000 to 2003 ... what happened to the control
"buttons" (the small tabs on the outside) on tables that would allow you to
select a row, column or the entire table?
Place your cursor close to the row or column you want to highlight, an arrow will
Mary Sauer MSFT MVP
"Rob Odum" <RobOdum@discussions.microsoft.com> wrote in message
> Just upgraded from Publisher 2000 to 2003 ... what h...Dimension Update and Pivot table report
I have an Excel (03) Report file which uses Analysis Services (SP4) Cube.
Works fine still using AS 2000 not 2005.
When I make any changes to Dimension and process Dim. and Cube Excel file
doesn't takes my Dim changes... I have to take (drag) the changed Dim. back
to field list and bring it back to report.... then only it works.....problem
is we have 100s of Excel Cube Reports.
Error I get: The item Could not be found in OLAP Cube.
Thank you - Ashok
...Changing font in rich text table
I want to standardise the font of all data in a table's rich text
field. If I use:
Dim DB As Database
Dim rst As Recordset
Dim strSQL As String
Set DB = CurrentDb()
strSQL = "SELECT tblReportTermly.Aims FROM tblReportTermly;"
Set rst = DB.OpenRecordset(strSQL)
Do Until rst.EOF
!Aims.FontName = "Calibri"
!Aims.FontSize = "11"
i get "Object doesn't support this property or method". Am I
approaching this incorrectly?
...Alternatives to MS Query for Pivot Tables & Cubes
I am using Excel 2003. I would like to know if there is an add-in or other
(preferably free) tool out there that I could use to create OLAP cubes for
Excel pivot tables that would have better functionality than MS Query. I find
MS Query very difficult to use and almost impossible for creating calculated
fields that can then be built into a cube. (Note: I thought I could just make
calculated fields in the pivot table itself, but now I see that Excel will
not let you do that when using an OLAP cube as a source.)
Any suggestions would be greatly appreciated.
Is there such a thing as a cascade copy? I know there's cascade delete where
if you delete the main record, all related subrecords are deleted but what if
I want to do the reverse. For example I have a quote that has subpackages
related to it. If I want to copy the main quote, I want all related
subrecords copied along.
Or is this a programming thing?
"Alan" <Alan@discussions.microsoft.com> wrote in message
> Is there such a thing as a cascade copy? I know there's cascade
...Delete a person from the drop down in the to field
How do I delete a name from my automatic drop down menu in
the to field. If I send a mail to fx.
firstname.lastname@example.org, the next time I write mic... in
the to field, the drop down menu keeps the address in the
list. How do I delete this name again.
use the arrow buttons to select it and hit Del
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Outlook Tips: http://www.outlook-tips.net/
http://www.poremsky.com - http://www.cdolive.com
Expert Zone http://www.microsoft.com/windowsxp/expertzone
Search for answers: http://groups.go...on NoData, show value in table
My report recordsourse is based on qrystudent where i have 2 tables.
'duration' table has 2 fields [from] and [to].
on NoData event of the report, I want to give message like 'You have not
logged in during ' [from] and [to]
If NoData, how can I give message include fields value in 'duration' table?
'duration' table has only one record.
Song Su wrote:
>My report recordsourse is based on qrystudent where i have 2 tables.
>'duration' table has 2 fields [from] and [to].
>on NoData event of the report, I want to give message l...Autocorrect entries creating and deleting
I have managed to delete Word's default autocorrect entries. How do I delete
multiple autocorrect entries that are under the replace heading?
Also, I am trying to add an entry called IM. Even though CAPS LOCK is on it
does not capitalize the letter i but it does the letter m and it looks like
this iM. Is there anyway to get around this?
Thanks for your help.
...Re-install a database/company after deleting the DB in SQL EM.
Can anyone list all the tables that need to be cleaned out if a company
database is deleted in Enterprise Manager before the company is deleted in
GP? I have mistakenly done this and would like to clear everything out and
set up that same database name again. No backup yet as it was a brand-new
migration database ( a poor excuse I admit) that had the migration run on it.
Thought we had it by clearing out the related company entries in the
SY01500, DU0000xx, SY40500, SY40502? and a few more tables, but the new
company setup still bombs on the very last step of the SQL setup (loading
I need to find out if the cascade delete option is set on any of the
tables in my database. Any help is greatly appreciated.
Mounilk (email@example.com) writes:
> I need to find out if the cascade delete option is set on any of the
> tables in my database. Any help is greatly appreciated.
Look up the catalog view sys.foreign_keys in Books Online.
Erland Sommarskog, SQL Server MVP, firstname.lastname@example.org
Books Online for SQL Server 2005 at
Books Online for SQL S...Updating table from a report query
I'm tracking production gate for several departments. I want to set one of
three switch in a tblGoals for a specific departmetn based on a calculated
value in a report query. The thresholds are .10, .50 and .75 there are also
three cutoff dates in a table called tblGateDates.
I pass the NRS (department), NCOPercent (the production goal), EndDate (gate
cutoff date), and the Gate (1, 2 or 3) which is the gate I'm trying to
determine the depart made or missed to a function.
Something not working right because near as I can tell based on message
boxes I've placed in the code ...How to restore a deleted Outlook 2003 contacts folder
I had first-level folders called bkgs_future, 0907, 0908. I deleted the first
one, and for some strange reason the others disappeared as well (althought
they weren't represented as sub-folders).
When I right click on Personal Folders and select properties, then click on
Folders it shows:
But when I click on 'deleted items' it list various folders but not these
ones. How can I retrieve these folders if they aren't visible in 'deleted
Why did it treat them as sub-folders when it didn'...deleting rows
I have used excel for years and have never run across
this is what I can do to get an error.
1. be in any file
2. save it
3. delete a row.
4. save it
After #4, it meeses up and give me an error of Modver
184.108.40.20607 Offset 0018d268 APPver220.127.116.1107 Excel.Exe
try cleaning out temp dir, reboot computer
Granite Shoals, TX
"charlie" <email@example.com> wrote in message
> I have used excel for years and have never run across