Delete records in a worksheet
I'm working on a simple program that lets the user enter, edit and
print the data. I developed the program using Microsoft Excel 2003 with
The problem is that, under Edit button I want to enable the user to
edit the existing data and save as well as to save as another name.
But, how to let the user delete the data in the worksheet?
When the user clicked on Delete button, an input box will appear as to
ask which data to be deleted. When the user entered the name of the
file, it will automatically delete the entire data corresponding to the
There are 2 datas with...How do I set up formula to copy format from one worksheet to anoth
How do I set up a formula to copy both value and format from one worksheet to
When I use the = sign, it copy the value only. How do I get the format be
you can't "link" the formatting in the same way as you link the contents
what you need to do is to copy all the cells in your sheet
X A B C ...
click on the grey square which I have illustrated with the X
this selects all the cells in the sheet
press control-C (copy)
go to your new sheet and select the same X square
now do edit > paste special > format / column width.
if you are doin...Is it possible to host one domain in two servers?
I'm currently working on adding a new server in a new branch location.
Right now I have SBS 2003 and it's working fine. The people in the branch
will just VPN in to retreive their emails. As that branch grows, there's a
need for a faster email. I'm planning to add a new Exchange server on that
branch machine. Is there a way to separate mailboxes to two different
servers under one domain? For example: email@example.com will go to
server1.domain.com and firstname.lastname@example.org will go to server2.domain.com.
Generally speaking, yes, Exchange definitely al...Record auto numbering
I suppose I shouldn't be concerned, but my record autonumbering jumped from
135 to 432,233 when I was trying to copy and paste common info. Any way to
reset? Access Rookie
If the numbers don't have "meaning" nor need to be sequential, no problem.
Actually if they needed to be sequential or have meaing, there would be a
problem as autonumbers often aren't as you just found out.
Still that is quite a jump. Copying and pasting can be a problem. It's
better to import instead.
You could empty the table, like exporting to Excel, then do a compact and
...Show <> Records Between 2 Tables ?? (ANTI-Join)
I've got 2 tables.
One has 2000 records (original)
The Second has 1000 (created from the Original with 1000 records removed).
There is a unique ID (which is in the Original and the Second for matching
like records...the CustomerNum).
I'm familiar with creating a query that would join them at the CustomerNum....
which would generate a list of records with matching CusterNums in each table)
In the New Query dialog box, there's a wizard to create an Unmatched Query.
That's what you're looking for. One of the tables has to be the "base"
table, so you m...error on excel 2000 when inserting new column
This message occur-" To prevent possible loss of data, Microsoft Excel
cannot shift nonblank cells off the worksheet. Try to delete or clear the
cells to the right and below your data. Then select cell A1,and save yur
workbook to reset the last cell used or, yo can move the data to a new
location and try again."
please help me about this.
Unless you specifically reset excels usedrange occassionally, you can find
that lots of inserting can mean that excel thinks it has data far more to
the right or below of where you think. If you then try to insert say a
colum...Assign Records to different organizations
I have a customer interested in CRM Titan as it supports multiple
organizations in one single installation but he has a requirement which is
the ability to assign a record (a contact for example) to a different
organization. For ex. I have Organization A and Organization B and I have a
contact in Organization A, and I would like to assign it to a user in
Organization B. is this possible?
The organization support in titan allows the same hardware to be used for
different installation of CRM. These organizations used sepparate databases.
So sharing data is not an out-of-the-box ...duplicate records
Hi, using sql2005. I want to select unique records from a table.
Unfortunitely the field that is used to sort the output cannot be in the
select distinct statement. Any ideas?
> Hi, using sql2005. I want to select unique records from a table.
> Unfortunitely the field that is used to sort the output cannot be in the
> select distinct statement. Any ideas?
If I understand correctly, you have a scenario like:
CREATE TABLE dbo.FooBar(
Foo int NOT NULL,
Bar int NOT NULL
INSERT INTO dbo.FooBar VALUES
...View All Records CMD button error
Hi all, Access 2007, Vista SP2, Ultimate 32 bit
I have a filter form on which I have combo boxes to filter by specific
criteria. I also have a command button that should open the record display
form to show all records with the following behind the button:
Private Sub cmdViewAll_Click()
On Error GoTo Err_cmdViewAll_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmMedsRec"
DoCmd.OpenForm stDocName, , , stLinkCriteria
MsgBox Err.Des...Unique records from a range
I have a problem that I cant work out...
I have a spreadsheet that plots out employees names and % worked o
programs (Rows) against a list of programs (Columns).
As the people can work on many programs I need to be able to create
formula that analyses the rows, creates a unique list of names and the
sums up their complete time worked on programs.
Obviously if it sums up to over 100% per employee, then I know th
resources are stretched and we need to hire in more people.
Is there any way of doing this?
I have attached a file that illustrates what I am trying to acheive.
I tried using ...Add Actual End Date to Resolved Cases view
We would like to add the actual end date to the Case General Tab or possibly
to the Resolved Cases and/or My Resolved Cases view. I know that the Actual
End Date is available on the Service Activity and Case Resolution but this
field is not available for the Case.
Any workaround for this?
...Use Data from one sheet to populate Purchase Order on another sheet -Excel 2002
Wonder if this is possible..
Sheet1 - has a 'list' of parts that need to be ordered - their description,
qty, type of material, part number etc
Sheet2 - I want to create a requisition from those items listed on Sheet1
based on type of material...
Basically need to take the data from Sheet 1 (can be 50 - 200 items/parts)
keyed in by designers and create a purchase order requisition for our
vendors/suppliers based on the type of material. Is there a way to extract..
say. material is H20.. and of them 50 items keyed in.. 10 of them are H20..
so that I can fill in the qty, descr...Can i let 1(one) person see the adress lists
(I really hope you can help me on this)
I have one user who needs to control who is on the lists on the exchange
server. I have hide the users who is on the lists from the domain users
becausethey change the users and cause trouble. Is there any way that i can
give this one user access to still view who is on the lists and
control/add/delete if she needs to.Please, please tell me this is possible
as it would make my life MUCH easier
On Tue, 27 Mar 2007 14:43:00 +0200, "MSExchange2003Student"
&g...Copying entries from one folder to another
We're using Outlook 2003 on Windows XP. Up until about a
week ago, I used to be able to create an entry in the
calendar and then use "Copy to Folder" to copy the entry
to my task list. I also used to copy & paste e-mail
messages into individual contact files or or task
entries. However, now when I try to Copy to Folder, I
get an error message "Cannot complete the copy operation.
The items may have been moved or deleted, or you may not
have sufficient permission." I can't copy anything and
the e-mail messages that have been copied into a contact
or ...Add items together after a sort
I've added the AutoFilter on a few columns and I would like a column to add
up. I know about subtotal(9,rage) but when I say add, not as in math, as
the column has text in it. It is a column of states (FL, TX, NY, etc.) When
I filter on something else I'd like to see at the bottom something that
looks like this if I had three rows after the filter. Lets say the states in
those rows were FL, TX & NY
What do I do so I get
then if I change the filter and I have FL, SC, NV, TX, WA I'd get
I'm using Excel 2007
...New DST time zone tool ALERT!!!
We are going through the DST changes here this weekend and it is a PAIN. We
have over 600 Public Folders that we are having to update manually.
If you use the tool built into MS Outlook 7, it will update all calendar
items regardless of the date. Some of our calendars have over 6000
appointments and the tool in Outllok 7 tries to update them ALL.
If you run the TZMove.msi file, it only updates the affected appointments,
NOT ALL OF THEM!!!!!
Of course Microsoft neglected to mention that in all of their documentation
on this issue.
Thanks Microsoft for another omission of...MS Office for Mac
I'm in the process of purchasing a MAC, but need to know if MS Office
for MAC include their One Note application. I use this app extensively
for work and it may be the deciding factor.
I searched and googled everything possible, but couldn't find the
In article <email@example.com>,
> I'm in the process of purchasing a MAC, but need to know if MS Office
> for MAC include their One Note application. I use this app extensively
> for work and it may be the deciding factor.
No ...New migrated users dont have Exchange attributes
After Exchange 2k3 SP1 installation user migrated with Active Directory
Migration Tool don´t receive Exchange 2k3 attributes.
Users migrated before SP1 installation, has these attributes.
Any suggestion ?
...Security Required for Record Merge
I am having a little problem with allowing users to merge records in V3. I
have created custom security roles ensuring that the 'Merge' option in the
Misc privileges section of the Business Mgt tab is set to 'Organisation'.
Even with this set, the users get an error that they do not have access to
Merge if they try to merge accounts or contacts.
If I give them the 'System Admin' role they can carry out the task OK. If I
copy the System Admin role and remove the customisation privilages then they
again get the error. It is not to do with owners of the reco...Recorded Macro Codes, Contain Errors
I had tried using Marco Recorder to get the codes required for plotting a chart
It appears that the codes are given incorrectly, there are certain part of the codes have runtime error
ActiveChart.ApplyCustomType ChartType:=xlBuiltIn, TypeName:=
"Line - Column on 2 Axes
ActiveChart.Location Where:=xlLocationAsNewSheet, Name:="asdasd
.HasTitle = Tru
.ChartTitle.Characters.Text = "charttitle
.Axes(xlCa...new mail notification #4
Have a user that has had the little envelope disappear, so
when she gets new email now it does not show up in the
tool bar, i've looked everywhere but cant seem to find
where the settings are for this, she is using outlook 2000
...New email notification and unread mail
System: XP/Outlook 2003
I have about 20 rules that redirect my incoming mail into my subfolders.
I’ve set up a rule that displays a new mail desktop alert no matter what.
Now, I would like to have an envelope in the system tray if there is still
anything unread – just like in the old version (I think OE works the same
way). Is it possible?
Anyone? Should I just not file messages before I read them?
"Stan Q." wrote:
> System: XP/Outlook 2003
> I have about 20 rules that redirect my incoming mail into my subfolders.
> I’ve set up a rule that displays a new mail des...Selecting particular records #2
I have an excel sheet with dialog box having default values.I wan
particular records from the sheet when I click any value in the dialo
box.Like when I click the first value it should show me the 1-5
records and for the second value it should show next 50 records in th
sheet.I would appreciate if someone helps me.
Message posted from http://www.ExcelForum.com
If no one else responds, send me a sample sheet or your
workbook up to 1mb, and I will write something for you.
Please provide as much info as possible. But what you may
need are scroll bars that, when moved, show...New iMac
I just bought my first Apple computer after many years as a PC user.
I currently take classes on line and had to download a test drive
version of Word. I have purchased MacOffice but it says to uninstall
any test drive versions first. How do I do that?
Second, how do I set up a Password protected desktop. That way when
the computer is powered up, no one can have access unless they have
On 30/1/07 19:46, in article
> I ...move a row of data from one work sheet to another using a formula
Hello, I am trying to create a formula that will move the contents of an
entire row in one worksheet or multiple worksheets into a single worksheet
that accumulates all the rows. Specifically, I have multiple worksheets
created that have the same format as far as the cells and rows go. The text
in each cell and row is different and some of the cells contain formulas.
There will be a column of cells with no text in each worksheet. When I enter
a number into that empty cell it changes the numbers in a few of the other
cells within that row. I want the rows with values in the c...